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