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

  1. SQL to find non matching rows between similar tables
  2. @@Identity
  3. How to findout if the column is Unique or Key?
  4. How to copy 1TB database
  5. Merge Replication Question
  6. Master DB Restore
  7. Sp Output Issue
  8. Copying across servers.
  9. Global NOLOCK hint
  10. ODBC and Scheduling Agent
  11. need help to build a pivot table
  12. DR: Merge Master DB
  13. SQL-DMO Attach: The physical file name 'C:\Program' may be incorrect.
  14. problem deleteing records which has null values
  15. MS Access Front end and MSSQL 2000 backend
  16. log file size
  17. Creating view problems
  18. MSSQL Full-text search service (does not work)
  19. T-sql
  20. Identifying Invalid Objects
  21. Store " ' " in database...
  22. With Execute As Caller
  23. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
  24. Sending Email via DTS
  25. What is the best enterprise management tool for MS-SQL?
  26. sp Help! Dynamically Order By column specified in Sprocs Input Parameter?
  27. How to run/execute a DTS from a vbscript
  28. permisssions given to public role
  29. Application troubleshooting (SQL Server dropping connection?)
  30. Time Out error
  31. Bulk Insert from Fixed Width?
  32. Invalid object name '#temptrans'
  33. Dbcc Traceon 1717
  34. Compress Backup
  35. DCOM error
  36. Limitting rows returned in stored procs
  37. MS SQL Frontend...
  38. One for the Analysis Server gurus...
  39. A cursor with the name 'xxx' already exists
  40. Retrieving only updated rows in an update trigger
  41. updating a table with a value from a select statement
  42. SQL and Oracle Help
  43. loop a query
  44. Inserting Joins
  45. Optimization and Integrity Checks
  46. Procedure In Transaction??
  47. field fills with spaces (%20), and i dont want it to
  48. every topic with number of users (was "SQL Statement Problem")
  49. T-SQL help
  50. Linked Oracle server...
  51. Serializing Select Output
  52. Date Conversion Error in DTS when scheduled as Job
  53. Group By / Join Query help
  54. best practices naming conventions of Tables / Fields
  55. MsSQL 7.0 speed problem
  56. Case Issue
  57. REFRESH CUBE command to Analysis Services from SQL Server
  58. Referencing MDX Query results in SQL Server
  59. MS SQL Statement Datetime Problem
  60. Contradictions in datetime resultset
  61. Profiling triggers
  62. Table level error handling
  63. Slow running queries...
  64. Doing a Select after Insert is not returning a recordset from a SP
  65. SQL Server triggers on insert
  66. How to boot SQL 6.5 in multiuser mode?
  67. Need more room than a NVARCHAR
  68. translate a delphi function to sql
  69. MSSQL 6.5 OS requirement
  70. Executing Query batch ...
  71. maintenance plan advise
  72. Sequence question
  73. Replication: Subscription Not Getting All Records
  74. How do I Schedule a Restore?
  75. Reporting Services SP2
  76. Question on join syntax
  77. Variable Field Names in a Stored Procedure
  78. xma into sql server 2005 express
  79. Flat Files
  80. One-To-One vs flat file
  81. I need to load custom data to Analysis Server (MS-OLAP) without going through any OLE
  82. removing characters
  83. Recommended naming conventions
  84. Error 18452
  85. Cannot generate SSPI Context
  86. Stored Procedure Problem
  87. MSAccess Locks MSSQL tables
  88. Easy way to email DBCC SHOWCONTIG results?
  89. Alternative Solution for Fetching the Data for the Hierarchy
  90. Real SQL RAM usage
  91. Table is not accessible
  92. Timeout expired
  93. Top and Union Combined
  94. Isnull generic update stored procedure
  95. Date Range query - working, but needs tweaking !
  96. TempDB is full!!!
  97. dts package - append function
  98. Post XML via Stored Procedure
  99. sorting question
  100. only show the users that don't exist in this table
  101. DSO Clone Aggregations
  102. sysconstraints info
  103. bcp file format
  104. Reporting Services
  105. schedule table
  106. Splitting a column into multiple columns
  107. master.dbo.xp_smtp_sendmail
  108. Log shipping error
  109. update field that's part of the PK
  110. Generating Text Sequence
  111. Bulk Copy Option
  112. BCP linked server
  113. analysis services - action - cell value?
  114. "Cleaning" serial numbers
  115. DTS and multiple instances
  116. Help in Query Building
  117. cornerstone sql-server dba book?
  118. Is there a way to group some columns but not others?
  119. For Analysis Services gurus
  120. Creating tables at runtime to model dynamic data
  121. Pros and cons of udl and dsn
  122. SQLDMO has not been registered
  123. Maximum number of fields
  124. Database Entry Problem
  125. Dts
  126. Recursive query
  127. PerfMon - SQL Server Locks object - Avg. Wait Time
  128. Case sensitive search on non-case sensitive database.
  129. Update Multiple columns
  130. Default value in SQL Server functions
  131. Need your expert opinion in DB modeling
  132. Cannot resolve collation conflict for equal to operation
  133. Stored Procedure Help
  134. Viewing transaction log without original database
  135. Running dynamic SQL script
  136. Can't add some tables to replication
  137. How to check which stored procedure is using a particular table?
  138. Restore FileListOnly results
  139. Checking for unused/empty tables
  140. Unable to use DTS because of lost oledb driver!
  141. Counting Rows
  142. Redirect Name Pipes
  143. DBNetLibConnectionOpen(Connect())
  144. Moving Entire SQL Server to new box
  145. Alert if table contains data.
  146. executing statement in a variable
  147. 1 Problem, 3 Possible Solutions. I need your input
  148. Split Function
  149. Problems installing SQL Server Stand Alone
  150. ORACLE to MS-SQL Questions
  151. transaction log question
  152. Synching Users Across Databases
  153. SQL Server \ COM \ Classic ASP \ DTS mystery
  154. Registering New SQL Server..... SOS!!
  155. scheduler using a financial calendar
  156. nhibernate?
  157. Adding of articles with Merge replication
  158. Changing values in a DTS global variable...
  159. start Xp Service with xp_cmdshell
  160. Query Anayzer Export
  161. Execute DTS from Trigger
  162. SQL Update Query
  163. Retrieiving large text
  164. best hd config: (3) 136GB scsi drives?
  165. Function VS dbo.Function
  166. Retrieve records on their input order
  167. General Question on Development Cycle
  168. Error on BCP
  169. find all modules and return something if the user has permissions
  170. Input box for query results
  171. Date select - Trying to avoid dynamic *shudder* SQL
  172. Sql*plus ???
  173. @Variable inside a select statement
  174. Excel in a SQL Server Field
  175. Adding two alias columns
  176. Comparing versions of sql server
  177. Transaction Counters?
  178. trouble with distinccount..
  179. MS-SQL to ORACLE
  180. Question in FTS and FREETEXTTABLE
  181. Deadlocks on 2000
  182. Perf Tune Sproc
  183. Optimized Query
  184. XML DOM using DTS
  185. Urgent Help!! Upsizing Access to ADP: Error: 7874
  186. ptroblems installing VB program using DTS
  187. AlphaNumberic Join
  188. Database connection from ERWin
  189. Got Notus Lotes
  190. SQL Server/MS Access
  191. latest row per ticket number (was "I need a very good SQL genious to ...")
  192. remove duplicae data
  193. Copy data base from 2000 to 7.0
  194. Difference b/w MAX() and TOP 1
  195. Windows XP PRO sP2 and SQL SERVER
  196. Default Language for User
  197. Installing SQL CPT - Sept.
  198. Stored Procedure to command line with parameters
  199. Upsizing Access 2K to SQL Server 7
  200. Stored procedure problem
  201. Mail Merge Using Works 2005 Suite
  202. SQL Unattended Import
  203. Foreign key ERROR
  204. Please Help! Backup and Restore Problem
  205. Replication on VMware
  206. How to spool into a script file in SQL Server?
  207. SUM of floats
  208. Floats numbers error
  209. OpenQuery and Dates
  210. How to set Win32 process of a Execute process task in a Activex
  211. Loading a large csv file with dts
  212. Connect to ms sql server database without having ms sql server installed
  213. Table and Index Size
  214. Modifying Display Results
  215. FTS Q - Proximate meaning of phrases
  216. Rudy - wanna kill all the dups
  217. Tranlog Backup Script
  218. Error with linked server
  219. remove duplicae data
  220. Log Shipping Vs Replication
  221. FTS Q - Proximate meaning of phrases
  222. Extra character
  223. Backups on clustered
  224. MSSQL Server 2000 - PHP - Windows 2003 server - IIS 6.0
  225. add new column in between other columns (was "is it possible")
  226. bcp file format...its killing me...pleaseeeeeeeee help...
  227. Is Storing Images in MSSQL feasible?
  228. change SA's password
  229. Leading zero filler help please...
  230. SQL 2k Replication - view to table
  231. September CTP of SQL 2005 is out
  232. HP Data Protector for Sql Server -- reviews?
  233. number of active connections
  234. New to SQL Server
  235. SP behaving strangely
  236. How can I compare two databases?
  237. drop all the indexes on a table
  238. Exporting TEXT Field into CSV file
  239. How to make JOB without xp_regread procedure
  240. How to tune my query
  241. How to convert Seconds to DD:HH:MM:SS
  242. Import data from excel file to Mircosoft SQL Server
  243. RE: Creating A Duplicate Database Without Enterprise Manager
  244. British English
  245. Violation of PRIMARY KEY constraint
  246. SQL Server Design Issue
  247. When a sproc or table was Last Used
  248. date query problem
  249. Clustering
  250. MS SQL Failover Cluster