Home : Bytes IT Community / View Full Version : MS SQL

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

  1. Calculated fields...
  2. ODBC DSN connection fails from MS Access 2000 after SQL2005 mirrorfailover
  3. Microsoft's SQL Server and related products.
  4. SQL Server data dictionary
  5. How to use stored procedure parameter in sql-statement?
  6. Indexing Low Cardinality columns in a data warehouse scenario
  7. UPDATE query gives Incorrect Syntax error
  8. large data : how do you store multidimensional data ?
  9. DELETE only deleted 10000 records
  10. database problem
  11. Tweaking SQL to optimize the query execution plan
  12. Help Needed For writting a query (SQl Server 2005)
  13. How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?
  14. SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
  15. Different empty_string/NULL handling under ODBC and OLE DB?
  16. Project Management Knowledge Base !
  17. sql squeries
  18. Query with different WHERE clauses
  19. sql queries
  20. Truncate text in table? (ie 101928494 will become 928494)
  21. SQL Server 2008 Final release date
  22. relationship
  23. sql queries
  24. not showing proper datetime in tables
  25. sql server queries
  26. plz suggest me the query
  27. IT auditing tool SC Magazine Review
  28. Creative query assistance needed
  29. How to find out difference between two rows....
  30. SQL Server Engine Downgrade
  31. SQL 2000: Transport-level error on SELECT statement
  32. dropped tables
  33. Trying to insert a zero, its telling me i cannot insert a null
  34. A Question on query efficiency
  35. How to deploy a database on SQL Server Express 2005
  36. Can Analysis Server and Report Server run on SQL Server 2000 Cluster
  37. Jobs, Interview Questions, Certification, Knowledge
  38. Re: SQL Server 2008 caching
  39. Re: SQL Server 2008 caching
  40. select blocking sessions t-sql
  41. Write "Messages" window to a log file?
  42. Deduping
  43. Yellowfin seeks resellers for BI product
  44. load_file and blobs
  45. Using a Trigger to determine when a column was changed
  46. Data returned by SQL Server ODBC driver is not correct
  47. Certification in Mind???
  48. Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
  49. Finding duplicate records
  50. SQL 2000 DTS tool - 256 char limit?
  51. Linking Windows SQL Login to user database
  52. Calling Commonly Used SQL (reusable code)
  53. Export to Excel, exclude header
  54. Can a dropped table be recovered?
  55. How to show field that not being group
  56. Softclarity Builder
  57. Accepting wildcards like % in input parameters of stored procedures
  58. Distinct Row based on description count
  59. Re: problem with column alias
  60. Re: problem with column alias
  61. just u click make a money online
  62. Having problems using BCP for CSV output
  63. Re: ALTER proc vs IF EXISTS DROP/CREATE
  64. ALTER proc vs IF EXISTS DROP/CREATE
  65. Delete Trigger
  66. Intrusion Detection Strategies
  67. SQL Server Scripting Question
  68. sql server query problem
  69. Insert Into Select trouble
  70. SNL Sql
  71. ms sql 2000 - create update script
  72. SQL Query for Dummies
  73. CONVERT() problem
  74. Latest updates in database management and SQL server tools andtechniques
  75. Da MySQL a SQL express
  76. T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
  77. unable to install SQL Server 2005
  78. Re: Best practice on nullability and default value
  79. Formatting datetime when including in a PRINT command etc...
  80. Pb to open an attached mdf file
  81. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  82. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  83. Patch for KB948110 causing random "Could not find database table ID"errors
  84. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  85. How to compile TPC-H ver2.7 on Windows XP?
  86. complicated query (where statement inside select statement, don'tknow how to explain it)
  87. Insurance data models...any tips on good starting point?
  88. Are Deadlocks inevitable ?
  89. Help With Full Text Search. Performing AND across columns
  90. rupdating duplicate entries with random numbers
  91. Changing the name in the ServerName column
  92. Schedule a Query
  93. Multiple attribute design that need to be searchable
  94. Multiple attribute design that need to be searchable
  95. Sql Server 2005 Replication
  96. does this backup sequence commit all data to the database
  97. SQL problem - a variation on outer join
  98. BACKUP LOG questions
  99. Could not execute a package by a scheduled job
  100. dbcc shrinkdatabase
  101. Testing
  102. DB Structure Advice - lots of measurements in DB or file refs?
  103. programmatically stopping and starting transactional replication
  104. login failed
  105. Data loss importing from Excel
  106. transaction log
  107. How do I number an output field consecutively?
  108. Database management and latest updates on SQL server
  109. Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
  110. Cursor among several databases
  111. design issues with large amounts of data
  112. SELECTing from a DML statement
  113. Using UPDATE to sequentially abbreviate address information
  114. Odd character appended to data
  115. Datetime import/export issue
  116. Yellowfin Business Intelligence Release 4.0 Announced to Industry
  117. slow queries for a particular database
  118. sql agent JOB to Backup Database and Maintain Backup Files
  119. Need a script to recreate scheduled jobs
  120. Help needed for Data formatting.
  121. How can I do that using a trigger
  122. OLEDB configuration when deploying multiple SSIS packages
  123. Decimal point and comma
  124. Re: Stop hotlinking to a specific file & keeping a counter
  125. Please Help - Can't check for duplicates
  126. Deploying an app with SQL Server (installation on client machine)
  127. How to secure a database ...?
  128. Can I search for a string in a set of stored procedures?
  129. GROUP BY a computed column
  130. Creating a database from set of TSQLl files
  131. Concatenate in MSSQL
  132. Storing BLOBs outside database
  133. Re: Duplicate Tests - Help Please
  134. Re: Grouping by Day for a Date Range
  135. Question about recompiling a dll
  136. table naming convention about this case..
  137. Latest updates on SQL server 2008 tools and techniques
  138. Computing a column that is a percentage of the sum of another column
  139. Database security (non-existent?)
  140. Tool to chase down the consequences of adding field to DB tables?
  141. Applying tranaction log to old data file
  142. Re: Database naming conventions?
  143. Latin1_General_BIN comparing two char strings
  144. alter table query not working after working at least once. MS SQL2000
  145. Re: Database naming conventions?
  146. Re: Database naming conventions?
  147. Transact-SQL for Restore Filelistonly using a variable
  148. Toad for MSSQL problem: closing script file doesn't "release" thefile?
  149. bcp out in UTF-8 format
  150. Kuljetusalan ongelmista
  151. Basic SQL Statement Question
  152. Differences between relational DB and warehouse ?
  153. tbl_A CROSS JOIN top 1000 rows of tbl_B?
  154. bcp out empty string into csv files
  155. C++ API for SQL Server?
  156. SQL 2008 EULA and pricing
  157. SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
  158. Performing multiple bulkcopies for different tabels
  159. stored proc with datetime
  160. Forget about Referential checks??
  161. Re: Not finding GUID value after migration sql 2005 to 2000
  162. bulk insert in clustered index table
  163. Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
  164. database design
  165. Re: Not finding GUID value after migration sql 2005 to 2000
  166. DB migration
  167. Newbie basic questions
  168. HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
  169. Anyway to declare and use variables in a View
  170. MSDE upgraded to SP4 but showing SP2
  171. Select from a access table
  172. Migration of an Access Database. How is the best way?
  173. Problem connecting to SQL Server from Access Database
  174. simple SQL engine
  175. Fuzzy logic for duplicate identification?
  176. Full text search in albanian
  177. database owner?
  178. Convert Int to Date
  179. IF within SELECT
  180. live online training
  181. Re: "Maksanhierontalaite" ; )
  182. Problem With View and Changing Field Length
  183. stored procs
  184. Looping Through the Records returned from a DTS Lookup
  185. Snap-in failed to initalize.
  186. Compound vs Simple Indexes
  187. Re: Ruuska
  188. Not an ad hoc query?
  189. Stored Procedures and Commiting Data
  190. Connect problem
  191. Dell c610
  192. Re: search pyrkii nettiin
  193. Using Case within Select
  194. SQL 2005 report deploy issue
  195. Is this a correct table structure for my database?
  196. How to find if instance is cluster or non-cluster
  197. SQL Server 2008 - Filestream
  198. Error running DTS script in VB
  199. SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
  200. How do do a query against hardcoded row values
  201. Need SQL Server Dasbase Admin
  202. simple ALTER Table query question...SQL 2000.
  203. Disabling Triggers
  204. Installing sql server 2000 on windows server 2008
  205. Update Query Runs Forever
  206. Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
  207. How to sell sql skills? (Need your knowledge and thoughts)
  208. (Newbie) Join problem.
  209. Problem with joins in SQL.
  210. where do I download sql odbc drivers from?
  211. Re: Connection pooling issue with pass through queries
  212. Join zero padded char to varchar
  213. Re: Connection pooling issue with pass through queries
  214. Re: Strange select
  215. Re: Strange select
  216. Re: Need Help With an Update Script
  217. strange Problem
  218. your thoughts on this please
  219. SQL Server 2000 UDF Intermittent Slow Execution
  220. Sysmergesubscriptions question
  221. examples with SS2008 -xEvents?
  222. Need Help With an Update Script
  223. delete a named instance - how?
  224. SQL Server Browser service?
  225. select from two tables
  226. Strange connection problem
  227. Help with an Update Statment
  228. Install new instance...
  229. Simple Query Question
  230. Where's my instance???
  231. DBMS advantage and disadvantage
  232. Rename Default Instance Name SQL Server 2005
  233. Cannot Read Varchar(max)
  234. relocating Outlook Business Contact manager
  235. confusion over indexs via primary key and clustered index
  236. Link to external file
  237. SQL Excel - freeware add-in for excel
  238. Modeling/Constraint question
  239. Email Generation from within SQL/Server 2005
  240. Re: SELECT Optimalization
  241. Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
  242. Help with SQL Backup Problem
  243. DTS Transfer Data Task - output to text file with field names infirst line
  244. I want to update the column in a table based on the updation of theother column in the same table
  245. syscharsets unicode
  246. nested stored procedures and returning lots of rows
  247. Checking for duplicates in a database table
  248. firewall rules for SQL Server
  249. Modifying registry information to change type of login logging
  250. Suggested DB Reverse Engineering tool...
  251. Local Security Policy - Restricting Access
  252. Cursor and Procedure
  253. select from row1 to row n
  254. Reattaching database - identity_insert set to off
  255. Most Helpful Professional Award
  256. Cross Database Select
  257. Merge process could not update the list of subscriptions
  258. a and (b or c) better than (a and b) or (a and c) ?
  259. caching table Problem
  260. How to return a Pk value from one stored procedure to another storedprocedure
  261. create dynamic variable in procedure
  262. Advanced SQL Cubing
  263. SQL 2005 on Windows Server 2008 - Slow Connection Time
  264. Re: Display duplicate rows
  265. Help!
  266. Re: comp.databases.ms-sqlserver
  267. Altova v2008r2
  268. Urgent: Deciphering binary code executed against the database
  269. copying row from same table and adding value from form.request
  270. Doing a SELECT INTO using a Stored Proc as the data source
  271. SQL Statement Problem : Separate long varchar into word seqments 35chars long
  272. Setting SQL Server Agent Account without being part of a domain
  273. Limiting table access using stored procedure.
  274. SQL Select All Items where one meets the criteria
  275. optimal selection of all records for a certain month (illegal datesOK?)
  276. updating multiple columns with subselect
  277. Selecting several types
  278. Prevent Excel and Access access to SQL 2000
  279. Read HTML File though Network for Email.
  280. Disable and Rebuild or Drop and recreate Index
  281. Force protocol encryption on hosted database
  282. How to implement Audit/Alert for Row level access?
  283. Orphaned tupels, should I clean or is it ok to leave?
  284. Full text indexing scheduler SQL Options
  285. SQL and Database Design newsgroup
  286. ASP.NET 2.0 not connecting to SQL Server (not web.config)
  287. Help with bbrowser cell focus ?
  288. Client applications
  289. Re: SELECT * vs SELECT col1, col2
  290. COLUMNS_UPDATED() with triggers
  291. Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
  292. beginners question...
  293. Conditional data copy SQL Server to Oracle
  294. Can you tell who last edited a SProc, and when?
  295. Select CASE returning NULL value
  296. Why freetext query become very slow all of a sudden
  297. Select date in british format
  298. back up jobs, re-index question
  299. MSSQL - MySQL
  300. file crawler
  301. How to recover deleted records?
  302. capture and save running sql query to database table (for logging)
  303. Use of having with additional select
  304. design question - type heirarchy with supertype queries
  305. Performance question concerning varchar(max)
  306. Yet another basic SQL question
  307. using LEN to find a first word greater than 17
  308. Job ends successfully even when it's not true
  309. exporting a table with long field names to Access
  310. Basic SQL Question
  311. FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
  312. Another new DBMS
  313. copying data from one server to another
  314. How to find records with length greater than 17
  315. CHECKSUM to determine record changes
  316. first minimum date in the column for each distinct column a value
  317. Re: Get rows whose sum matches a value
  318. The Sql ranking OVERture
  319. sp_prepexec syscomments?
  320. select parent records that do not have a particular child
  321. how to create my own primary key which auto-increment
  322. Re: Get rows whose sum matches a value
  323. Re: tempdb size question
  324. Re: HELP WITH SELECT STATEMENT PLEASE
  325. SQL Server 2005: functions become slow after a while
  326. How to get the sql statement of a view? (by running a query or from ado.net)
  327. Granting permissions for a user from another database
  328. Login Seems OK but doesn't behave correctly
  329. table trigger just hangs
  330. SQL Server Management Studio
  331. Dump table as INSERTs
  332. Query Japanese Text in an NVarChar?
  333. SQL 2005 XML Searching
  334. import ADO DLL
  335. Performing Bulk Load of XML Data
  336. case-when error
  337. Secure Auditor, 30 security tools at the price of one.
  338. Secure Auditor, 30 security tools at the price of one.
  339. Finding "missing" rows
  340. Login failed for user 'sa'. Reason: Server is in single user mode.
  341. Re: T-SQL Duplicate Record Help
  342. Connection String on shared server- Almost there but need a littlehelp
  343. Please recommend SQL book with excercises
  344. Re: default value wich is not in DDL.
  345. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  346. where do I download sql odbc drivers from?
  347. (Newbie) Join problem.
  348. Problem with joins in SQL.
  349. Join zero padded char to varchar
  350. Constipated publisher (SQL 2005)
  351. PHP/MS SQL - automatic formatting: varchar, datetime
  352. xSQL Profiler - monitor multiple SQL Servers from one centrallocation
  353. How do I make a backup device file smaller ?
  354. SQL 2005: Renamed 'sa' account
  355. Client side insert update
  356. help,a regular text file how to sql 2000 table code ?
  357. Problem Connecting .NET app to SQL Server
  358. An optimum query..?
  359. boot camp
  360. getting tables that link to a table
  361. [IAT ELEZIONI] Presentazione candidati
  362. Simple Concatenation Question
  363. List Columns in a Table in SQL 2005
  364. SQL Assistance required
  365. Error History?
  366. Deleting multiple columns from multiple objects
  367. from 'image' to 'varbinary(max)'
  368. What does it mean to SET a value?
  369. Complex Calculation
  370. difference between explicit inner join and implicit
  371. delete output into <xml column of audit table>
  372. testing if value is null
  373. Internal query processor error
  374. Violation of primary key
  375. CASE WHEN Equivalent in WHERE Clause?
  376. Uninstall SQL 2000 Workstation Components
  377. Scalar Subquery in MS-SQL Server 2000
  378. Scalar Query in SQL Server 2000 like in oracle
  379. SQL 2005 Express - problem with no "SQL Serevr Agent"
  380. SSIS security
  381. converting SQLTable to Excel Sheet
  382. dbrpcparam datalen problem
  383. ADO vs ADO.net
  384. SQLServer - VC++
  385. DLL -> Database
  386. SQL Server
  387. help with DDL trigger. Moved from other newsgroup.
  388. UTF-8 Coding of MSSQL 2005 DB
  389. how to calculate rank in selected records in sql server 2000
  390. SQL Server - synchronizing database changes across servers
  391. Rounding not working
  392. Getting record position in sql server 2000
  393. Deleting Tables
  394. call script from another script
  395. nub question :(
  396. Triggers and Flag bit
  397. IO Completion Listener
  398. Selecting alphanumeric combinations that do not exist already intable?????
  399. Doing Summation on multiple criterias on the same column in a singlequery
  400. Data Type
  401. Table Schema
  402. Data Shifting Between Records
  403. Duplicate key ignored AND statement terminated
  404. Moving SQL 2000 to a new machine by copy-paste !!
  405. SQL 2005 Workgroup Edition - how to run a trace
  406. SQL2005 performance problem
  407. Inserting nothing takes a long time
  408. Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
  409. Can users be connected during a SQL backup?
  410. job died but why?
  411. What privilege is needed to run DTSRUN ?
  412. using fn_trace_gettable on trace files where the path contains aspace.
  413. Trigger to modify a table
  414. Allow Guest account in Windows XP professional to use sql server
  415. Car-Sharing Offered - ICC Birmingham MS UK Product Launch, 19th March
  416. Bigint from a SQL Server table and viewing with Access
  417. Where is SQL Server Enterprise Manager?
  418. MS SQL SERVER DBA/ CONTRACT/ IN
  419. Triggers
  420. help - extracting metadata
  421. osql
  422. DateTime Automatic Formatting
  423. Result Row
  424. Name value pair
  425. MS SQL Trigger to update changes in a record
  426. function to extract delimited data
  427. ssis Bulk insert failed "Received an invalid column length from thebcp client...".
  428. Creating custom Primary Key in SQL Server 2005
  429. Email
  430. copying data WITHOUT DTS
  431. Top companies recruiting this weekend - Apply with updated resume
  432. Exam 70-229 :Designing and Implementing Databases with Microsoft SQLServer 2000 Enterprise Edition
  433. How to decode in SQL Server 2005
  434. How can I format a datetime as 'yyyymmddhhnnss'?
  435. SQL Server 2005 Licensing concern.
  436. Lost Full Text catalog that won't delete!
  437. History Tables: Always Subtables?
  438. Removing 1 hour from text field
  439. Linking error
  440. How can I use variables in this TSQL Statement
  441. query help sought
  442. where is import and dts on sql server 2005
  443. checkbox
  444. windows form
  445. Using findstr on SQL 2005 ERRORLOG file
  446. Transfering data from SQL Server Standard to SQL Server Express
  447. Query - select common data from one column and display in severalcolumns
  448. ado net
  449. Using a "match" table to store multiple columns for parent data
  450. Deleting a maintenance plan
  451. Problem with a lot of inserts in short time - SQL Server 2000
  452. Syntax to access database on another server
  453. reduce time for search query
  454. Error on Transaction log backup
  455. Backup Exec and MS SQL Server 2005
  456. Track changes made to SQL Server
  457. Need help with SQL Server Cluster
  458. Urgent IT related openings with Corporate MNC companies all overIndia
  459. SQL database hang
  460. Query string encryption in T-SQL
  461. DB size increase from SQL 2000 to 2005
  462. SQL question ( retrieving records based on a priority order )
  463. Use unique key for Sqlserver view for updates
  464. Help with SQL Query for Graph
  465. UPDATETEXT question
  466. Inventory SQL Server machines on your network
  467. Why Same query results in two different # in SQL Server vs MS Access
  468. Count from detail table
  469. Want to learn SQL in California....any school, literaturerecommendations?
  470. Freshers Recruitment & Walk-in For Freshers Feb 23-24
  471. Table replication question
  472. Slow performance in SQL2005
  473. Query Plan Tool on my web site
  474. Online Query Tool SQL Server 2005
  475. Log File Recovery.
  476. Problem With SQL UPDATE
  477. SQL Server Performance Issue
  478. Help Needed For writting a query (SQl Server 2005).
  479. CharIndex, Left T-SQL question
  480. importing multiple excel files
  481. Trigger Question
  482. need of SQL Dumps
  483. SQL 2005 OSQL qestion on Microsoft cluster
  484. Adding conditions in the ON clause of a JOIN
  485. Enum the running SQL instances using DMO
  486. Interactive Sort on Matrix in RS
  487. How to check setting of CONCAT_NULL_YIELDS_NULL
  488. Why does Error log show database restarting everytime a transactionlog backup runs?
  489. Urgent walkin interviews from top rated companies
  490. Problems character sets / special characters dot.Net <-> mssql-server
  491. on line discuss
  492. Primary Key fails to copy in db Export
  493. System DB backup Error
  494. Why does numeric data type use storage inefficiently?
  495. Create a new table from csv file using SSIS
  496. Distributed Transactions across Linked Servers
  497. Help in Table level restore/backup
  498. sql server migration issues
  499. Rowlock v. optimistic concurrency
  500. Crosstabbing (or rotating) a sql table
  501. Need help writing a stored procedure
  502. sql learning
  503. autonumber
  504. Transfer data to web page fields
  505. Inserting multiple records into two tables...with a twist
  506. trig errors
  507. Alert doesn't work on SQL 2005
  508. REPLICATION
  509. Select statement query
  510. multiple numbers in one statement
  511. Deploying CLR trigger to SQL-Server 2005 -- Permissions Required.
  512. Rmote database inserts blocking local queries.
  513. Performance issue using conditional WHERE clause
  514. Months Between
  515. Problem migrating DTS to SSIS
  516. Unable to attach the database
  517. Help-VB.NET and SQL Server 2005
  518. NULL values in a SELECT in another SELECT
  519. Query Question
  520. removing unused objects - SQL Server 2000 or 2005
  521. Timestamp Precision
  522. Access 2000 and SQL Server 2005
  523. Stored Procedure to list out user access
  524. I need to know where mssql server stores its data.
  525. TempDB won't shrink
  526. Design question regarding junction tables
  527. Variables in SQL-script SQL2005
  528. sql mager
  529. SQL Sort Problem
  530. duplicate checking
  531. A dimension playing off another dim
  532. Need Help Importing Data from Excel to My SQL Database
  533. Biztalk vs SSIS as an ETL tool
  534. A philosophical question about inserts
  535. SQLServerException: The TDS prelogin response is incomplete.
  536. 16GB Ram 64-bit server, what configuration to use?
  537. T-SQL Sudoku Game
  538. SQL 2005: Transactional Replication > Executing sp on subscribershould execute on publisher
  539. SQL SERVER 2005 SP2 post upgrade issue
  540. error when connecting to sql db
  541. Queries Log on SQL Server 2000 ???
  542. Output to text-file
  543. Formatting Numeric Value in Computed Column
  544. check the word whether correct or not
  545. Create Delete Trigger on Table1 to Update a filed on Table2
  546. [Announce] DataDirect XML Converters 3.1 Released - HL7 Support
  547. using freetds tsql
  548. working with a local db copy
  549. Dropping an active connection on an attached database
  550. Selecting SUM and COUNT, but not straightforward..