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. Unable to import text file into existing table using DTS Wizard.
  2. parent child record in query
  3. Cursor Variable problems.
  4. select between 2 tables
  5. Run dts or job from as400
  6. Cluster SP3a upgrade
  7. SQL Mail
  8. CREATE FUNCTION Error
  9. select all columns, distinct on one column (was "Simple query problem")
  10. update query where statement.
  11. DTS pour into Excel
  12. Dynamic filtering for a view
  13. Help with this Query!
  14. Is @@Error useless when using ADO?
  15. Update Query.
  16. Linking from MSSQL to Pervasive
  17. Can OBJECTPROPERTY and INDEXPROPERTY be used across databases?
  18. How to capture USER ?
  19. Heterogeneous query prob - ansi nulls & warnings
  20. Record not found after few minute of commit
  21. SWITCH in MSAccess -> ? in SQL SERVER
  22. Displaying decimals in a view
  23. life of varibales in stored procs
  24. Running DBCC Commands On Different Servers
  25. Upgraded to Office 2003
  26. Memory Usage and CPU Usage
  27. Please help with Schema question?
  28. Scheduled DTS
  29. date conversion 103
  30. Stored Procedures Encryption
  31. SQL Server 2000 - Insert/Update Trigger disappears on first run
  32. Custom ORDER BY clause HELP!!!
  33. Data Pump Error : Query cannot be updated ....
  34. Exception_Access_Violation
  35. SQL Querie (INNER JOIN X 3)
  36. Identity column exists for table - how to know?
  37. Compareing diffrent date formats
  38. Name of Primary Key columns on a table
  39. Dbcc
  40. Problems with Binary values
  41. SQL Server Dveloper managing MSDE
  42. Newbie Question
  43. Differences in update query structure.
  44. Updating records in a one-to-many relationship
  45. Can't Link to an Internal Server
  46. sql server on pdc
  47. Strange Performance Issue
  48. Stored Procedure shoud start Excel...
  49. Graphical interface for views
  50. Crying With my view Converted From Access query
  51. IBM pSeries 650 & MS SQL Server
  52. Joining two tables to find unmatches
  53. Trouble! Please help me!!
  54. Question about SQL linking
  55. EXEC a sp inside a SELECT statement?
  56. help with WHERE clause
  57. Duplicate Record SQL Check problem
  58. dbo question
  59. Linked Server
  60. Log Shipping
  61. Log Shipping Question 2
  62. Log Shipping on MSSQL Dev
  63. Case sensitiveness for local variables
  64. To delete data in many table
  65. Access Query To View How Can I handle?
  66. Problems with week numbers
  67. Language settings in Reporting Services
  68. Contacts.mdf for MCAD/MCSD
  69. problem with sqlmangr
  70. Clustered Unattended install
  71. Does the linked server exist?
  72. next value in identity column
  73. Date Formatting Problem
  74. restore a new database in sql server
  75. auto return of primary key of row just entered
  76. 30 mins report
  77. Performance Issues
  78. like parameter pass to stored proc
  79. Start with
  80. App hangs
  81. Escaping Quotes
  82. message boards and google crawls
  83. Porting a Merge database from one server to another.
  84. Is thier anyway to turn off replication on a singluar database
  85. SequelLink 5.4 Problem for window 2003 server
  86. How to append,copy,trim,compare LOBs(Large Objects) in SQL Server
  87. server clogs with 100% processor usage
  88. sp_grantdbaccess Win2003 SQL 2000
  89. ODBC Error after restore db to new server
  90. run the stored procedure the second time
  91. rev 2 over rev 1
  92. Replacement for the OFFSET command?
  93. unreadable data from access with sql server back end (was "need help")
  94. Equivalent bfilename function in SQL Server?
  95. select Characters between...
  96. Transfer data from Excel to SQL server
  97. Connect SQL server to VB
  98. DTS package fails: [DBNETLIB].....
  99. Log Shipping
  100. Connect to a named instance.
  101. colum names in all tables
  102. The fastest insert option.
  103. show the difference between two date columns (was "query help please.")
  104. Monitoring an ODBC connection
  105. Storing Variable Length Text
  106. sp in ReportingServices only displays last row
  107. MMC Crashing when setting destination fields in DTS
  108. Invalid Object name
  109. Assistance with measuring query performance
  110. block size
  111. enable IDENTITY INSERT
  112. BCP and BULK INSERT
  113. DTS error: 2147217891
  114. trouble moving ms sql server
  115. Sql Mail over SMTP - xp_sendmail replacement
  116. Updlock
  117. Connecting Speed
  118. User Defined Function help!
  119. DBCC DBREINDEX problem: A column has been specified more than once ...
  120. 2 linked servers 1 works but not the other
  121. Single table not reponding
  122. Warning: The join order has been enforced because a local join hint is used.
  123. Restoring Database Error
  124. delete a user in all databases (was "Script help!")
  125. RESTORE from BACKUP file name change daily
  126. handling binary data in sql script template
  127. Restoring a database to recover history of changes.
  128. How to auto increment primary key
  129. dealing with concurrency using web form insert
  130. packagefromtheweb error
  131. Why does @@Error is still zero when a exception occurs?
  132. Trigger Help
  133. Update Query... whats wrong?
  134. SA Login problem in SQL Server 2005
  135. Date format
  136. How to do a replication plan??
  137. error detected by database dll(VB.6 Crys.8)
  138. invalid descriptor index in Crystal Rpt
  139. CASE or what?
  140. Populate Datagrid control from SQL Server
  141. MSSQL2K cursor using dbcc dbreindex
  142. Trigger for Insert
  143. LEFT Outer Joins
  144. sp_attach_db error !!!
  145. How to convert date to JULIAN?
  146. Store and query actual XML data?
  147. adding value to datetime caused overflow
  148. Guest Account
  149. Guest Account
  150. Recursive Query for a Tree
  151. Performance Issue ~
  152. join problem
  153. Trigger question
  154. Trying to update several rows in two tables
  155. to copy db
  156. Restrict access for sysadmin role
  157. Question about OR keyword.
  158. remove foreign key constraint before drop
  159. Microsoft Access VS Microsoft SQL Server
  160. Assigning TEXT datatype column values to variable
  161. Isolation level in SQL Server
  162. Possible to have a "live" connection from SQL 2000 DB to Informix DB??
  163. charindex and substring
  164. SQL Server Cheat Sheet?
  165. SQLServer 6.5 command to sends email
  166. Sqlxml
  167. Runing Trace in SQL 2000 server
  168. Error has occurred in the script on this page???
  169. Fastest way to return the newly inserted identity value?
  170. Log Shipping
  171. Linked Server SQL2000 DB2
  172. Handle tables with millions of records
  173. Stored Procedure With 'Like' Statement
  174. System/User Table Type
  175. 2 Way vs 4 Way
  176. How to find Size of all user tables with the number of rows
  177. First Day of a month
  178. Max?
  179. Reporting Services / Report Writing Question
  180. multiple languages database-problem
  181. Trying to "correctly" use sp_addextendedproperty .... and failing miserably
  182. How to change data source in Pivot Table?
  183. find phys location of a db
  184. Importing from Access without using wizards
  185. truncating transaction Log
  186. Lock Tables
  187. Error Installing SP4 in 64 bit
  188. converting to datatime datatype
  189. performance problem with SQL Server?
  190. Need help with remote sql server connect string
  191. which is better trigger or stored procedure
  192. Regarding Indexes
  193. denormalization
  194. ORDER BY a boolean result (was "A simple one?")
  195. attach and detach a database
  196. How to truncate log file
  197. growing tempdb
  198. Can't get SQL Server to listen on TCP Port
  199. nth highest salary, employees paid more than manager (was "I need some SQL Queries")
  200. Design question to avoid subqueries
  201. Error when using ole db provider...
  202. dbms_utility.get_time equivalent in sql server
  203. DTS after MSDB restore
  204. show empname and number of duplicate entries (was "query needed")
  205. Remotly accessing MSDE database
  206. How to pass a parameter in xp_sendmail?
  207. Linked Servers
  208. Interesting Action Query With No Relationship
  209. URL for interview question
  210. NETWORKIO - wait type
  211. Install SQL2K on win2k server
  212. find child rows with no parent (was "query need")
  213. Maximizer SQL Problems
  214. SQL Server not using all avail MEM
  215. Transaction Logging
  216. Help With Modifying A View
  217. Cursor Variable problems.
  218. MS access problem, jet database engine cannot open....
  219. description to SQL error codes
  220. How can I flush data between different merged databases.
  221. best way to grant access to a standby DB
  222. Migrating from Access 2000
  223. Restore via SEM vs via Query Analyzer
  224. How do you modify security mode of subscriber?
  225. difference between SP and function
  226. Primary Sorting Options in MDX Query
  227. Locked record
  228. Suppress duplicated rows
  229. MS SQL 2000 vs. Pervasive SQL: Which is better ?
  230. Backup over network
  231. SQL Collation
  232. how to reduce Locks on tables
  233. Login failed for user '(null)'. Not associated with a trusted SQL Server Connection
  234. Date Range query.....
  235. sp_ - Performance
  236. Event type: Language Event
  237. Can't Connect With Real IP
  238. SQL Server Data File Dates do not change
  239. Query reponse time & index ?
  240. Create/ Alter database fails?
  241. multiple query --- output to text file--
  242. Por que no puedo instalar sql server 2000 en XP
  243. Selecting 2 columns but only one must be distinct
  244. Procedure not seems to work as supposed to b
  245. slow query - an ideas?
  246. Date of first day of week for current week
  247. ADP - no centralized coding possible ?
  248. Urgent, DTS How to Monitor a DTS package Which exports data to four Excel Files
  249. Fragmentation Triggers
  250. Regarding SQLXml