View Full Version : sql server answers


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 25 26 27 28 29 30 31 32 33 [34] 35 36 37

  1. SQL Update query to copy data
  2. Find blocking process
  3. Linked Server to Oracle
  4. xp_sendmail
  5. xp_sendmail with long text messages
  6. Relational Model and XML
  7. SQL join query
  8. SQL Debugger not stopping on remote machine
  9. Running a SQL file from OSQL command line utility
  10. Help: Prob handling SQL error in stored proc
  11. Reporting Suspicious Financial Transactions
  12. generating seq no with in a main column
  13. Hand needed with t-sql
  14. Rollup Query Help
  15. Cascading Delete
  16. RESULT IN FLOAT
  17. Very Big Table Problem
  18. UPDATE STATISTICS necessary to improve performance (?)
  19. HELP - Selection of Development Software? Thoughts??
  20. DATE FORMAT/SYNTAX QUESTION
  21. UPGENT HELP
  22. Urgent Help Needed
  23. SQL Server too slow
  24. convert 0 or NULL to 1 for devision purpose
  25. Returning recordset that includes a DateDiff field in hh:mm:ss format?
  26. Execute SP_password
  27. USE statement with variable
  28. Problem with Setting a variable in SQL String
  29. Optimise these 3 queries into one?
  30. How to insert a row in a table with 1 identity column
  31. sql statement
  32. C with ODBC
  33. OLAP and/or data mining?
  34. The Median Function in SQL Server
  35. query needed
  36. subquery performance mystery
  37. Wanted: Dead Hard Drives
  38. Help with a trigger
  39. PK And Index
  40. Deadlocks workaround?
  41. How to do a "year-to-date" SQL query where "year" commences in August?
  42. Moving data to SQL Server
  43. Could u tell Storc Proc in Access..
  44. Client Side Cursor vs Sever Side Cursor?
  45. Unusual Query
  46. syntax of sp_prepexec, sp_execute
  47. MSDE Install fails. Please Help someone
  48. Chinese and Japanese characters in same colation
  49. Index parameter
  50. Two order by's in same stored procedure?
  51. apostrophe
  52. table last modified date/time?
  53. Equivalent to database events
  54. MSDE Maintenance
  55. Inconsistant query results with Count(*)... bad index?
  56. SQL Merge Replication and DTS imported Data
  57. MSDE 2000 Versions
  58. Table size
  59. Tables have too many nullable columns
  60. How many records in a table?
  61. How do I delete many rows without monopolizing server?
  62. Converting timestamp values from Varchar to varbinary(8)
  63. Moving from one server to another
  64. Replication target table shrinks to zero
  65. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  66. sql server limit
  67. Include data in e-mail
  68. Identifying specified parameters in stored procedures
  69. Update multiple databases
  70. Can I generate XML schema
  71. SQL syntax - "NOT IN"
  72. import txt from http
  73. Job Aborting ???
  74. Making a User in MSDE
  75. How to find group user login Name
  76. delete a primary key with T-SQL
  77. Parallelism Question
  78. SQL Server Does Not Start
  79. Check constraint across parent-child tables
  80. Stored Proc Error Handling
  81. Convert NULL Values
  82. stored procedure question
  83. Logging uses of SELECT ??
  84. Stuck with WHERE clause with multiple elements
  85. Looping columns in instead of trigger
  86. Index on a varchar column?
  87. Table Design Question
  88. problems with datatypes Navision in SQL
  89. Formatting numbers with commas in TSQL
  90. strange query timeout
  91. The articles on my web site
  92. Backup / Restore Question - MSDE
  93. insert statement help
  94. auto-grow gotcha
  95. NEWB: Moving DBs to new install of SQL Serv. w/o sp_detach_db
  96. Find what procedure was exec'd
  97. Install SQL 2000 on Win XP Home
  98. Formatting a float in varchar but NOT in scientific notation
  99. SQL Server 2000 - problems when installing Windows 2000 SP4?
  100. Should floating point calculations be doing in sql or C#?
  101. Disappearing Linked Server Stored Procedures
  102. RAC chat tonite
  103. Using the Transact-SQL Debugger
  104. sorting some data...
  105. Help restore a database!
  106. Deadlock on single table
  107. Best Practices for Large DB
  108. DTS from SQL Server to DB2
  109. Is @@IDENTITY reliable?
  110. FullTextSearch in multiple tables
  111. Mysql and C++
  112. Error while Installing SQL Server evaluation version - sqlunirl.dll not found
  113. Hidding column in query
  114. SQL INSERT
  115. How do I get db ddl properties from sql 2000 like documenter does in MS Access?
  116. Table Design Question
  117. ASP search screen and MS-SQL 2k
  118. Data Conversion Issue
  119. Balancing IO. File Groups vs Raid
  120. Application Generator
  121. Web based reporting software?
  122. SQL Server ADO/ASP Application and Connections
  123. AutoShrink Transaction Log File
  124. Insert Select Help
  125. Licensing Sql Server.
  126. SQLS7&VB6 Date Update Gives Syntax (Not Date Format) Error In Stored Procedure
  127. Another Query Question
  128. Changes since last backup?
  129. SQL Server text field
  130. HELP - Scheduling DTS Packages
  131. VSS & SQl2000 integration
  132. SP_LOCK Question
  133. This is one solution to the "Key column information is insufficient or incorrect" problem
  134. Decrypting WITH Encryption User Functions...
  135. Determine the last time SP was executed
  136. Pooling Connection Object
  137. Maintenance plan history - where does it come from?
  138. Is it the Index ?
  139. Scheduling a DTS Package
  140. Low performance when using parameterised query
  141. QUERY Question
  142. SQL Select Question
  143. Any possibility of creating a MUTUALLY dependent CHECK
  144. Processing User Activity Table
  145. Recover a corrupted LDF file
  146. Problems importing data into sql server
  147. reduce trans log size; help needed
  148. Changing column order in a table
  149. Exporting data while people are using the site?
  150. How do I back-up > truncate > shrink > back-up SQL 2000
  151. Help with delete trigger
  152. DSN Problems
  153. Connection Management
  154. Restore database via automated order
  155. Scheduled Job History
  156. SS & QA
  157. The best book
  158. MSDataShape problem using SQL server 2000
  159. why i cant setup password in mysql
  160. Pull data from Cache 5.0 to SQL 2000 (fast?)
  161. Memo field problem using Access97 with SQL2000 Backend
  162. Cursor help PLEASE!
  163. Date Stored Procedure
  164. FK Checks
  165. Return versus Raiserror
  166. Getting the latest row from a batch
  167. Database Permission
  168. SQL Server disk sub-system (overhaul) performance questions
  169. help with stored procedures using IN / GROUP BY statements
  170. Install that update from the Microsoft Corporation
  171. Transaction Logging Backup Set
  172. Any Migration issues???
  173. Setting up SQL Server for Remote Clients
  174. Need help with MS SQL query
  175. Removing duplicates
  176. error 1012: the correlation name '%' has the same exposed name as table '%'.
  177. sqlserveragent hangs when starting
  178. Need Help for query
  179. Records getting deleted mysteriously..
  180. Timeout Expired Error
  181. Creating Mobile Database on Pocket Pc
  182. sql server 2000 and windows xp home edittion
  183. DTSRUN.exe Application error Problem
  184. Surely not!
  185. Finding all references to a column
  186. Preventing logins/users from having more than one active connection
  187. 2nd CFV: comp.databases.etl
  188. MAIL
  189. How to do this self-join??
  190. How to do this self-join??
  191. SQL Server 2000 Exam #70-229: Good book?
  192. Mysterious mystery -- 2002-11-08/2002-11-09
  193. Triggers on Delete and on Insert & SQL Server 2000
  194. table mantenance within a replicated database
  195. Altering linked tables
  196. Internet Queries
  197. Connection failed between PC
  198. Book Recommendations Needed
  199. SQL Profiler on a Prod System...is it safe?
  200. Sort Order and case sensitivity
  201. Internal memory increased; SQL Server does not use this
  202. event id: 998 - Unable_To_Set_RegKey_Val
  203. Outputting Data From Stored Procedure
  204. mysql immediate assistance needed please.
  205. Restoring DB
  206. SQL Help, Urgent
  207. Problem with multiple joins.
  208. View Users Connected to SLQ Server?
  209. Server side Cursor
  210. Problem with trigger and DTS
  211. Column Name in a Primary key constraint
  212. Using Openquery Without Returning Resultset
  213. Converting SQL Loader control files to BCP format files
  214. Problem with FETCH LAST
  215. How do I use constants in stored procedures?
  216. Timestamp
  217. "Tree View" with a SQL Server Database
  218. SQL Server 2000 concept
  219. Curious performance issue when running a query
  220. Incorrect host-column number found in BCP format-file
  221. Stored procedure won't use index
  222. Restore a remote backup
  223. Help! Index corrupting? DBCC CheckTable failing?
  224. ISQL and OSQL Output Lines Wrapped Around at 256 Characters?
  225. Unique Field conflict in Views
  226. Last modified date of a view
  227. Performing Completion Actions, cursor_close_on_commit setting
  228. "Org Chart" Type Tool?
  229. Dynamic SQL
  230. Opinions on ListCleaner ( WinPure ) ??
  231. QA returns different records from SQL Server EM
  232. Problem with import data from excel format file.
  233. Using xp_cmdshell in a trigger
  234. GUI for Sql 2000
  235. Store procedure help
  236. decimal places
  237. Getting Number of Logged On Users to Server
  238. can't open 'databases' folder
  239. Strange happenings with SA account
  240. Query by year group by total students sort by total for each county
  241. About SQL 6.5 replication to SQL 2000. (Distribution database)
  242. SQL 7 migration
  243. Help with COUNT in SELECT Statement
  244. Intellectual Property question
  245. creating temporary table with SELECT INTO
  246. bcp select querylist error
  247. Autonumber
  248. What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?
  249. Remote View Question
  250. Can FK be nullable/optional by design?
  251. sequence
  252. temporary tables...
  253. Making a stored procedure run on it's own periodically.
  254. Expanding Hierachy with multiple parents
  255. statement level vs. row level triggers
  256. How to set rights in E.Manager Since it is a open book..
  257. System tables
  258. Access to SQL2000
  259. ms-sql server "light"
  260. Sql Stored Procedures
  261. Query to linked server:Oracle; problems with ANSI_NULLS;ANSI_WARNINGS
  262. Clustered index not working
  263. Trigger on table-valued function?
  264. Changing Datatype length
  265. Server Name in Registry
  266. SQL 2000 System Db's
  267. Need tools to Convert Access to SQL environment
  268. Update a table by copying a column from another table
  269. Reading data from Excel...
  270. DBCC Page
  271. Help for stored procedure and Null...
  272. Suggestions for a small database layout...Very simple
  273. General Design Question
  274. Unicode conversion issue.
  275. Full Text Catalog Population
  276. importing cyrillic encoded data
  277. Help desk systems..
  278. DBDesign Q2:
  279. Help needed in Replication
  280. Perl DBD/DBI for SQL Server
  281. cannot connect to SQL Server from VB.NET
  282. audit/history without use of triggers?
  283. Rights
  284. Or in left outer join.
  285. SQLGetData returns all NULL data, but query analyzer returns correct values from aggregate queries
  286. Simple GROUP BY Question
  287. sysprocesses
  288. Is it possiable to restore a DB ...
  289. Index and Data Pages
  290. Weird Backup DB Problems in SQL Server 7
  291. dynamically creating temp table names
  292. Order of tables in joins
  293. isql -- executing multiple input scripts
  294. B.C. vs A.D. datetime in SQL Server
  295. Getting rid of duplicates
  296. long transaction
  297. Import Puzzle
  298. somewhat painful join code
  299. SQL Server 2000 Replication Query
  300. SQL script to remove constraints
  301. Gettting time of SQL Server Computer
  302. "Lost Inserts"
  303. Weird date rounding
  304. File group space error
  305. First day of month of 3 months ago
  306. RANT: SQL Server Internal Error
  307. Help with Cluster
  308. SQL Server login Form For access
  309. identify what tables are being access in SQL
  310. attach db file copied previously
  311. select without duplicates
  312. test - please ignore
  313. Creating a stored procedure
  314. MS SQL server Insert Error [109]
  315. Transation log size
  316. DDL Best Practices question
  317. Ex post shrinking file sizes
  318. INSERT INTO... SELECT... Cannot insert duplicate key...
  319. Looking for help with a stored procedure!
  320. Automated testing | How to "force" GETDATE() function to return specific value?
  321. MS-SQL-Server 2000
  322. MS-SQL-Server 2000 Problem
  323. Creating a Unique Index
  324. Script to store stored procedures in seperate files
  325. DBDesign Q
  326. MSDE Connection Error
  327. SQL - a menu system - plz help
  328. Want expert opinion on a way of storing 'relations'
  329. temp tables, global and local
  330. Inner Join experts out there??
  331. trouble using the CONTAINS() function in sql server
  332. Update query with sub-queries to find the values
  333. Help with search results query
  334. Migrating from Excel to sql-server
  335. Chinese chars through stored procedures...
  336. Active Directory Implementation
  337. Help With Stored Proceedure Please
  338. How to avoid Reference problems
  339. Working Linked Servers
  340. Solution need in Replication
  341. increase Ram?
  342. Dynamic create table, create index based upon a given database
  343. altering data
  344. retrieving long texts from msqql
  345. TImeStamp or not
  346. Script out objects
  347. Query help
  348. Adding Calculated Fields
  349. Why isn't this variable updating?
  350. copying a table from one database to another "last" doesn't appear the same
  351. SQL Full-Text Search in VB code
  352. Query Analyzer - not printing output
  353. connecting jdbc type 4 with ms sql server.
  354. What shrinks when shrinking
  355. View or Stored Proceedure?
  356. SQl debugger ! how
  357. pivoting query on t-sql
  358. Substring'ing a Number-field
  359. SQL Server replication with existing data on one server
  360. BULK INSERT FROM UTF-8 FILE
  361. Query Time Outs
  362. Query Help....
  363. Help with Select - into
  364. Connection Problems
  365. Purging records from subscriber/publisher database in merge replication
  366. Information on Installing 'QMF' In SQL Server on Win2000?
  367. Help with a stored procedure/query?
  368. Pros/Cons of using Win 2003 over Win 2000 for SQL Server Enterprise ?
  369. How to know what schema was modified
  370. >= in Case Statement - Stuck
  371. Database Alias
  372. TEXT data type column: Replacing chars : why isn't this routine working?
  373. Error while Creating table using Select Command
  374. HELP PLEASE: SQL Query Analyzer does not start
  375. Query optimization question...
  376. Parellism not working
  377. replicate error
  378. Date Comparison Issue
  379. Extra internal memory can't be seen ????
  380. acess I/O File
  381. SQL Reports.
  382. SQL 2000 Database files become read-only after reboot
  383. SQL 2000 Database files become read-only after reboot
  384. READ_UNCOMMITTED problem with SQL 2000 and i-net Opta 2000 JDBC
  385. How to get values from queries, and then using in another query?
  386. good SQL book?
  387. Select where not exists
  388. Profiler TextData truncation
  389. Help with UPDATE
  390. To find any text in all Stored Procedures
  391. Error executing xp_cmdshell from within a SQL task in a DTS package...
  392. Loading backed-up user database in SQL Server 2k
  393. перестраиваются ли индексы
  394. SQL 2000 backup on DLT tape
  395. Is it possible to return last row out of multiple based on row index?
  396. Clearness needed in Sp_attach_db
  397. Running SQL 7.0+SP4 on XP Pro...
  398. Best way to import ASCII tab delimited file every week (5,000 records)...
  399. 'joining' results of 2 queries
  400. OSQL Output File Garbage
  401. Remote Backup?
  402. how to determine what locking behavior the query optimizer chooses?
  403. Large Scale Storage Planning
  404. Creating Deciles
  405. Migrating from Access to SQL Server with a web front end
  406. Improve performance in Query..
  407. Script line number
  408. Help using sp_xml_preparedocument
  409. Corrupt Stored Procedure?
  410. Processing the TEXT datatype with TSQL
  411. Is it possiable conversion
  412. SQL7 to SQL2000 Migration
  413. Problem SQL7.0 Server (MSDE) - ACCESS MDB
  414. READ EXCEL DATA CELL BY CELL FROM SP
  415. View with a query to an oracle database
  416. cross tab query
  417. Create trigger not firing via ODBC
  418. file name or extension is too long
  419. Corrupted log file
  420. shrink file tool from EM took all the empty space allocated to data file
  421. ADP revision numbers
  422. Worker Threads
  423. Change logfile location durring setup SQL 2000
  424. bcp unicode files using format files
  425. bcp unicode data using format file problem
  426. SQL Server 2000 Trusted connection
  427. MCDBA - UK
  428. [EXTREMELY URGENT] sp_attach_db error
  429. retrieve an output parameter in stored procedure from java application
  430. Lots of queries for my db
  431. run a sql-sript from interface
  432. Is a fulltext serarch for *whatever possible?
  433. Cannot connect to the cube via pivot table control
  434. ORDERING OF DATA
  435. Sql Server on Itanium vs Zeon
  436. Sys Admin cant access SQL server. Only SA account can?
  437. Is there a better way to handle a conditional sum?
  438. UPDATE - Removing trailing spaces
  439. Unable to update table using Access 2002 Front End
  440. Table Spool in simple INSERT...SELECT causing performance problems
  441. SQL Formatter
  442. Just quick question about MSDE limitations
  443. count and update syntax help
  444. find backup directory
  445. There must be a better way than this NOT IN query...
  446. Synchronise problems with merge publication under SQL Server 2000
  447. SQL Server memory settings in SQL Server 7.0
  448. Icons in enterprise manager 7
  449. Transaction question
  450. Insert into multiple rows instead of one comma-delimited list?
  451. Sql server as DDBMS, where info ?
  452. How to get row count ?
  453. minus and intersect functionality
  454. Selecting Most Recent Record
  455. Run time error 3669. Execution cancelled
  456. UNION query won't work
  457. Search for articles with SQL server and Microsoft Indexing
  458. Group by Time interval.
  459. optimizing SP with dynamic WHERE and ORDER BY
  460. Bring back excluded item
  461. Running SQL scripts within a VB enviroment.
  462. dbconvert() doing incorrect conversions
  463. ASE ODBC 12.5 Driver has problem with SQLServer 8.0 DTS: HELP!
  464. Querying multi-tables? Joins? Subqueries?
  465. Failover clustering without SAN & SCSI ?
  466. Urgent help - Problem with multiple select ROUND statments
  467. XPATH in SQLServer 2000
  468. xp_cmdshell and pass command line parameters to .exe file
  469. Tables being recreated
  470. Q. about binary formats.
  471. Where is the SQL Server License Setup Utility Program?
  472. use of table variable causes rollback in sql server
  473. Database off line; How do I detect with a query
  474. SQLSourceSafe, the integrated version control solution for SQL Server objects!
  475. Sp:Cachemiss and no sp:recompile
  476. TSQL: conditional union statement
  477. are there any MSDE T-SQL code limitations?
  478. help with bottom to top query into hierarchical data
  479. Views vs Queries
  480. SQL - Front Page
  481. Thanks for the help
  482. Images from SQL Server
  483. Query needed
  484. To Null or not to Null that's my question
  485. Insert into SQL from Foxpro
  486. DTS Probs
  487. how to bring back the distinct values in single column from two tables
  488. how to retrieve only the duplicates in a table
  489. SQL7 - Some backups not working?
  490. how to change server option for isolaiton level?
  491. Fulltext search on .doc files
  492. Importing from filemaker
  493. Update operation takes forever! How can I speed it up?
  494. MSDE 7 and SQLServer 6 on same machine
  495. encrypting stored sql server data
  496. i want a certain field to be sequentially increased
  497. conditional logic in stored procedure
  498. Please Help Obi-Wan: Efficient Join/Cursor/Something/Anything?
  499. Filemaker -> MS SQL
  500. Integrated security problem
  501. Event Viewer - Application Log Error
  502. uk sql date
  503. File Copy to Windows 2000 from NT server running sql7
  504. Importing from SQL7 using DTS wizard
  505. Problem with full text in SQL Server
  506. SQL to PLC to diverter gate, can this be done?
  507. Help in setting up tables - MS SQL
  508. sqlserver 2000 standard licensing?
  509. Update through linked server never returns
  510. Problem with triggers between linked servers
  511. Asked a while back - think I'll try again!
  512. Admin a SQLServer environment from an Oracle DBA perspective?
  513. domain account vs local account for SQLServerAgent
  514. How to approach (Trigger-Stored procedure )
  515. Modify Index
  516. Stored procedure to return all rows in a table
  517. Reducing database size after dropping text column
  518. aliassed table trouble
  519. Losing dbobtions on clustered server failover?
  520. Query Governor Cost Limit
  521. SQL Server Views' Metadata
  522. Recompiling SPs in SQL server
  523. How to tell if a job has hung?
  524. New to Triggers
  525. xp_sendmail
  526. Inserting datetime with milliseconds in SQL Server
  527. Matching a View's columns to it's underlying table's columns
  528. Trigger-Happy
  529. Swapping out Drives on our production SQL Server this weekend
  530. Replication Between Different Versions of SQL Server
  531. CHANGED backup time, but still occuring
  532. change case sensitivity after database set up
  533. Looking for EBNF T-SQL Grammar
  534. SQL2k UDF's and Stored Procedure
  535. NULL/Varchar and extra bits
  536. Migration from VFP to MS SQL Server 2000
  537. Dynamic Cursor Generation..
  538. Please, a SQL trigger question!!
  539. 56 million records search
  540. Tool for showing what to change in DB from 6.5 to 70
  541. Creating a DTS package
  542. (Simple) SQL question regarding P/F keys and inserting data...
  543. HELP: sp_help and object browser report view column sizes differently
  544. Dumping all SQL queries.
  545. Best way to do a SELECT TOP n TO m
  546. PL-SQL LOOP equivilant in TRANSACT-SQL
  547. Strored procedure within SQL transaction executes much longer
  548. Urgent : DB-Library Error 10007: General SQL Server error: Check messages from the SQL
  549. Executing SP_SpaceUsed for tables in a other database with EXEC
  550. Executing SP_SpaceUsed for tables in a other database with EXEC