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