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. Quick Question on Relationships
  2. Complex Query
  3. Datetime issue
  4. need a single sql statement
  5. looking for a guide
  6. Isnumeric in SQL SERVER 7
  7. Problem Installing MS-SQLSERVER on Laptop
  8. error [I/O error (bad page ID) detected during read at offset 0x000001ad65a000
  9. Tip : How to send mail without xp_sendmail from SQL server
  10. Scalable solution??
  11. DTS - Access Commection Properties
  12. Problem access db from VB.NET after restoration
  13. replication question!!
  14. Replication help!!
  15. ReportingSvcs
  16. VFP and Linked Servers OLE DB Errors
  17. create a database called DBA_Status (was "Question!!")
  18. Concatenation of Text
  19. Replicating stored procedure/trigger permissions to another database
  20. Calculating values in multiple tables within a UDF in SQL server
  21. can i keep sql server 2000 if upgrade win 2000 to win 2003 (was "sql server 2000")
  22. Traansfering DTS Packages
  23. Reporting Services - Problem with Subscriptions
  24. Simple Date Problem Please Help!
  25. Microsoft Cursor Engine error '80040e38'
  26. retrieve " using bcp-urgent
  27. Ms Reporting Services install
  28. convert a gregorian date in mm/dd/yyyy
  29. Invalid Cursor State
  30. Missing system stored procedures
  31. Killed/Rollback process hogging ALL CPU resources.
  32. please test my script to analyze table keys (was "Submitted for your review...:)
  33. simple excluding of character query
  34. updating daily information in a history table (was "Help-Brainstorming")
  35. Invalid Column Name...can't figure this out
  36. Help with "Create View" statement and Eorror Message
  37. Deleting Records
  38. SQL Server Standard edition
  39. quick casting problem...
  40. top 3 of all top products (was "need help with a query")
  41. what is Security Account Delegation (was "hi")
  42. Am having script Problems with Duplicates and Inserts
  43. Linking SQL server to Frontpage
  44. Data Insert
  45. update table
  46. cal number of days in between dates
  47. Database Properties shows Zero space available
  48. Sort MDX Query
  49. Balancing the Data ,Replication ?
  50. replmerg encrypting password
  51. Using a client to connect to a remote sql db
  52. Datetime conversion
  53. getting year/quarter/month/day in the right order (was "Dates")
  54. Permission Issues running DTS from Agent
  55. Help needed to improve the performance of the query
  56. SP Update overhead
  57. Anybody ever use Actuate e.Reports?
  58. tracking member views of clan pages (was "table design help needed")
  59. view and print contents of query analyzer (was "Big time Newbe needs help")
  60. Data compression over "low bandwidth" lines
  61. OpenRowSet Column Names
  62. Replication rows getting deleted at publisher
  63. SQL Mail
  64. stored procedure works but very slow (was "Optimization")
  65. adding a new record takes longer and longer -- archive? (was "Table help")
  66. IN Operator problem
  67. Hitting an Oracle view
  68. generate codes excluding profane words (was "Odd way to spend my lunch hour...")
  69. backups through EM on remote registration
  70. getting a constraint value from query in a trigger?
  71. sp_spaceused shows negative unallocated space
  72. Single User Mode
  73. error when I run script
  74. Passing Parameters from Reporting Services
  75. MDX query (was "syntax error")
  76. nsqlprep.exe
  77. how to import an Oracle 8.1.7 dump file into SQL server 2000 ?
  78. dynamic table name (was "Please help !! SQL")
  79. how to export only the stored procedures to a file ?
  80. change DB owner
  81. "Default bound to column
  82. No SQL Server Reporting Services Checkbox?
  83. Creating a SQL script file from a stored procedure
  84. Zero length logs?
  85. Copying data from another DB on server problem
  86. Function with EXECUTE problem
  87. How do you pass variables to a statement plz help
  88. several alias for the same column
  89. Max size of a table
  90. Same query, different results
  91. Delete statement using a join plz help
  92. Dynamic Built Where Clause - Error in Stored Procedure
  93. How long does it take for sp_repldone to execute?
  94. Running the same subquery multiple times
  95. Connect to Sybase in a DTS Package
  96. Indx newbie: please help
  97. sorting dates
  98. LIMIT rows with an offset
  99. DTS Scheduled Time
  100. Updating systemtables directly to change column-collations
  101. SQL upgrade and Domain change
  102. Sql server Info
  103. Lost Index device file and database suspect
  104. Stored Procedures-Is there any way to circumvent it taking the variable "literally"
  105. SQL Statments in an Active X script
  106. Dynamic SQL in procedure compiles but does not run
  107. BCP Error handling
  108. Error - Record has been changed by another user
  109. Need table of words/glossary/etc.
  110. Display Results Based on Query
  111. Writing errors / status Information of DTS Package execution
  112. ODBC connection to SQL server DB
  113. Outer join or procedure?
  114. Get Value from CURSOR
  115. Update trigger plz help
  116. From Select to Update
  117. Nested SELECT query that also returns COUNT from related table
  118. RowId in SQL server 2000
  119. Update a record in another db using a trigger
  120. Fast Uploading Data from Client to SQL2000 Database
  121. History/Data Change File Approach
  122. Notifying Trigger
  123. Cannot update ID because of no existing relationship
  124. Replicating design changes
  125. Encryption for sql server
  126. Restoring the database using stored procedure
  127. Replicating data over the Internet
  128. Combine two tables into one RS
  129. Connect to sql server through internet
  130. Dump MSSQL Data as SQL Statements
  131. Cant connect to SQL server at work from home project
  132. Update by Date help please
  133. Transanction Log Backups
  134. SQL Mail / SQL Agent Mail
  135. Datetime Query
  136. IsNull() equivalent in MS SQL 2000
  137. Full text indexing
  138. how to find a simple quote in a row
  139. SQL Agent Worker Threads
  140. Windows Authentication Issue;
  141. Decimal Division
  142. Calculating with null values
  143. Specify word breaker
  144. Need help writing stored procedure involving dates
  145. Syncronizing 2 indentical tables in 2 different db
  146. Good SQL Query
  147. Storing Daily Cached query results in SQL Server
  148. data cleaning
  149. OpenRowset
  150. Simple insert query VERY slow !
  151. Weighted Average in Analysis Services
  152. Object variable or With block variable not set (was "Frank")
  153. System/User view
  154. restoring the database
  155. DTS Errors with Access?
  156. Event Handler not working
  157. dat file
  158. how to update if customer doesn't exist (was "Help with an update")
  159. Heavily indexed databases
  160. Equivalent of val() function in SQL server?
  161. invalid syntax near keyword default (was "Why do I get the following error?")
  162. How to call Stored Procedures?
  163. Problem with SQL server - Excel
  164. Help Req with Locking Tables...
  165. Locate Database Object Given The Page
  166. Not able to retrieve Rows from Small table-So many time for so long
  167. Veritas database backup
  168. looping record by record and processing
  169. Random Values
  170. maintenance plan script?
  171. Data intergrety between 2 enviroments
  172. What's wrong with this stored proc
  173. Don't understand GROUP BY...
  174. Error handling
  175. Limit on row size for reading fixed-width .txt?
  176. SQL Server Agent and Mail
  177. Performing an Insert using NOT EXIST
  178. FoxPro Linked Server and Passing Variable within OPENQUERY
  179. Nested Stored Procedure?
  180. Trancation Replication Problems
  181. SSIS Deployment to Server
  182. SSIS Security on File Deployments
  183. SSIS DTS Wizard cant convert Oracle Data
  184. "Blank" Data Values in SQL Profiler
  185. Help with Time Series Fluctuation???
  186. unicode data
  187. SQL-Server memory consumption
  188. SQL Backup, Volume Shadow Copy & Trans. logs
  189. MSDE worth using or should I invest in mySQL? (was "MSDE")
  190. DTS Job ActiveX Script Help
  191. Parsing
  192. Indexed Views
  193. How do I get Table Owner?
  194. How to reduce database file size.
  195. Primary file is full
  196. SQL Game
  197. What will be a good way to backup master db?
  198. date format cannot be saved
  199. Need help with restoring database
  200. Date format problem
  201. SQL2000 & master db permissions to end users
  202. DTS Question
  203. Full text indexing failure - Large pdf files
  204. error log cycle
  205. German Umlaut 'ü','ä' .. from ORACLE to MS SQL
  206. MSDE Security. Oxymoron?
  207. Need urgent help with pemission problem
  208. Logging table activity
  209. Agent Job Error
  210. Need to compare data in SQL to Oracle / import changes
  211. Enterprise Manager User Log-in DB Visability
  212. FoxPro Triggers call FoxPro Stored Proc calls SQL Server Stored Procedure
  213. 'Instead Of' Triggers particularly Update
  214. database file group is full
  215. Log reader agent
  216. how to set default data & log directory
  217. SQLMail
  218. DTS Question
  219. grant select on all tables to new user
  220. Unsupported VM encoding
  221. Checking publications are subscribed to all subscribers
  222. Learning stored procedures
  223. Stored Procedure versus View
  224. Collation error when adding new user through EM
  225. WHERE evaluated after JOINS?
  226. Sql Agent
  227. Raid
  228. SP execution plans going bad?
  229. Transaction Log Backups
  230. Inquirying about DB training
  231. Date Format to show Month Year
  232. Log file is full
  233. Trigger blues
  234. Opinions wanted: Migration Access BE to MSSQL
  235. performance monitoring
  236. A Commission field
  237. Personal edition: Login Failed
  238. Log file
  239. "Users Connections" too high - 1425
  240. How to find NOT FOR REPLICATION IDENTITY COL
  241. Backup - Restore Data
  242. MSDE 2000 Vs SQL Server 2000
  243. how to set up client and server (was "Enquiry of SQL Database")
  244. SQL2k Maintenance Wizard - Single User Mode
  245. SP returning multiple 1 row results, want all in one resultset for report
  246. sp_refreshview
  247. Oracle Java Packages in MS SQL Server 2000
  248. restrict len(ntext) in query
  249. Run a SP when SQL Server starts??
  250. SP using 2 databases returns Null which cannot be correct.