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. DELETE on FK
  2. Insert Statement Help
  3. The process is running and is waiting for a response from one of the backend CONNECTI
  4. Question on changing startup parameters
  5. Allow user to Kill Sesions
  6. creating a FK on existing tables
  7. IsNull for decimal acting up
  8. SQL parameter Query & wildcard
  9. SQL 2005 Reporting Services Location
  10. Cursor Process Coding Problem
  11. Issue of Blank Emails when checking for Free Space on Disk of Servers
  12. DTS Job fails when scheduled
  13. SQL 2005 Server Unattended Installation
  14. cobol -> SQL2005
  15. Need To CalcuThe Number Of Days Between The Current Date And A Stored Date
  16. timestamp
  17. sp to send a message to a user ?
  18. SQLServer interview quiz
  19. Simple query question
  20. getting only the first occurance of a sql select statement
  21. Sequencial, Unique Number tied to header, Locking Q?
  22. SQLBackup
  23. Newbie - Is this a job for a sproc?
  24. connecting to sql over internet
  25. DB design question
  26. cleaning wrong PK FK
  27. keeping last 10 entries by ID
  28. initialize all fields when table is created
  29. a too long query MAX(CASE WHEN
  30. DTS from excel file (excel filename is different everyday)
  31. create trigger not insert if
  32. Error message is given, plz give it's reason for occurance.
  33. HAVING (COUNT(category) > 1) , not only 1 row
  34. Help with MDX Query
  35. CURRENT_TIMESTAMP - 5 minutes
  36. SQL 2000 database connection problem
  37. Security Gurus - Questions for you
  38. SQL Server Security - Questions
  39. Creating Procedures from file and .net
  40. Backup routines
  41. strange out of range date in a datetime field
  42. How can I decrypt from Oracle ?
  43. select into really faster
  44. change reporting services location (2000)
  45. Path spaces using xp_cmdshelll
  46. varchar to Oracle Clob
  47. reinstalling reporting services
  48. MS SQL performance from 10" to 3 minutes
  49. equvialent for MySQLs On UPDATE clause
  50. Is this possible with a mdx-query
  51. SQL Licensing Inquiries
  52. Database Alias
  53. List of values that make SQL Blow
  54. SQL 2000 Server, Need help creating documentation/disaster recovery plan...
  55. pull subscription
  56. Poor Performance - Nested Views & Complex Joins
  57. would like to avoid cursor, please help
  58. TSQLUnit
  59. Replication Details
  60. incorrect syntax after server up for a few days
  61. linked servers - Domain IDs
  62. median function
  63. 'Space Available' Issue
  64. Having trouble with EXISTS
  65. How To Extract Data From A Concatenated Field
  66. Linked Servers
  67. ODBC connection is not working
  68. Old Failed Replicarion job still appearing in new job
  69. data synchronization
  70. Increment a value
  71. Insert a word document into SQL Server
  72. Login failed for user 'sa' . The user is not associated with a trusted connection.
  73. BLock records using UPDLOCK
  74. Can someone proofread my 'remove duplicates' script?
  75. Multiple backslashes in physical file name
  76. very quick stored proc syntax question
  77. SELECT feilds in recursive table
  78. Debugger problem
  79. can i use "translate" in sql server,is it a keyword
  80. Intermittent Connectivity issues though network is fine
  81. order results by date not working
  82. whats wrong in this
  83. Rewriting Insert Statements
  84. Any clue to make this query run faster
  85. How send data to another remote SQL Server
  86. Reducing the size of the transaction log file
  87. Need SQL Help
  88. Can't telnet x.x.x.x 1433 on localhost
  89. pagination advice
  90. Moving SQL Server out of a domain
  91. Where should I create ERD?
  92. Conditional Join
  93. LIKE is considered awful from performance point of view?
  94. A tool similar to SQL Impact from Quest?
  95. Calling UDF over Server Link
  96. Is there any idea for the view in ERWin?
  97. Database Comparison
  98. Copying a DTS Package and Jobs
  99. SQL Range Lock?
  100. Kill Process
  101. Kill Process
  102. Access front-end - concurrency
  103. Concurrency question
  104. Error using non-ANSI Joins (Was "Ansi")
  105. How much storage space does nvarchar() eats? Always max?
  106. incorrect syntax near LEFT
  107. List from three tables
  108. Migrate from DB2 to MSSQL
  109. easier email alerts from sql 7/2000?
  110. run backup (maintenance plan) from Batch (.bat) file
  111. How to handle schema changed from another server?
  112. Reading Cubes with OO ?
  113. Simple SQL Question regarding Update Query
  114. SSIS performance metrics
  115. What is this SSIS language?
  116. New line in query
  117. Global temp tables in SQL Server
  118. Using BETWEEN with SQL Server Dates
  119. First query is slow
  120. Trying to obtain past dates
  121. leat outer join
  122. Dts package to run every 10 seconds
  123. Error 21273[SQL-DMO]
  124. SQL 2K5 Class
  125. Report Service cannot find Report Server
  126. Need assistance with SQL Analysis Services
  127. Temp table SQL question
  128. Triggers - Possible to specify effective timeframe?
  129. Compare Row Counts
  130. Analysis Services Developer Studio Question
  131. Reporting Services - Analysis Services PROBLEM ?!
  132. Dbo
  133. How to transform "full width" String into "half width" String?
  134. login
  135. Find columns which execute updatetriggers
  136. TimeOut expired error (was "Need help...")
  137. Optimization Issue To Big
  138. Logic problem
  139. DTS -- unpredictable order of records -- why?
  140. Variables in query, error in my code ?
  141. Is it Possible to Join 2 Queries Using MDX?
  142. Insert Decimal
  143. Security questions.
  144. OpenRowset char conversion
  145. Change Unc Path On Sql
  146. Trouble Backing-up all databases to network folder using a Maintenance Plan
  147. Declaration of record variable
  148. Create a SP that will launch a DTS package
  149. OPENXML Question
  150. Beginner's question to coding
  151. error in accessing stored procedure
  152. all the ids in temp2 should have same client and drug (was "Need Sql Help - Urgent")
  153. Need to Refresh (Killing is not an Option)
  154. SECURITY in MS SQL Server 2005
  155. SQL 2000 administration
  156. create a database in visual studio 2005 (was "database")
  157. I a view in Access Project I see only "all columns"
  158. Group by query
  159. Should I have to use SQL Server 2005 after upgrading .NET workframe 2.2?
  160. Record Counter
  161. simple select query takes a very long time
  162. Query completes on one box but not another
  163. First value
  164. Alter Column Set Default
  165. Running a SP in background (Asynchro)
  166. [Table Partitioning] What is the best method?
  167. newbie stored procedure question
  168. dynamic use of stored procedure resultset
  169. Inserting with DTS in IDENTITY table
  170. Group by, creating a headache
  171. Datum Variable
  172. check time range in store procedure.
  173. Checking last user Identity on remote server
  174. Merge Replication error - The merge process could not retrieve column information
  175. Help Fix Slow Query.
  176. Backup Transaction Logs Using T-SQL
  177. Stored procedure and a DB with collate that is CI...
  178. Foreign key constraints and indexes
  179. Restore backup file
  180. Unable to connect to mssql server using sql express
  181. Protocol Error in TDS Stream
  182. SQL Optimisation
  183. Publisher cannot be droped becaused Remote Distributor down
  184. Point in time recovery
  185. Table Join between Excel Sheet and MS-SQL
  186. How to create Database link in MsSqlServer to Oracle8i
  187. SQL 2005 Install Questions - CD has different options then DVD
  188. Empty trans log in Simple model
  189. Text datatype incompatible with itself?
  190. MSMerge_genhistory and MSMerge_replinfo (comparing int with concatenated VarBinary)
  191. case sensitive sql server
  192. Group By Clause Limitation
  193. Creating a database
  194. Insert statement for datetime column fails
  195. How to refer a column when the referencing column is an identity column
  196. Min not working
  197. Changing the default location of a new database
  198. Isolate SQL on it's own machine
  199. SQL Server Authentication vs Windows Authentication
  200. How to run a database report?
  201. Convert month into its number equivalent...(Ex. JAN=1,FEB=2...)
  202. Connectivity Issue
  203. setting up SQL-mail in winXP
  204. Taxing query - T-SQL
  205. SQL Server SQLMAINT and disk space
  206. Interaction with VB/VBA
  207. slow query response from a linked server
  208. fast, consistent way to bulk insert?
  209. How to set up a regular job which will put the quesry result into file and email it?
  210. Primary Key Violation Error in SQL 2005
  211. Oracle on 64 bit SQL Server 2005
  212. Primary Key
  213. Query table for cheapest items (but a little more complicated than that)
  214. Do pass thru query connections persist?
  215. Completely Script SQL 2005 Database
  216. INSERT from different tables and values
  217. system management administration
  218. one column DISTINCT on 2 Tables
  219. REPLACE name if code like
  220. parameters for query
  221. Unexpected Error from External Database Driver (MS Access Linked Table)
  222. dbcc shrinkfile
  223. create each site is one partition (was "Appreciate your help on this")
  224. MSDTC Error - Urgent
  225. Editing SSIS packages
  226. SQL Server start up account
  227. How to copy the value of one field into another using SQL Server 2000
  228. Some PRINTs won't print anything
  229. SQL Backup failure
  230. UNIQUE but not PRIMARY
  231. using variables to select column names
  232. date as PK
  233. Script sa account
  234. Search Parameter by Date
  235. Bulk Insert
  236. SQL Server Database Publishing Wizard
  237. Where is the identity property stored?
  238. Db refresh - Need input on strategy
  239. Find expiration date for Evaluation Edition
  240. Tricking db apps
  241. replication related questions
  242. Transfer Log File
  243. Upgrade from SP3 to SP4
  244. many DELETE as fast as possible
  245. Trouble with SQL Mail notifications
  246. Giving user permissions tp columns
  247. reports
  248. MSDE Doubt about remote connections
  249. SQL function in Select
  250. Measuring consecutive years