PDA

View Full Version : 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
  1. Contains Predicate and Double Quotes
  2. upgrade from SQL 7.0 to 2000
  3. Query Analyzer Script
  4. PEAR DB 1.6.0 has been released
  5. create linefeed in field
  6. 'Syntax error converting datetime from character string' with sp_executesql
  7. Calling parameterised views from VB
  8. text with ' character
  9. Profiler Performance trace template
  10. Problem with Stored Procedure
  11. computers that connected via dial-up modems
  12. retrieving the the max occurrence of a record
  13. sql connection fail
  14. Script to generate INSERT statements on table
  15. Complex Sql Query
  16. Mail Client...SQL Server and another app. on same machine?
  17. Script to copy entire table
  18. Indexing - Uniqueness vs Highly uplicate
  19. How can the Profiler textdata field be enlarged?
  20. Text file import with DTS
  21. Variable Parameters - which approach.
  22. Duplicate a row in SP code
  23. virtuelle Cubes
  24. FTP Question
  25. Difference between windows locale in remote settings and SQL server
  26. Dynamic field question
  27. ANSI_NULLS and null comparison
  28. Formatting @query results using xp_sendmail
  29. Passing an Array and/or Variable Field Name to an SProc
  30. Transfering tables from one dB to another.
  31. sp_spaceused
  32. sp_spaceused
  33. sp_addextendedproperty versus sysproperties
  34. SQL Join Problem
  35. In(..) and Like xxxx% performance
  36. indentify full-text indexed rows
  37. How to query two MS SQL DB's on the same server inside a Stored Procedure
  38. Please Help a mySQL newbie!
  39. Records appearing and then disappearing
  40. Inconsistent DTS Error - Help please
  41. Unicode ..
  42. Brick Codes
  43. Enterprise Manager free clone
  44. How do I find the max row size..?
  45. Problem with Provider=SQLXMLOLEDB.3.0
  46. encryption of sql database
  47. Advice needed: Combining multiple Access db's in to 1 SQL db
  48. Copying deleted into temp table in trigger
  49. Help with Recursive Function
  50. Dumb Stored Procedure Question
  51. SP3a + Extended Procedures = not nice (help!)
  52. Create a new User
  53. Farsi Collation
  54. Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
  55. Win2000 OS Access for SQL Server Admin
  56. SQL Server Books Online January 2004 Update
  57. duplicate database
  58. SCHEMA -- 1000 products with different attributes
  59. Help! I can't write this SQL Server query ... can you?
  60. Timeout on running views in Enterprise manager
  61. Embed SQL statement in another SQL statement
  62. Error handling in MSSQL - if error during call remote stored prcedure I need SQL code to continue...
  63. Benchmarking a server
  64. Using Mysysobjects table in Sql Server
  65. remote transaction on SQL Server
  66. PHP with SQL Server
  67. Access <- > SQL Server
  68. SQL 2000 - Row Level Locking
  69. Help needed in Crystal reports
  70. Is it posiable to close the screen
  71. SQL Query - Please Help!!
  72. Usage of e.g. Max(Date) aggregat function
  73. New SQL Server tool
  74. New SQL Server tool
  75. New SQL Server tool
  76. Storing and viewing UTF-8 characters...
  77. March 15 panel discussion (Cattell, Coffee, Florescu, Gray, Kleewein, Melton)-- free admission
  78. Senior Microsoft .NET Programmer/Analyst needed
  79. It works
  80. Large table schema changes
  81. Recursive Query Quesiton - Table Function
  82. Importing into Test Database
  83. Move DTS package to another server
  84. Set Approach instead of Cursor
  85. Test Database Copy
  86. Error returned with no error message
  87. using multiprotocol net library in the system DSN
  88. EMPTYFILE
  89. Tempdb full.
  90. Schreibkonflikt
  91. Re: Schreibkonflikt
  92. insert time
  93. Pass record source parameters from an Access form to an Execute SP?
  94. Searching on text value
  95. Stored Procedure, Fetch, very long
  96. Long running backups
  97. MySQL between times
  98. Parse Data from a String Field in a SQL Query
  99. Merge Replication error: The schema script '....sch' could not be propagated to the subscriber
  100. SQL Server How to Prevent Locking To Do Read-Only Reports
  101. Quastion about Temp Tables
  102. Copy tables between databases using variables
  103. Newbie XML question
  104. bcp_exec() Failed
  105. Profiler's TextData column has 'NULL' and longest Durations
  106. Grouping Records & Assigning Sequential Number
  107. Null Foreign Key
  108. DBA - Oracle, Sybase, Sql Server, Informix, DB2 Jobs @ www.cvpages.com
  109. Load Balancing
  110. HELP! - can't send mail
  111. Resource Accumulation on SQLServer
  112. name value pair design
  113. select question
  114. Installing SQL
  115. ER diagram
  116. Coping Databases
  117. sql replication
  118. newbie
  119. best way to store simple up or down values
  120. Compact Database
  121. Connecting to a linked server with ODBC
  122. Help! What is the risk for data on insufficient hardware?
  123. Nonprintable / encrypted characters is not found
  124. Recursively update data on a row
  125. Can I tell how often the clustered index pages are spliting?
  126. Disecting date into segments
  127. Column Comparison
  128. Groups and Permissions question
  129. Want 1 to many relationship when child table has no primary key
  130. Why are scalar functions soooo sloooow?
  131. Update SQL Server from Access
  132. ODBC and SQLServer : does I need the client installed on ?
  133. Mysterious Access Denied Error
  134. Backups
  135. SQL Server Agent notifications to multiple (three-plus) addresses fail
  136. DELETE query syntax using subqueries
  137. Query runs OK in QueryAnalyzer, but fails in batch
  138. Memory usage - max setting
  139. Slow select on sql 2000 with like '%value'
  140. Newbie on Triggers
  141. Date only fields in SQL Server
  142. Advice Needed : Nasty Problem PHP/MS SQL Server and Varchar fields > 255 in Length
  143. How to write portable database access code?
  144. Finding Duplicates
  145. sp_help can't see my tables
  146. Triggers Question
  147. how to access ms-sqlserver from a Linux based computer
  148. DWH problem: updating a table with every 1000 records a checkpoint
  149. Repost: 00000 display on upgrade to Windows XP
  150. Re: SQL Server Ports - Net-Library Encryption
  151. spread query
  152. setting and restoring multiple connection options
  153. Pricing of a SQL Server clustering solution
  154. Create sequential numbers in a column
  155. Bulk inserting into table with computed columns
  156. mssql server to access script
  157. need help on sql/asp
  158. SQL Server Ports - Net-Library Encryption
  159. For the SQL Gurus out there, a question
  160. Help needed with select query!!!
  161. Help writing a query.
  162. Simple Update Error
  163. Delete rows from table
  164. ASP/SQL Query Build - Myth Breaking
  165. SQL Server 2000 capabilities
  166. insert into table-Primary key error
  167. reformatting DATE
  168. selecting first row from GROUP BY
  169. Maintaining partitioned views
  170. many DISTINCT queries
  171. Free toll like Enterprise Manager
  172. Know the "country version" of SQL Server
  173. Alter table and column order
  174. First attempt at Stored Procedure - can anyone offer advice
  175. Audit Drop table
  176. write text files in transac sql
  177. parameters in sql server 2000
  178. Using host_name(): Crossing my fingers...
  179. wrong query results in SQL Server 2000 from VB.NET
  180. Database permission error
  181. XML "Undeclared Tag ID" Error
  182. SQL procedure parameters
  183. Monitoring
  184. Error concatenating string
  185. T-Sql - Calculate Each Monday for a given time period. Help??!!
  186. Timeouts - Disk Queues
  187. Timeout problem with large update query from VB.Net to SQL Server 2000
  188. View behaviour in join
  189. Tables in Muliple Servers
  190. Job Failure
  191. Help with a SP
  192. Output from Extended Stored Procedure
  193. Scheduled DTS package fails
  194. Send/Receive text file using to some server using FTP
  195. problem with duplicate keys
  196. Opinions about Insertion Technique
  197. Have all your cross platform databases on one application
  198. Converting Oracle SQL to TSQL
  199. Possible to lock a row within a stored procedure in SQL Server 2000?
  200. Extract lower case characters
  201. Outer Joins
  202. converting a query with *= into SQL 92
  203. Updating changed row via trigger in SQL Server 2000?
  204. performing a whitespace-insensitive query
  205. msdb database problem with MS SQL Server 6.5
  206. Trigger and Row Update Help
  207. How to connect to a remote database ?
  208. Union All - Index is not used
  209. passing column name as parameter to a stored procedure
  210. Dynamic SQL Question
  211. Benchmarking database
  212. simple distinct query
  213. Difference between 2 stored procedures
  214. UPDATE CURSOR - declaring and use.
  215. Design Question: Calculated Field
  216. DETERMINING WHICH HIERARCHY OF A DIMENSION IS SELECTED
  217. Help needed in sp_pkeys
  218. sql-server 2000 limit rows
  219. How to Migrate DTS packages between servers
  220. Export Access table into MS SQL server preserving Unicode characters?
  221. MS SQL 2000 TCPIP Port Number and SQL Replication
  222. help with query
  223. Time between the busy_end_time and the next busy_start_time
  224. ADP Problem
  225. Slow query
  226. Error while connection
  227. toad and oracle vs. mssql and ?X?
  228. MSDE 1.0 (MSSQL 7) and Win98 / Win98SE...
  229. Northwind and pubs default login/password ?
  230. Access hangs after opening connected project
  231. Scheduled backup silently fails
  232. UNION ALL query - HELP!
  233. Bound parameters failure (SQLBindParameter) using ODBC
  234. Calling Stored Procedures
  235. Rounding and Grouping
  236. Strange Behavior with 2757: There was a problem... error
  237. problem with database connectivity
  238. Changing Data in SQL
  239. CPU usage comparison for MS SQL Server 2000
  240. SQL query
  241. attaching a database without a log file
  242. Performance problem, lots of disk activity, running out of memory
  243. Valid T-SQL syntax?
  244. SQL 6.5 to SQL 2000 performance question
  245. using mssqlserver with win xp
  246. weird error when precompiling genwin.mak with nsqlprep
  247. Cursed Error Messages
  248. Locking Users Out of Table
  249. Outer Join syntax
  250. SQL Question