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. Stored proc calls another stored proc
  2. can not browse dimension
  3. Trying to avoid a cursor...
  4. Indexes degrade too fast
  5. Having trouble converting to datetime in SQL import
  6. Ordinal Number in Results
  7. Waitfor NULL
  8. To Varchar or NVarchar, that is the question
  9. Combine multiple sql calls into 1
  10. DTS and Oracle
  11. Best Practice for updating single field in N rows
  12. Should i keep revising for SQL 2000 ?
  13. Can this be done faster?
  14. fn_get_sql , no full SQL data
  15. How to change the Identity value
  16. freeware to compare db shema ?
  17. Strip out "The" from alphabetized search results?
  18. Week SQL Query
  19. many-to-many selection
  20. How do I loop thru a record set in a stored procedure?
  21. Distributed transaction Issue
  22. Save DTS Package Error: Unspecified Error
  23. Selecting the last 3 characters from a string
  24. How to get two different SQL servers to talk to one another
  25. rundts from within a stored procedure
  26. Changing Field name of an existing Table
  27. Creating reports?
  28. need lil fast help
  29. Insert record into temporary table from a select statement
  30. How to check DB sizes?
  31. Database Restores
  32. Service Manager in 2005 not found
  33. SQL script to set a DB to Simple then run a reorg and reindex then set DB back 2 full
  34. Any ideas on how to speed up this sp?
  35. NEED Query to find apostrophes in table
  36. Combining rows in a table(again)
  37. A simple trigger that doesn't work
  38. Merge Replication
  39. How to make the pie chart size bigger
  40. Problems Access Violtions Adoquery
  41. Help Finding Current Size of a Field
  42. convert style for datetime
  43. Stored Procedure to list values from different tables
  44. Set-based INSERTS rather than a loop
  45. Unkown source of server connections
  46. recompute statistics in sql*server via JDBC
  47. Transactional Question
  48. Debugging Triggers
  49. Identify value in a column nullified
  50. set-based INSERT query - Post rewritten hopefully much more clearly
  51. connect to a remote database
  52. Delete Multiple Records from Multiple Tables
  53. Move DTS package from Server A to Server B
  54. Simple sql ?
  55. Database Design
  56. find? instr? indexof?
  57. How to do this without using a cursor?
  58. ODBC Error in ConnectionWrite
  59. Aggregate Function On SubQuery
  60. 2000 database restored to 2005
  61. Comma delimited list of IDs to a recordset from 2 tables...
  62. script to get Total number of Trasnactions on sql server
  63. Inserting non english values using jdbc
  64. SQL Serv 2005 and 2000 both on my laptop
  65. Update Stored procedure
  66. Best way to load data from text files
  67. SELECT question, grouping values
  68. MDX for last 28 days
  69. Maintenance Plan on 2005
  70. Table Variable Problem
  71. Fuzzy Search?
  72. Sybase Linked Server Query Problem
  73. Table name from syscolumns
  74. CREATE a Temp Table via "EXEC (@SQL)"
  75. Track how many objects created on a server
  76. adding to text
  77. Problem With DTS Package - To Delay Process
  78. DB Migration Project Plan
  79. sql db 2005 compatible to sql 2000 ??
  80. Cursors
  81. Calculate median of difference in days between records
  82. Deadlock on TAB lock
  83. How do you write a query to return all record with parameters?
  84. Full Text Search vs LIKE Search
  85. Problems exporting excel using DTS
  86. Retreiving TranLog Filenames from Windows Directory
  87. Rol Security in SqlServer 2005 Express Edition
  88. Return values in SP
  89. SQL Diagrams and Back and Restore
  90. Return values in SP
  91. SQL Compare
  92. Invalid object name 'dbo.getname' ?
  93. primary key won't auto-update
  94. DTS Advice - Appending to a Text File
  95. Logic on UPDATE query
  96. Increasing Speed
  97. Previous value best method
  98. restore to new db restores less data than what is in the source backup file
  99. .Update creates new record but all fields null
  100. Intergration Services
  101. Can't connect to SQL server 2000.....
  102. Question
  103. Need to Return x rows but Select Top doesn't work with variable
  104. trying to find non identity primary keys
  105. Problem adding linked server to Oracle
  106. Nested Query Troubles...
  107. Best Practice: Primary key in joing table
  108. Create INDEX within CREATE TABLE DDL
  109. Adding a leading character to a string
  110. Is the re-start done?
  111. Syncronisation of multiple databases
  112. Data Provider List Missing...very odd SQL 2000
  113. error in connection
  114. sql server express
  115. DTS connection problems with IBM DB2 UDB for iSeries OLE DB Provider
  116. How to find the median?
  117. Reporting Services, Good SQL 2005 book
  118. SQL Server 2005 Security - TSQL
  119. Uniqueidentifier
  120. SQL Server 2000 - tempDB problem?
  121. SQL 2005 snapshot problem
  122. Problems upgrading from 2000 to 2005.
  123. SQL2000 log file issue
  124. duplicate record
  125. ODBC problems
  126. Stored Procedure Problems...
  127. dbo
  128. comparing dates(Minutes, Hours etc)
  129. agent mail / outlook 2003 catch 22
  130. Problem with full-text search and PDF
  131. Using DTS .. Dynamic Dest Filename
  132. Sysadmin role
  133. SQL Server - Error: ex_raise2
  134. How to uninstall SQL Server 2000 SP4?
  135. BULK INSERT failing with truncation error...
  136. Delete partial from column
  137. Pseudocode to SQL stored proc math operation
  138. SQL Injection
  139. date Intervals
  140. Nested Set Model
  141. sp_OACreatesp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload' in 2005
  142. sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload' in 2005
  143. Error - There is insufficient system memory to run this query.
  144. Hard Drive Crashed. master & user db mdf & ldf files lost
  145. SQL Server 2005 & 2000 tool compatibility
  146. Connection busy with results for another hstmt...
  147. Merge Replication with different Service Packs
  148. Database Restore question.
  149. Oracle to Sql Server conversion
  150. Firewalls and SQL Server
  151. Export to Excel using DTS
  152. execute dts from stored procedure...
  153. Builtin\Administrator login
  154. Trouble declaring hierarchy using FOR XML EXPLICIT
  155. Base Database implementation
  156. Using a Variable to Call a Stored Procedure Name
  157. Help again edit parameters from MDB to ADP
  158. Translation help please
  159. Read_committed_snapshot
  160. Emailing SQL reports on button click
  161. Initialising parameter/variable
  162. Is there a way to use wildcard characters...
  163. Get Number of rows Deleted
  164. SQL Server 2000 - Reporting Services
  165. Scheduled DTS job to run a cmd file not working
  166. Datatype Conversion Problem.
  167. Datatype Conversion Problem.
  168. Using BCP
  169. Obtain "trusted connection" ?
  170. DTS Job Failed
  171. compare DateTime values
  172. Default Data Types in SQl Server
  173. connecting to sql server
  174. How to ask a question...(MS KB Article)
  175. Trigger procedure execution on database creation.
  176. Help with INSERT multiple tables in many-to-many relationship?
  177. query to parse out values from one column into different columns
  178. column data in the single row
  179. How do you install SQL Server Management Studio for sql 2k5 ?
  180. taking date from user
  181. Multiple Joins
  182. function on heirarchy nodes
  183. function on heirarchy nodes
  184. from MSSQL server to MySQL
  185. Recovery Question.
  186. replace special character
  187. Recovery Question.
  188. some simple proc help
  189. Sybase Provider ran out of memory
  190. ActiveX to copy and rename file
  191. Memory increasing for the SQLServer process
  192. SQL Mail Licensing
  193. Wrong date sort order in Enterprise Mgr
  194. Identity column jumps indefinitely
  195. Analysis Services design
  196. How do you obtain SQL Reporting services (was "I know this sounds silly")
  197. sqlboot.dll is corrupt or tampered with
  198. sqlboot.dll is corrupt or tampered with
  199. How many types of UDF are there?
  200. Creating Column Grand Totals in SSRS 2005 Report
  201. Integrate in SQL Server 2000
  202. Create a table from select Queries.
  203. ADO does not add to Errors collection after the second FETCH NEXT in a SP
  204. Query highest entries from database - pls read more.....
  205. SQL 2005 - ignore policy to allow blank password
  206. Converting text to date
  207. General notion about Clustered Index
  208. General notion about Clustered Index
  209. dateadd
  210. Nested CASE to parse a string
  211. Advice on Web Server & SQL 2k Server Setup?
  212. view returning 0 when selecting, but fine in QA
  213. Time Filter
  214. SQL Server 64-bit: cannot register Analysis Server
  215. Converting a 6.5 compatible db to SQL Server 2005
  216. prompt user from stored procedure?
  217. Broadcast existence of SQL Server
  218. SQL Server 2005 Mgmt Studio "Do you want to save changes..."
  219. how to create new database in SQl Server 2000
  220. how to create database inSQl server 2005?
  221. [OT] User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR .Net
  222. Update day,month and year of a Datetime
  223. Schema design for Analysis Services
  224. Impliment MySQL LIMIT command on SQL Server
  225. Transactions and the "lost update" problem
  226. backend update??
  227. SQL Server 2000 to 2005
  228. ROUND unexpected result
  229. execution query problem in SQl Server 2000!!!
  230. Scheduler not yielding?
  231. Permission to execute Stored Procedure
  232. generating full script tables and data?
  233. Server: Msg 2511, Level 16, State 1, Line 1
  234. filegroups in sql server...
  235. Need another pair of eyes sql 'Order by'
  236. Searching for a word on each table on very field
  237. SQL Server 2005 Database Mail and Agent error
  238. Cannot delete remote server
  239. create trigger that prevent order being processed if the amount is 0 in storage
  240. Help on Cubes
  241. tables Execution problem in SQl Server 2000
  242. Rename a table in Microsoft SQL Server 2005
  243. never seen a query like this before
  244. Number of 'Periods' in a date range
  245. Help me clear the cobwebs
  246. General design efficiency question
  247. Faq
  248. Read this first! FAQ for DBForums Microsoft SQL Server forum
  249. Could not create a Foreign key on 2 unique columns
  250. migrating 7.0 to 2000