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. MS SQL 2000 and raid controller
  2. Some Advices for large databases
  3. SQL 2005, cannot connect??
  4. Executing SP inside SP dynamically
  5. db free space and login timeout -strange
  6. SET IDENTITY_INSERT: Devil in the details...
  7. SQL-DMO, How to check for active connections to a DB (and how to drop if any exist)?
  8. too much text
  9. Stop execution
  10. char nchar vchar nvchar !?
  11. conversion from CHAR to DATETIME error
  12. query analyser in 2005 ?
  13. Sending emails to a database
  14. Will QA debugging work from XP SP2 desktop to SP3a?
  15. external drive, SCSI, same controller...
  16. Drop indexes
  17. Help with DTS Packets
  18. Transact SQL Insert problem
  19. Drop all objects in database?
  20. Recommendation Requests: Learning MS SQL Server for Sybase DBAs
  21. How to select record only in one table?
  22. SELECT DATE problem SQL 2000
  23. create store procedure
  24. DB2 date & Time datatype migration to SQL Server datetime
  25. to use function in a query
  26. Moving DB changes from one server to another
  27. Query slow on Client, fast on Server
  28. Rolling Back SQL Server 2000 SP 4 to SP 3
  29. the function to_days can't use in MSServer?
  30. Help--A error about memory!
  31. Distributon log is growing and System Get too slow
  32. SQL Reporting Services
  33. Limitation of the size of values of Parameters in Reporting services
  34. retrieving unicode using odbc
  35. DTS SQL Task Parameters Error
  36. How can i convert binary(16) to Integer or numeric?
  37. how can i convert binary(8) to datetime?
  38. Group by time span
  39. transdt greater than same month of cycdt (was "Complex query")
  40. distribution db has errors
  41. a copy of SQLFile.sql please :: MS SQL 2005
  42. Will removing a registered server running SQL Server remove the database too ?
  43. Running update syntax at set time
  44. Copy Tabular Structure into a temp table
  45. Removing Blank Lines from Output files - HELP!
  46. Run Faster
  47. Help needed with trigger
  48. dates and Time Comparisons
  49. script .bak restore w/ .trn files
  50. how to mapp two tables?
  51. Local vs. domain account
  52. correct syntax for ADO.net recordset's Select method.
  53. Start Date of the Current week
  54. Simple problem in SP
  55. Weird SP problem
  56. MSSQL Mistake (Excercise)
  57. Reporting Services
  58. Uniqueidentifier as a primary key
  59. Problem in SP.
  60. Access -export-> MS SQL 2005
  61. how to create performance statistics (was "A Challenging Question")
  62. Help with SELECT query
  63. Setting up a new job
  64. mailing from MS SQL
  65. problem with searching dates again
  66. Log in to SQL using VBA in Access.
  67. Analysis Services cube browser
  68. ORDER BY Can be used in view?
  69. 1 line:near '@P0' syntax error
  70. How to convert the SQL from Mysql to SqlServer
  71. Help in "Limit"
  72. Transaction Log
  73. date/time bug?
  74. mail relay problem out of sql server
  75. List of backups
  76. How can I suppress a "Bulk Insert" diagnostic message
  77. SqlServer 2005 "String or binary data would be truncated" when data is OK
  78. Builtin\Administrator login
  79. Char vs Varchar
  80. Slow Cursor
  81. OLAP Performance Tuning
  82. A case of "OverDeletion"
  83. error 4200 Nonrecoverable I/O error occurred on file
  84. weird problem: SP executes slowly, but drop and recreate speeds it up!
  85. Sql If Statements
  86. Get ID from store procedure
  87. Minimum memory requirments to run SQL 2005 "Workstation" on Windows XP
  88. xp_sendmail @from? send on behalf of
  89. SQL Server Processes
  90. cdonts send mail T-SQL - IIS SMTP setup
  91. Problem with dropping tables when set showplan_all is on
  92. SQL data migrattion question
  93. What is Msetup.exe (was "Hmmm")
  94. unique index on X columns but not Primary key
  95. Attaching db file in SQL SERVER 2005 Express
  96. simple? multple ID matching varied content query.
  97. cleaning junk characters in .sql files programatically
  98. Where can I download the OLE DB Provider for Microsoft Active Directory Service
  99. How to reference a local temporary table in the @query parm of xp_sendmail
  100. delete from vs delete with subquery in transaction
  101. Which DELETE will be faster?
  102. Start job from the command prompt?
  103. Date difference in months
  104. String concat
  105. Replication Timestamp
  106. does a view refresh itself when i reference it? (was "Question On Views")
  107. Why SQLServer ?
  108. scouts, badges, and groups of badges (was "Please help")
  109. SQL Server test database to SQL Server production database -- Data Migration
  110. UPdate Cursor
  111. No of Days in a month
  112. SA user logging off and on again w/ same spid
  113. SQLserveragent stopped
  114. Mail attachment with CDOSYS
  115. Query output into a file
  116. bcp out empty column
  117. How tell sql to consider a value as Date Time
  118. Referencing composite Primary KEYS
  119. Linked Servers
  120. sql ntext data truncates in asp
  121. How to append data to ntext field?
  122. Transaction (Process ID 106) was deadlocked
  123. Explicit Transactions
  124. Unable to Locate table
  125. SQLState=S1000, Proc to Export Tables into Flat Files
  126. BCP in stored procedure
  127. Multiple while fetch cursor code
  128. internationalization / collation / utf-8 ?
  129. CAST statement
  130. Comapring date fields
  131. Automatically update datetime field in a database table.
  132. SQL storage images
  133. Database taken offline
  134. bulk insert
  135. Bi-directional Transaction Replication
  136. how to convert numbers into words
  137. Replication problem
  138. Missing records after COMMIT TRAN
  139. 5 Table Join
  140. sending mail from stored procedure?
  141. Error Exporting FoxPro 2.5 DOS table to SQL Server
  142. Prior Sql queries
  143. tables need to be in line across multiple databases (was "Give Me Your Suggestion")
  144. Unused space
  145. MS SQL Server vs MySQL question..
  146. ORDER BY in subquery of a UNION fails ???
  147. Tasks to automate
  148. How could I pass a parameter to DTS package?
  149. Collation conflict
  150. Simplify (and Correct) a query
  151. LogShipping and Database Backup
  152. Caching (storing) calculated members in Analysis Services 2005
  153. Can't find my UDF
  154. CONCAT + expression
  155. Changing Collations...
  156. Microsoft OLE DB Provider for SQL Server (0x80040111)[DBNETLIB][ConnectionOpen (Conne
  157. MSSQL 2005: how to "hide" databases?
  158. MSQuery quandary
  159. Concatenate single quote...
  160. Limitation in Reporting Services
  161. restore database from ldf file only
  162. Emergency help
  163. Linked Server MSDTC Error with Windows Server 2003
  164. Datetime field overflow
  165. Trying to NOT use a cursor...
  166. SQL2005 Prb1 -Row cannot be located for updating. Some values may have been changed
  167. some things not working in 2005 and working in 2000
  168. Autonumber or unidue id generation
  169. sql server 2000 authentication costs
  170. Drop failed for table
  171. SQL Server 2005 install messed up my DSL connection
  172. How to apply a formula to all the field in MDX ??
  173. Website 100% Database
  174. Data access by creating functions
  175. SQL server reporting services
  176. SQL 2005 Express Full text search
  177. How to cleanup all database？
  178. SQL Server 2005 Express Remote Admin firewall issues
  179. Partitioned View
  180. Display any database on the web
  181. OLAP Database size
  182. Migrating from Progress to MS SQL Server
  183. are after triggers really after?
  184. query to find the top 3 in each type
  185. The two query equals?
  186. SQL7 DTS package - passing parameters?
  187. Does Visual Studio .NET 2003 contain SQL Server Report Service?
  188. Update Trigger
  189. Problem with GETDATE() function.
  190. local variable assignment in CREATE TRIGGER
  191. view design
  192. Drop the end of an ip address
  193. Moving a SQL Server 2005 Database from the local network to an online server.
  194. Tracking Old New Values
  195. Merge Replication
  196. Security Issue
  197. Filling in missing data for a continous range, e.g. x-axis ..
  198. Organisation Chart
  199. DTS issue
  200. Linked server DTS issue
  201. SQL Server 6.5 replication issue
  202. how does SQL Server calculate GETDATE? (was "Newbie Question")
  203. smalldatetime comparison between local server and linked server fails?
  204. CrossTab Query
  205. Running total
  206. geting timeout error in application when inserting record
  207. Sql editor
  208. Get Stored Procedure
  209. SQL AGENT issue due to domain change
  210. Dynamic SQL (SP)
  211. ERROR 28000 Invalid authorization specification
  212. Can you pass an array into a stored proc
  213. query to give all table sizes on a database (was "query help")
  214. job listing
  215. Inserting into temp table..
  216. Using the convert function HELP!
  217. Modify results of a View
  218. Sql Server Datatype
  219. Which trigger executes first?
  220. FTP.exe and DTS
  221. Procedure Cache Ration in SQL Server 2005
  222. XML output.
  223. Row cannot be located for updating.
  224. How Can Insert A Data In To This Table?
  225. Self-Signed certificate
  226. opening my client's DB locally
  227. peoblem with connectstring for connecting informatica to sql server
  228. recordset
  229. SQL server
  230. Connection in vb 6.0 app
  231. restrict local cube
  232. select all filenames that have ArticleID=int (was "SQL statement")
  233. Select string concatenation
  234. INNER JOIN query - performance
  235. autonomous transaction
  236. display only the listing with the lowest price (was "Need a little help here.....")
  237. add a table to a publication
  238. collecting values into a variable in a loop
  239. STORE PROCEDURE and DTS
  240. SQL Server not showing the drives
  241. BCP SQL Server 6.5
  242. MSDE - Grant Permission?
  243. what should I do to connect SQL server to my computer (was "New to SQL")
  244. text truncated on INSERT (urgent)
  245. How Can I Convert Decimal To Hexadecimal
  246. suppess resultset in stored procedure ?
  247. Database design need any critic/feedback
  248. Sync Sybase and SQL server 2000;
  249. Incorrect Values
  250. efficient JOIN query