PDA

View Full Version : Microsoft 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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 [109] 110 111 112 113 114 115 116 117 118 119

  1. want to change all columns to nullable
  2. Pls help me tuning SQL Command
  3. Importing a table from another SQL db
  4. Linked Server Language Problem
  5. Differential Backup...
  6. Can I replace my BCP with log shipping?
  7. DTS Import Error (Catastrophic Failure).
  8. Update Problem on Linked Server
  9. Copy Table Data From One Db To Another
  10. Check Constraint configuration
  11. MS SQL 2000 sp3 problem
  12. trigger for insert is not fired when importing data???
  13. function
  14. updateing ntext and text fields
  15. Listing Server When Anonymous Subscribers
  16. SB Replication / Data Transfer and SSL Encryption
  17. "inner SELECT"
  18. Failed SQL 7.0/SQL200 Database copy
  19. Log reader not automatically starting
  20. Stored procedures with linked servers
  21. SQL DMO Install New database
  22. Split-Mirror Backup and Restore Users
  23. merge replication, what hapens if...
  24. Performance question: View vs. Table
  25. Simple Query!
  26. Accessing Progress data using Data Link
  27. DTS and Stored Procedures
  28. Check for table and return true or false
  29. WAITFOR inside loop
  30. Program from executing Procedure
  31. Query Analyser debug problem
  32. Good Sites for Beginners
  33. Passphrase lost after moving users
  34. what's the meaning of ";1"
  35. sql 2000 recover data wareshouse
  36. Rearrange String
  37. newbie has questions...
  38. Seperating a record into multiple
  39. Bulk insert
  40. looping through field in table
  41. An internal consistency error occured (SQL-DMO(ODBC SQLState: 42000)
  42. How to restore the database , Urgent!
  43. How to monitor a job
  44. problem about "ConnectionCheckForData"
  45. How do I find out what tables belong to a filegroup?
  46. Saving japanese characters Into SQL 2K through ASP
  47. DTS Fails sometimes for no reason
  48. Transactional Replication syntax error or access violation
  49. ADO and SQL Server
  50. Analysis Services
  51. Replication
  52. DTS Global Variable Problem
  53. MSDE SP3 fails to install on XP Pro
  54. simple problem but can't solve
  55. ODBC: SQL_ATTR_CONCURRENCY changing after simple select
  56. error 15007
  57. Save DTS packages to MSDE
  58. SQL7 Service Packs
  59. seemingly difficult table compare
  60. Rowguid & Data Changed error
  61. Create local cube, got Error# 3001
  62. Scripting User Defined Function using SQL-DMO throws an error
  63. Clone a SQL Server
  64. selecting rows as columns
  65. Output of Stored Procedure
  66. Recordet Problem
  67. Replication error when explore snapshot
  68. Why it's so slow to display a cube in Excel
  69. DTS "general error" when trying to export/transform to txt file
  70. Adding a Column to a Table
  71. Return Value of Stored Procedure
  72. Connection Broken
  73. Sorry for the mess but could you?
  74. SQL 2000 Error
  75. Security Concern - How to remove hardcoded passwords?
  76. problem with transferring Access date field to SQL
  77. unable to connect to SQL Server 2000 in JDBC
  78. Order by & case
  79. DTS question.
  80. LINKED_SERVER query failed after install Slammer Virus hotfix
  81. fail to install sql2k on windows cluster
  82. How can I write this SQL statement when the string value is a variable
  83. Can I avoid slammer attack without install sp3 for sql server 2k
  84. Optimizing MS OLAP Cube build time and response time
  85. How to invisible the table I created ?
  86. BIT help
  87. Restore error - transaction log full
  88. SQL Query crashes SQL 7 sp3&4
  89. Process Blocking Problem
  90. Analysis Services 'BOF'/'EOF' error
  91. DTS question...
  92. Not able to Archive aggregate maps for a MOLAP cube via command line
  93. Monitor SQL Servers
  94. cycles or multiple cascade paths FOREIGN KEY constraints
  95. Exclamation mark in field
  96. SQLServer 1 big table or >200 smaller tables?
  97. businessintelligence.com
  98. delete all data and restart key count to 0
  99. case-sensitive 'replace'
  100. Good Query for Paging?
  101. Trouble changing design of large table
  102. Is are a way to convert the SQL datetime to MFC CTime
  103. SQL server performance
  104. Linked Server Error - Msg 7391
  105. Visual Basic .net code within SQL triggers and Stored Procedures.
  106. Searching for table properties
  107. Convert Money to Varchar(50)
  108. SQL 2000 job hanging
  109. Linked Servers and sp_executeSQL
  110. Average
  111. trigger rollback
  112. Temp Table Creation -6372
  113. Pass a variable to SET IDENTITY_INSERT
  114. Root Directory Change - SQL 2000
  115. hierarchical trees
  116. Deleting tables
  117. OLE DB provider 'MSDASQL' reported an error.
  118. Enterprise Manager crashes
  119. Changed sa password, db maint plan not working
  120. Backup failure error 3041 18210
  121. How to parse XML inside stored procedure
  122. Primary key violation after replication
  123. FK constraint when FK row is there! Always takes 10 mins to fail!
  124. Notification Services
  125. How to Deal with Hijri Dates in SQL Server
  126. FIFO in SQL
  127. Rebuildm Error
  128. Help on DBNETLIB.DLL
  129. Case - When - Then - Else?
  130. i need info
  131. ODBC--update on a linked table 'table_name' failed
  132. Slowdown in DB after data migration
  133. Full-text not populating - Error: 80070002
  134. Is there an equivalent to an MSAccess IIF statement when creating Store Procs
  135. Pwdcompare()
  136. CPU usage for SQLserver.exe increased!
  137. ODBC - Communication Link Failure
  138. function oversight for SQL server
  139. Full Text search returns strange results
  140. getting a deleted ids froma field
  141. Problems with ROLAP
  142. Make Dynamic cursor
  143. All of a sudden i Can't Create Stored Procedures?
  144. int to binary conversion
  145. DTS Lookups
  146. HELP! Stored Procedure problem
  147. Collations Problem
  148. How do you hide 'Caution:' messages in Query Analyser Messages?
  149. sqlserver.exe size growing rapidly
  150. 2col. with data in diff. sequence ref. same column in different table
  151. typist
  152. Database Compare & Synchronize
  153. Msde 2000
  154. Intermittent failure of distributed transactions
  155. Stored Procedure Variable problem
  156. Structural changes to linked VFP tables cause connection loss from SQL Server
  157. DTS Icons
  158. How to get the available memory on the server?
  159. SQL job step suddenly takes longer to complete
  160. POST SP3 Problems
  161. nested insert?
  162. Intra-query parallelism ?????
  163. physical io changing?
  164. DTS Error Saving to Files
  165. Cant connect SQL server by Enterprise manager but no problem by Query analyzer
  166. How to uninstall sp3 for sql server 2k
  167. SQL Desktop Editon Upgrade on Windows 2000 Pro
  168. DataBase Error with state 08S01
  169. Optimal restore of database
  170. Dr Watson error running a DTS via a job
  171. Subforms and 1-1 Relation
  172. Access 2000 to SQL Server 2000 upgrade
  173. Inserts....
  174. What to Backup ?
  175. SQLAgent Blocking
  176. sp3 slowing down query???
  177. Stored Prcedure - Parameter Valu from from
  178. Stored Procedure with input and output parameter
  179. Service Manager & Enterprise Manager Problems
  180. filling cell with zeros..changing justification how???
  181. Linked server, heterogenous query
  182. Ansi Nulls
  183. ASP Connections to SQL Server 2000
  184. Copy data between DB with DTS
  185. Why is sp_readerrorlog running repeatedly?
  186. Cant Kill Process
  187. ConnectionCheckForData((null)())??
  188. ASP & SQL Server 2000 Connection
  189. Migration Problems: 7 to 2000
  190. Mysterious Views
  191. Event Id 17055 - Shrink Database
  192. ODBC vs OLE DB
  193. Simple SQL Question
  194. Snapshot Agent at Replication
  195. error 6107
  196. Microsoft SQL Server DB to MySQL
  197. Simulating dynamic SQL in SQL Server 2000
  198. Database for my site
  199. Database link ORACLE to SQLServer
  200. Cant Connect to server //SQEW..? WHAT IS THE PROBLEM?
  201. Problem with cursor and "order by"
  202. How to fetch limited record from SQL Server like 20-40 records out of 20000 records
  203. 'Invalid procedure call' error when using 'DTSSource'
  204. How can I increase the range of an identity column
  205. Replace question...
  206. sysprocesses - TRIGGER
  207. Is it possible to temporarily turn off triggers?
  208. How to fetch limited record from DB (SQL Server)
  209. How to change owner?
  210. query does not return actual row updates
  211. replication of triggers?
  212. Deleting a range of tables
  213. How to call an ASP page from DB (SQL Server)
  214. How to fetch limited record from DB (SQL Server)
  215. SQL Server Product ID Number
  216. Problems with New Sql Server registration
  217. email configuration - mail profile
  218. SQL Server suggestion
  219. Visio install killed SQL server!
  220. DTS Package
  221. SQLServer Replication
  222. No such interface supported.
  223. Clean up replication data
  224. Performance Prob. w/ remote query and stored procedure.
  225. Activating Snapshot Replication through a Stored P
  226. Timestamp Date type
  227. Error accessing view from VB using ADO.
  228. Indexes on Computed columns and ADO
  229. Setting up SQL Mail Session SQL2002
  230. Update Statistics Confusion
  231. Copying/Transferring Tables
  232. Move data out of a table
  233. sp3 installation issue pls help
  234. Moving Image data from one table to another
  235. Replication Monitor reporting a false failure
  236. Equvilant of Yes/No from Access in SQL
  237. Stored Procedure Create Table from Variable
  238. T-sql subsystem Error in a Scheduled Job
  239. stored procedure recordset looping
  240. wrong version after applying sp3
  241. Argument data type text is invalid for argument 1 of replace function
  242. Replication - Should I set the Primary Key to 'No'?
  243. Trouble inserting into a table...
  244. Force Client System DSN to an Interface
  245. Newbie Help
  246. MSQL Server Version with service pack
  247. Deleting all records in a table
  248. Foreign language support
  249. BCP puts nulls in output text file
  250. Win2000 SP3 and xp_cmdshell