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. Date inputs (UK format) in SQL svr 2000 with OLE DB
  2. invalid attribute/option identifier
  3. Bloated database wont shrink after backup/restore SQL 2000
  4. Print Attributes in Stored Procedure
  5. Help with date parameter and if/else statement
  6. Getting Memory usage through T-SQL
  7. Session memory usage
  8. Defining AS400 Linked Server
  9. Separate foreign keys with shared ID space
  10. admin realted questions
  11. passing table/column name as parameter
  12. basic sql query needed
  13. Newby: Administer a database remotely?
  14. System Monitor / SQL Server
  15. How do I select all records in one table that have NO related records in another table?
  16. Do for each - how to write it more graceful?
  17. Resources
  18. Cannot Register Instance of SQL Server 2000
  19. select statement
  20. ODBC Connection busy error
  21. Format of tables
  22. backup
  23. How to convert string to upper case using Field's Formula Property
  24. How to compare database structures?
  25. IDENTITY_INSERT Problem
  26. SQL 2000 Q: duplicate database
  27. finding out table names
  28. Locating a table using index page
  29. Converting C++ Unix time_t Julian date to SQL date
  30. is sqlserver 2000 compatible with windows 2003 ?
  31. RSS Search
  32. variable
  33. Looping through a recordser in a stored procedure
  34. How to upload more than one field?
  35. Arnold Schwarzenegger Commits Suicide
  36. Finding BINN directory for Multiple Instances
  37. CAL & MSSQL Security Question (by an ignorant)
  38. Help for a new user
  39. Size of SQLServer databases with indices
  40. device CALs
  41. Procedure performance in QA vs Sql Agent Job
  42. c++ ole DB stack overflow during sql server compilation
  43. Stored procedure permissions with xp_cmdshell on SQL 6.5
  44. Changing drive letter
  45. type mismatch : Error
  46. SQL server 2000 memory reclaim
  47. Replication Distribution Agent Does Not Start
  48. trusted SQL server connection
  49. Using BCP/xp_cmdshell as NON serveradmin
  50. Bradmark's NORAD monitoring utility
  51. SQL Server under VMWare
  52. SQL Full Outer Join
  53. Hourly batch process locking my database
  54. anyone has xp_gettable_dblib source code?
  55. UpdateText through a stored Procedure on a input parameter
  56. replication/distributor problem
  57. Server Crashed/Need to move SQL 2000 DB
  58. Delay before uncomplete transaction removed
  59. Bring Data into SQL Server
  60. INT Size
  61. Insert Trigger and xp_cmdshell with carriage return text
  62. MSDTC is unavailable.
  63. Passing Parameters to Extended Stored Procedures
  64. Unable to connect with Enterprise Manager
  65. Adding a time column to a date column
  66. Analysis Services connection "No Go"
  67. Script for SQL Agent "Weighted Job Duration"
  68. Returning # of columns with non-null value
  69. Need dynamic SQL
  70. Someone else editing record ? Only me on the server ?
  71. DTS - Dr Watson Error
  72. Pocket PC and SQL Server CE.
  73. Linked server to oracle
  74. row delimiter from osql output
  75. Distributed transaction....
  76. Code does not select any data for information from the different tables in the database
  77. SQL MSDTC
  78. Many to One with Max Date Query?
  79. password for sa was changed spontaneously
  80. Incorrect Syntax
  81. SQL syntax - INNER or OUTER JOIN vs. WHERE
  82. Text manager can not conitinue with current statement
  83. Blocking problem
  84. Script for Transfering Database Diagram
  85. horizontal positioning
  86. join 2 complex queries to 1
  87. How to get the amount of bytes exchanged during a Merge replication between 2 MSSQL servers
  88. sync'ing 2 databases
  89. Error... Invalid object name 'data1'.
  90. Transaction Log
  91. Web site with database models
  92. Recovery SQL Server
  93. Math is driving me nuts
  94. Hardware question
  95. instead of trigger example
  96. Unique Identifier Crystal Reports Parameter
  97. simultaneous updations and deletions between databases
  98. Differences between SQL Server Versions
  99. Stored Procedure to upload data from one db to remote db
  100. Pass Scope_Identity() back to the calling application
  101. updating and deleting parent and child table simultaneously
  102. Access2K Connecting to SQL Only as LocalAdmin
  103. Access2K Connecting to SQL Only as LocalAdmin
  104. Huge Imports using DTS - advice needed ...
  105. SQL 2K Security Baseline or Security Checklist
  106. SQL Solution
  107. Record insertion
  108. Table Overwrite
  109. deadlock error
  110. adding some rows to a select
  111. Scalar Function Columns
  112. problem with attach database
  113. syncronising SQL tables between seperate servers
  114. Finding Last Updated with a timestamp
  115. Problem: Replication fails over modem but works on LAN
  116. Creating a simple update trigger
  117. performance issue (repost)
  118. Update query question
  119. Stored procedure
  120. optimizing a query to delete duplicates
  121. Table Qualification in SQL Server 2000
  122. bcp within batch file
  123. SQL Server Overrides My ANSI_PADDING Setting
  124. I thought I posted this one but don't see it. Problem with querying a query
  125. Having problem with sql create
  126. Using like predicate
  127. Need Assistance Creating a stored procedure
  128. Dangers of Client batch cancellation
  129. ..\MSSQL\Data\ - Directory saturated
  130. SQL many-to-many query problem. HELP !
  131. How to Restrict all SQL Database's Size
  132. Small problem with DateType
  133. MS SQL 2000 Backup. where r my Indexes?
  134. Ageing data using Sql Server 2000
  135. Using identity to generate a primary key
  136. export (from mdb)-> import (to MS Sql server)
  137. Delete SQL Table using a variable that refers to the Table Name
  138. A better way to handle repeating dates
  139. views across databases
  140. Deployment Question, Connection string issue.
  141. Deployment Question, Connection string issue.
  142. Min pool size
  143. tool that create sql script to recreate a database
  144. How to count number of rows
  145. Is this DELETE possible?
  146. Create a file using a SQL DB Trigger
  147. count multiple distinct columns
  148. Setting up SQL Mail
  149. Complex query
  150. How do I append string to end of sql query results?
  151. New db cant be found
  152. BCP -k option - Very urgent
  153. insert into many rows
  154. Follow up to Exec..master and sp_dboption
  155. performance
  156. Problem with dates
  157. Block Port 1433 on windows 2000 server
  158. Using Unique Indexes
  159. Determine winner from two distinct lines
  160. O/R mapper
  161. Query Optimization Assistance w/ Joins
  162. Problem unauthorize deleting of primary key in SQL
  163. Inner Join question
  164. Determining if foreign key constraint exists
  165. SQL Server Lab Design
  166. Problem with MSSQL SPRINTA 2000 JDBC Driver
  167. Locking hint problem on multi-servers
  168. Problem with MSSQL SPARTA 2000 JDBC Driver
  169. mssql2000 on emc mirrorview volume
  170. Design issue
  171. SQL order question
  172. IsNull ordering
  173. IsNull ordering
  174. Using NEWID() as a parameter to a stored procedure
  175. find
  176. cant start sql 2000 on port 1433
  177. How to update using a function
  178. Fill Column with Sequence
  179. Compare and Restore Tables
  180. ISO dates?
  181. Easiest way of combining multiple fields from different records into one record?
  182. send email to me when job fails
  183. Importare txt in SQL
  184. Utilities to check for errors in stored procedures
  185. SQL Report Generation
  186. storing passwords in database
  187. Possible Bug in SQL Server 2000?
  188. SQL Server 2000 Hardware Recommendations
  189. MS Sql Server and Windows 2000/XP
  190. How can I make a SQL agent job to ignore warnings?
  191. Script to copy permissions for all objects given to a user or a role
  192. Help with a View
  193. Generating Foreign Key Script
  194. How to Identify Hot Tables
  195. SQL Query Help - - Table Normalization
  196. need help with converting old style subselect to ANSI joins?
  197. Invalid object name
  198. fastest way to insert range/sequence
  199. Stored procedure with output variable
  200. SQL Agent Job failed
  201. Loading Data into SQL Server from a SAS Dataset
  202. Compound Statements
  203. Determine closedate depending on a metatable and this closedate will be used in a query
  204. Grouping by unrelated field- SQL masters, try this!
  205. How to transfer data from SQL Server 2000 to Db2 V8 using DTS and Odbc driver
  206. Web server hardware design with SQL back-end
  207. SQL Server setting has any effect on queries?
  208. Drop tables with unknown names and unknown quantity
  209. Cursor problem
  210. how to parse a name
  211. Why, "Invalid column name"?
  212. business logic in Stored Proc VS aspx.vb page
  213. Pb to retreive max value with aggregate subquery
  214. SQL Server Backup Failure
  215. SQL Server + SSL Hangs?
  216. SQL Server + SSL Hangs?
  217. Image files and SQL Server
  218. help forms
  219. Reading rtf from an image field
  220. SQL Float Operation with Round() fails completely
  221. is ASP the only way for SQL remote access via internet
  222. SQL Profiler info req
  223. Weird Optimizer Choice
  224. CASE alias in WHERE
  225. New user needs help
  226. .exe to insert data in SQLServer database
  227. Row Handle Invalid
  228. WAITFOR DELAY
  229. examples
  230. SQL Game
  231. is it good idea to replicate sql server db files?
  232. hOW DO I KNOW THE HOW MANY INSTANCES OF SQL SERVER RUNNING SINGLE MACH
  233. Help! Sql Server 2005 kicked my Sql Server 7's You-Know-What
  234. Bug (?) in nsqlprep.exe (SQLServer 2000)
  235. Export relations from SQL Server Database to MS Access
  236. Finding if a REAL is LIKE '%[49]9'
  237. Difficult Query: is this possible in SQL?
  238. Calling methods, functions threw Extended SP in a DLL
  239. Outlooksoft
  240. Need to speed up query.
  241. Concurrency puzzle (ODBC API related)
  242. Lock Stored Procedure
  243. SQL SERVER 2000 - EXEC master..xp_cmdshell permissions
  244. question about launching an application at sqlserver startup
  245. XLOCK and ROWLOCK
  246. question about launching an application at sqlserver startup
  247. Null & one more table
  248. How to properly restore transaction log
  249. Example code for database configuration(MSDE)
  250. Dynamic SQL trouble
  251. Search Multiple Columns with REGEXP
  252. Development Environment Needs?
  253. Help with NOT EXISTS query
  254. Drop Column problem
  255. Login With Domain Account
  256. Sending an e-mail via SMTP in SQL Server
  257. Aborting CALL to stored procedure
  258. Backup and Restore
  259. SQL Checkers Game
  260. jet to sql
  261. how to get a list of configuration settings for a database
  262. Selecting Unique Record
  263. SQL Server to Oracel
  264. HELP with TIME Calculations
  265. Eliminating Combinatorial Relationship Multiplication
  266. Slow performance on ADP forms using filter
  267. SQL Syntax problem
  268. howto: calling sp_executesql from a function ?
  269. SQL Data Compare Error
  270. Fundamental help required with SQL connection
  271. fail to configure my server for replication
  272. Help: MS-Word apostrophes in Query Analyzer
  273. Replicating LDAP entries to a SQL Database
  274. Converting MS query to SQL Server 2000
  275. Linked Server request...
  276. I need BETWEEN on speed
  277. Vyas, Neil and others Please post your views ---- SAN , active transaction logs
  278. does anyones knows polyserve products
  279. sp_makewebtask
  280. Multiple many to many
  281. MS SQL 6.5 Procedure to Send Query results via Email
  282. Why the transaction log file full
  283. EMC Clarion Performance Issue
  284. checklist for moving a database from one server to another?
  285. How do I loop thru a result set?
  286. Custom SQL Server Job Schedule
  287. Parameter value from empty text box - null or 0 length?
  288. XML Output
  289. SQL update on multiple tables
  290. PRINT only takes effect after T-SQL completion ?
  291. Invalid character value for cast specification: SQL Server 2000
  292. Data Processing Script Justs Stops
  293. sqlserver7 connect
  294. View performance, linked servers, query specifiying uniqueidentifier
  295. University of Plymouth Computing Industry Perception Study
  296. Guid vs Identity
  297. parameterized queries running slower than non-parameterized queries
  298. Converting numeric data type to text data type
  299. get current table name in stored procedure
  300. PERC RAID Controller settings?
  301. sp_prepexec and compatiblity mode 7: float variables comparing to string field fails
  302. Beginner's Question on SQL-DISTINCT
  303. Database field length problem
  304. xp_cmdshell missing
  305. Running DTS through Access VBA
  306. Using MS SQL server to copy files
  307. Age Old Question about GROUP BY clause (i think) - Probably easy answer
  308. Help with 2 queries / Join problem
  309. Sccheduled packages don't run
  310. MDX Query Help
  311. Help with returning a certain # of records from a view.
  312. The size of the image data type
  313. Write Conflict.. please help!
  314. SQL Server to Oracel
  315. Very puzzling count
  316. Installing SQL Server 2000
  317. I can't restore the transaction I needed! Help!
  318. SQLAgent crash
  319. help how to create a row progressive..
  320. error 'Login failed for user sa', and the backup fails.
  321. Update, case statement and sum
  322. SQL Server ASP Syntax error
  323. DTS Package
  324. Big problem with triggers
  325. Restaurant databases
  326. SQL CPU Utilization goes to 0
  327. SP Technique --
  328. differential backup failure
  329. OT? mysql groups
  330. Deadlock Problem
  331. Modifying Sysxlogins Domain Names in SQL2000, strange result..
  332. Help with SubQueries?
  333. converting date/time to just date?
  334. SP problem with editing records
  335. SQL Server Licensing Question
  336. MS Network Monitor Utility - How to get for Win 2000 Pro
  337. Database Access Right Issues
  338. DBA guide
  339. Read Data from Cube and Dump in a SQL table
  340. Automatically Sort Table when Table is Opened in Project
  341. Vo2Ado/MSDE Create Index problem
  342. Using triggers
  343. SQL instances
  344. Using User defined type instead of varchars
  345. storing phone numbers
  346. SQL Server - Remote Command Line Management
  347. Add a second databse - benefits?
  348. Goup by clause confused....
  349. test
  350. sql
  351. MSDE 2000 Release A won't talk
  352. No default entries in SQL Server 2000 Service Manager Options
  353. Needs Help in Making Database
  354. indexing
  355. Analyze LDF files MS SQL Server 2000
  356. Comments on InterSystems Cache Database Platform
  357. sql server service pack 3 update, delete question or problem
  358. Determining if a parameter exists in a stored procedure
  359. Looping In SQL 2000 (Can it be a nested loop)
  360. Inserting few Recordsets into Temp Table containing NULL Values
  361. WARNING. A simple cut and paste of 8 records can distroy a SQL Server table
  362. Help with an MS SQL Server Query to return the latest dates against each recordID.
  363. HElp :)
  364. select between date
  365. Update rows with next higher id, if it exists
  366. SQL Server ORDER BY bug?
  367. denormalize data in a temporary table
  368. Web publishing in Visual Manfacturing
  369. Error creating linked server to Excel
  370. Syncing Database
  371. slow select statement -- please help
  372. DTS workflow problem when encountering On Failure
  373. query question
  374. Modelling large trees in SQL Server
  375. Superior SQL Builder
  376. Is this too much data for SQL?
  377. SP Error
  378. query question
  379. Different behaviours on different servers
  380. explain plan
  381. getting an int id from an inserted record
  382. Format File Easy one (not for me)!
  383. I give up on this one...
  384. Bulk Insert Problems
  385. sql date contraints
  386. Concatinating Variables
  387. Passing a specific cursor record to a function
  388. Exporting SQL to Excel Hourly
  389. SQL Server 2000 filling a key field
  390. Non sharing data cluster
  391. No Subject
  392. sp_executeSQL Syntax Question
  393. Bcp and Bulk Insert not working
  394. I need the istance name in my SQL 2000
  395. restore from different server - user (sid) does not match restored db - fix with sp_changeobjectowner
  396. Declare an array of int in SQL Server
  397. INFORMATION_SCHEMA query question: constraint columns
  398. Record lost with UPDATE statements
  399. MS SQL Server -
  400. Alter Table Alter Column
  401. sql insert problem
  402. I/O Component Bottleneck Theory
  403. Fixing my table based on Dbcc Showcontig results
  404. Scheduling a backup
  405. How do you "dump" a database with MS SQL?
  406. Problem with conversion of string
  407. MSDE and Windows 98.
  408. NEED HELP and GUIDANCE!
  409. multiple records, only want one
  410. Example of a University database
  411. Help with multi Join or multi tier select.
  412. DESPERATE help needed....
  413. Complicated Update Statement
  414. Databases Syncronization
  415. SQL SERVER Backup
  416. Where is stored Columns Description for SQL Server Tables?
  417. Sql Server & Java. Book Recommendation.
  418. UPDATEs with multiple aggregate functions
  419. Performance Question
  420. Databases Syncronization
  421. Storing Time in SQL Server 2000
  422. Upsizing from Access Data Type Problems List
  423. Stored Procedure Question
  424. View not working SQLSERVER 2000
  425. archiving analysis server dbs
  426. connection to sql server 2000 from Solaris
  427. OPENQUERY Question. How to update using 2 tables
  428. strange problem
  429. MS SQL Server - a plethora of limitations...
  430. interupt JDBC SQL query connection
  431. Parameter Query
  432. function
  433. Please Help - dBASE
  434. Upsizing to SQL 2K
  435. Restoring Master from Enterprise Edition to Standard edition
  436. # of billing cycles
  437. Computer Books, Inc SQL Server 2000 Books - up to 80% off
  438. Replacing characters in a text field
  439. What's in a full SQL Server backup?
  440. Order by "string not empty"?
  441. Microsoft certification test 70-229
  442. Building dynamic tsql statements in a loop
  443. Problem with LEFT JOIN... please help!
  444. Duplicate Removal and Intelligent T-SQL
  445. Data script
  446. Deleting a record from a VIEW
  447. Need MAX from Each Group
  448. get DB name from within stored procedure?
  449. MSSQLSERVER service terminated unexpectedly
  450. Help with an import to SQL
  451. Problems running Enterprise Manager and Service Manager
  452. Data Retrieval From Online Database - Paid Consultant Required
  453. Media question
  454. Formatfile shortcut?
  455. Bulkadmin role (BULK INSERT)
  456. TOUGH INSERT: Copy Sale Record/Line Items for "Duplicate" Record
  457. question abot primary key
  458. Very serious bug with Materialized/Indexed views and SQL server
  459. Unicode in SQL queries
  460. Unix connectivity tools to sql sever 2000
  461. Unix connectivity tools to sql sever 2000
  462. Table Spool\ Lazy Spool
  463. Database restore question
  464. Recordset opens as read-only -- WHY??
  465. INDEX possible for reverse wildcards?
  466. Altering SQL Server 2000 table design
  467. Large Data Delete
  468. Data Modeling
  469. WriteBak Reaktime examples
  470. Count rows in a date interval
  471. Help with getting table information from sqlserver
  472. query regarding date format
  473. Print list of tables with Identity row set to NOT FOR REPLICATION
  474. OPENDATASOURCE: text file as input ?
  475. Build database application on Internet with ISP?
  476. Operating system error code 3(The system cannot find the path specified.).
  477. Setting maximum number of merge agents
  478. Volltextsuche mit contains
  479. SQL 6.5 with Delphi 1.0 on Win95 problem.
  480. Migrate VIEW from Access to SQLserver ???
  481. Input string was not in a correct format
  482. eliminating redundant data
  483. NULL vs. "Unknown Value"
  484. set a attribute to random values in a given list
  485. Logging to second disk -- what happens when it crashes?
  486. Representing rows as columns
  487. MSDE Maintenance Plan
  488. Comparing data in two consecutive rows from a single table
  489. Sum question
  490. HELP! Shopping Cart Solution Required. URGENT!!
  491. accessing SQL 2000 table from within Excel
  492. Count query problem :(
  493. slow query thousands of records.
  494. solve the proplems
  495. DTS Import not working after SP3a upgrade
  496. Generate a normalized XML doc from SQL Server
  497. Instances of SQL
  498. Nested Coalescing possible in SQL?
  499. Fundamental Functions MS SQL Server 7 or 2000 users VALUE MOST
  500. Control characters output in attachments from xp_sendmail
  501. Convert to Date
  502. Is any possible to run DTS package from Command Line ?
  503. SQL Query - Date, between dateadd problem
  504. wildcards in dropping constarints
  505. Selecting Values in CSV
  506. Advance SQL
  507. Help Required on Stored Procedure
  508. Possible Corrupt Table
  509. cross tab or derived table
  510. Creating roles
  511. can u help with my select ?
  512. cross tab or derived table
  513. Like statement
  514. sql server 2000
  515. possibile che ...
  516. Calling All T-SQL Gods & Goddesses
  517. How to Spec a SQL server
  518. SqlServer changes cursor to "read only"
  519. Yet another BCP issue
  520. Scripting "INSERT"s in an SQL database?
  521. Help setting up SQL2000
  522. CASE with empty parameter
  523. multiple result sets
  524. PRINT command Not Working For Database Client
  525. Select lookup code values problem
  526. How to transform fact table only by SQL?
  527. DBCC and Failed Assertion Errors - HELP!
  528. Why is my Data Import going so slowly?
  529. Full-Text Search Query Question - Performance
  530. SQL for Modeling Generalization Hierarchies
  531. Breaking out data from a text field type
  532. Functions with global variables
  533. Who is in a database ?
  534. update tables from a csv file?
  535. connection problem to sql 2000 on windows 2003 from Windows 95
  536. HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET
  537. Whats wrong with this nested while loop?
  538. password protecting data
  539. Problem in Right Outer join query
  540. Defining global function in DTS
  541. BCP utility replaces German with junk characters
  542. Right outer join problem
  543. Advanced SQL Query Problem ...
  544. Problem with a temp table
  545. Timeout / Obtaining a connection from the pool - Please Help!
  546. select into withidentity
  547. question about retrieval of client process IDs
  548. Update Top 30%
  549. how to drop all keys & indexes
  550. last row