PDA

View Full Version : SQL Server

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 38 39 40 41 42 43 44 45 46 47 48 49 [50] 51 52 53 54 55
  1. default value of the foreign key field in a child table
  2. "Not associated with a trusted SQL Server connection"
  3. Converting .dbf to sql server table...batch file? command line?
  4. <undefined value>
  5. Re: casting smalldatetime type
  6. global update
  7. Can't Auto-Start Agent
  8. Max database size on SQL-SERVER7
  9. SQL Server manipulation on external server
  10. This wretched SQL has me stumped!
  11. How long to copy/replicate a database
  12. Getting first row
  13. Database design question...
  14. Intercept SQL : Spy / Driver-level / SQL Server Log...
  15. Stored procedure with resultset _
  16. Useful Stored Procedure Question
  17. Updating Cubes with DTS
  18. Creating temporary table
  19. Multiple triggers
  20. how to write an aggregate function which can used like MAX(filedname)
  21. Could I use SQL "Select Case .. When..." in ADODB.Recordset().open
  22. Query Analyzer shows negative numbers as positive numbers
  23. Stored Procedure Syntax Help
  24. Updating Next Run Date value
  25. Updating many records
  26. CASE Statement in Where Clause?
  27. Btrieve to SQL Server
  28. SQL-DMO header file for javascript?
  29. Permissions To Run DTS Package
  30. displaying extra characters with COLUMN-defined number format?
  31. ER relationship
  32. Index Question
  33. Alternative to Creating View with Union in two databases?
  34. Major query optimiser weirdness with UDFs and SPs on SQL 2000
  35. Re: Detecting or monitoring for long-running queries.
  36. Identity column in query result
  37. Changing the owner of a user-defined data type
  38. SQLgetinfo
  39. Try on this corrective patch which came from the Microsoft Corp.
  40. Is there a Microsoft Document Exchange and Database System like Lotus Notes or Oracle Managment Content?
  41. Database Performance
  42. Filtering and Aggregate functions
  43. US-FL-MIAMI *** SQL SERVER DBA *** Temp - to - Perm. 305.944.3294
  44. Problm setting up user. Error: user is null
  45. DateTime
  46. Stored procedures and CTRL+ALT+DEL
  47. Sql 7 password has been corrupted...HELP.
  48. Moving rows to columns
  49. Question about optimization
  50. SQL query problem
  51. Help With a DATETIME Query
  52. Querying tables from different databases
  53. Carrage Returns, Stored Procedures
  54. INNER JOIN using surrogate ID, or [Date] BETWEEN?
  55. Assistance with Stored Procedure
  56. Reading text into varchar
  57. Help With Another UPDATE Query Please!
  58. Update Takes Long Time to Complete!?
  59. Query Analyzer : losing the ___ rows processed message
  60. arrays in tsql?
  61. SQL Logins
  62. Data type change in SQL view
  63. DEFINITIVE ANSWER PLEASE -- can you UPDATE ntext datatype field???
  64. Rebuild master never ends.
  65. STORED PROC to "UPDATE" ntext field -- PLEASE!
  66. Variable Paramters to Functions
  67. Check Data Before Update
  68. IIS crash and format
  69. Assigning values to multiple variables (via subqueries) for use in an update
  70. Merging rows within same table
  71. Stored Proc to assign variable from subquery not working -- ugh
  72. test
  73. Backup of active log after db failure
  74. Self Joins
  75. sql server 2000 - dts can't 'see' stored procedure
  76. SQL Server storing large amounts of data in multiple tables
  77. Error 7399
  78. Tracing values in DTS package/stored procedure
  79. DTS and stored procedure
  80. QUITTING
  81. SP3 & CURSORS
  82. Key Word Searching
  83. Auto-increment fields when moving a base from Access to SQL server
  84. Detecting or monitoring for long-running queries.
  85. eliminating (inverse) duplicates in result
  86. Insert problem with linked server
  87. Nested SELECT HELP....
  88. zusammengesetzter Primary Key mit Deleted-Flag
  89. SQL Server 2K truncating text fields at 255 chars
  90. Rotating information from Recordsets to columns.
  91. Inserting Duplicate Data
  92. Creating join statements
  93. Case Conditional in SQL Statement - MS SQL 2000
  94. Sound device/driver
  95. Fetch Question
  96. Custom Error Messages
  97. formula column
  98. VISUAL BASIC/ SQL PREFERRABLY SYBASE/ CONTRACT/ AR
  99. Transaction Log - Audit
  100. get description in table
  101. Import Human-Readable text file into SQL Server 2000
  102. Postal Lottery: Turn $6 into $60,000 in 90 days, GUARANTEED
  103. Retrieve One Row at a time
  104. Two "Cache" related full time positions.
  105. how to add column in database at runtime.
  106. TEMPDB now at 4 GB
  107. Website Monitoring
  108. SQL Server Hogs 100% CPU
  109. FoxPro Index called from SQL Server
  110. null pages
  111. Cannot convert Varchar to Numeric issue
  112. Looping database queries
  113. Changing table owner
  114. Calculating Time Difference
  115. Return Value in a Stored Procedure
  116. Many fields update from a Group by Clause
  117. Connection.CommandTimeout
  118. No results from Full-Text Search in SQL 2000
  119. Table design problem
  120. OT: SQL Server Hosting
  121. Rows as Columns
  122. where clause messed up
  123. Cursor, Query, View and Recordset
  124. SQL Server Monitoring
  125. About virus
  126. Magic upper limit to number of job steps in a job
  127. Select, insert and delete queries timing out
  128. multi-thread tasks using a single connection object concurrently
  129. SELECT a random row for each different Type
  130. Order by clause
  131. Order By Clause
  132. Data File in a Different machine on the network.
  133. Query Help
  134. Re: Taste this critical pack
  135. Creating a Stored Procedure from 3 queries
  136. Reasonably simple query question
  137. Desktop Engine and DTC
  138. AutoNumber
  139. Performance Complex SQL Issue
  140. Erro running a query if dashes present in the string
  141. Recordset Problem
  142. How can i get a return code of 1 for an osql command which has a lower severity..
  143. How could I do that (Query)
  144. SQL Server Replication and the growth of the subscriber log
  145. Duplicate records are being inserted with one insert command.
  146. Bulk Insert - Cannot perform SET operation.
  147. DEFAULT keyword performance
  148. Alter table permission to dbo
  149. Looking for physical design suggestions...
  150. sum() for textual fields?
  151. Concatenating a field while grouping records
  152. Two int fields or one varchar field
  153. SRV_DONE_ERROR
  154. DTS import renames my SPs to previous names
  155. Which one to buy?
  156. SQL 2000 Server Hangs...!
  157. Problems installing SQLServer 2000 Developer Edition on Windows XP Pro
  158. Strange database deadlock
  159. Am I being role happy?
  160. Bulk insert of long unicode strings
  161. Multiple selects on same column, same table, one query
  162. Query Performance Problem
  163. Question re: multiple joins
  164. How to Update with SQL EXISTS(?)
  165. To make an existing column become an identity column
  166. Unable to begin a distributed transaction
  167. Newbie Howto:Import, update, delete legacy data to SQLServer db
  168. Replication on SQL Server
  169. What is this ?
  170. Returning results while the query is executing
  171. Autonumber...
  172. How to set a User Variable within a DTS package...
  173. Deleting extra tempdb log and data files
  174. Convert Access Function to SQL
  175. Is there a High water Mark in sql server
  176. Obscure ODBC error Help!!!!
  177. Changing SQL Keys
  178. Database Books and Whitepapers
  179. Help!! SQL Server 2000 extended stored procedure hangs in Windows 98
  180. Request: Help creating a difficult view.
  181. Problems with partitioned views and pruning
  182. SQL Server 2K BackUp
  183. syntax for updatetext
  184. Cluster Database Failover Data in SQL Server?
  185. DTS automatic dat file import
  186. full text search and ampersand
  187. Getting database size: a stored procedure to do it......
  188. Using Stored procedures in a join
  189. Brainstorming: Ideas for categories database structure please
  190. getting table counts
  191. autogenerate numbers from 000001 to 999999
  192. Remote Database updates take long time to complete
  193. basic design question re effective relationship
  194. getdate() causes locks in views
  195. overflowing a local varchar
  196. Error in connectiong to second named instance of SQL Server 2000
  197. Please update your Virus checkers !!
  198. 2 group by in a single query
  199. MS -SQL Server 2000 -connection closes randomly
  200. When executing DTS package in program, the application will have no response during the execution
  201. Re: sp_msgetserver Returns no records (Should be sp_MSgetVersion)
  202. Re: career in SQL/Database administration
  203. SQL query suggestions/help
  204. Select multiple records into a table
  205. question about dummy constraint
  206. Many to Many to Many SQL Query
  207. How to get list (text) of all tables and columns?
  208. BEGIN TRANSACTION or BEGIN DISTRIBUTED TRANSACTION
  209. How do I select a column from sp_spaceused into a local variable?
  210. Delete duplicate records from huge tables
  211. Can "CREATE DATABASE" or "CREATE TABLE" be wrapped in transactions?
  212. Move LDF -Has anyone seen this happen?
  213. Course 2073: Programming a Microsoft SQL Server 2000 Database
  214. Problem with JDBC Driver for MS SQL Server
  215. Sum of Two Union Queries
  216. Combining Data from Variable number of tables
  217. SQL7 on Windows XP Home
  218. Adding staggered running total and average to query
  219. SQL Server Error: Exception_Access_Violation
  220. SQL Server does not exitist or access denied error
  221. Learning SQL Server
  222. DTSRun Encrypted
  223. One Statement Update - Join, no cursor ?
  224. SQL Resource Kit - dbgen - Database Generator
  225. Stored Procedures vs ADO vs T-Sql
  226. can stored procedure run more than 1 sql statements
  227. SQL Statement
  228. information_schema permissions
  229. Cube/Rollup without Group By?
  230. Please update your Virus checkers - SWEN-A is rampant - and I'm getting squillions of emails.....
  231. Log to big in SQL
  232. Problem with linking servers
  233. Date format export/import
  234. Force shutdown of SQL Server Instance
  235. Slightly Dumb Question about JOIN
  236. SELECT Top. Which method is best?
  237. money type problem
  238. Suggestions for a simple/introduction to querying OLAP
  239. Large table/slow query/ can performance be improved?
  240. Dividing two Count() Results
  241. cascade update / foreign key
  242. Transactions with remote connection
  243. Replication
  244. 2000 Personal edition install question
  245. stored procedure
  246. Newbie sqlserver update problem
  247. Stored procedure in database X, executes stored procedure in database Y, wrapped in transaction?
  248. MS SQL on the machine with multiple network cards
  249. JDBC with MSDE
  250. I can't create a temp table