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 56
  1. How to do this self-join??
  2. How to do this self-join??
  3. Newbie to sqlserver
  4. SQL Server 2000 Exam #70-229: Good book?
  5. Mysterious mystery -- 2002-11-08/2002-11-09
  6. Triggers on Delete and on Insert & SQL Server 2000
  7. table mantenance within a replicated database
  8. Altering linked tables
  9. Internet Queries
  10. Connection failed between PC
  11. Book Recommendations Needed
  12. SQL Profiler on a Prod System...is it safe?
  13. Sort Order and case sensitivity
  14. Internal memory increased; SQL Server does not use this
  15. event id: 998 - Unable_To_Set_RegKey_Val
  16. Outputting Data From Stored Procedure
  17. mysql immediate assistance needed please.
  18. Restoring DB
  19. SQL Help, Urgent
  20. Problem with multiple joins.
  21. View Users Connected to SLQ Server?
  22. Server side Cursor
  23. Problem with trigger and DTS
  24. Column Name in a Primary key constraint
  25. Using Openquery Without Returning Resultset
  26. Converting SQL Loader control files to BCP format files
  27. Problem with FETCH LAST
  28. How do I use constants in stored procedures?
  29. Timestamp
  30. "Tree View" with a SQL Server Database
  31. SQL Server 2000 concept
  32. Curious performance issue when running a query
  33. Incorrect host-column number found in BCP format-file
  34. Stored procedure won't use index
  35. Restore a remote backup
  36. Help! Index corrupting? DBCC CheckTable failing?
  37. ISQL and OSQL Output Lines Wrapped Around at 256 Characters?
  38. Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?
  39. Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?
  40. Unique Field conflict in Views
  41. Last modified date of a view
  42. Performing Completion Actions, cursor_close_on_commit setting
  43. "Org Chart" Type Tool?
  44. Dynamic SQL
  45. Opinions on ListCleaner ( WinPure ) ??
  46. Newbie Question
  47. QA returns different records from SQL Server EM
  48. Problem with import data from excel format file.
  49. Using xp_cmdshell in a trigger
  50. GUI for Sql 2000
  51. Store procedure help
  52. decimal places
  53. Getting Number of Logged On Users to Server
  54. can't open 'databases' folder
  55. Strange happenings with SA account
  56. Query by year group by total students sort by total for each county
  57. About SQL 6.5 replication to SQL 2000. (Distribution database)
  58. SQL 7 migration
  59. Help with COUNT in SELECT Statement
  60. Intellectual Property question
  61. creating temporary table with SELECT INTO
  62. bcp select querylist error
  63. ANOTHER NEWBIE QUESTION
  64. Autonumber
  65. What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?
  66. Remote View Question
  67. Can FK be nullable/optional by design?
  68. sequence
  69. temporary tables...
  70. Making a stored procedure run on it's own periodically.
  71. Expanding Hierachy with multiple parents
  72. statement level vs. row level triggers
  73. How to set rights in E.Manager Since it is a open book..
  74. System tables
  75. Access to SQL2000
  76. ms-sql server "light"
  77. Sql Stored Procedures
  78. Query to linked server:Oracle; problems with ANSI_NULLS;ANSI_WARNINGS
  79. Clustered index not working
  80. Trigger on table-valued function?
  81. Changing Datatype length
  82. Server Name in Registry
  83. SQL 2000 System Db's
  84. Need tools to Convert Access to SQL environment
  85. Update a table by copying a column from another table
  86. Reading data from Excel...
  87. DBCC Page
  88. Help for stored procedure and Null...
  89. Suggestions for a small database layout...Very simple
  90. General Design Question
  91. Unicode conversion issue.
  92. Full Text Catalog Population
  93. importing cyrillic encoded data
  94. Help desk systems..
  95. DBDesign Q2:
  96. Help needed in Replication
  97. Perl DBD/DBI for SQL Server
  98. cannot connect to SQL Server from VB.NET
  99. audit/history without use of triggers?
  100. Rights
  101. Or in left outer join.
  102. SQLGetData returns all NULL data, but query analyzer returns correct values from aggregate queries
  103. Simple GROUP BY Question
  104. sysprocesses
  105. Is it possiable to restore a DB ...
  106. Index and Data Pages
  107. Weird Backup DB Problems in SQL Server 7
  108. dynamically creating temp table names
  109. Order of tables in joins
  110. isql -- executing multiple input scripts
  111. B.C. vs A.D. datetime in SQL Server
  112. Getting rid of duplicates
  113. long transaction
  114. Import Puzzle
  115. somewhat painful join code
  116. SQL Server 2000 Replication Query
  117. SQL script to remove constraints
  118. Gettting time of SQL Server Computer
  119. "Lost Inserts"
  120. Weird date rounding
  121. File group space error
  122. First day of month of 3 months ago
  123. RANT: SQL Server Internal Error
  124. Help with Cluster
  125. SQL Server login Form For access
  126. identify what tables are being access in SQL
  127. attach db file copied previously
  128. select without duplicates
  129. test - please ignore
  130. Creating a stored procedure
  131. MS SQL server Insert Error [109]
  132. Transation log size
  133. DDL Best Practices question
  134. Ex post shrinking file sizes
  135. INSERT INTO... SELECT... Cannot insert duplicate key...
  136. Looking for help with a stored procedure!
  137. Automated testing | How to "force" GETDATE() function to return specific value?
  138. MS-SQL-Server 2000 Problem
  139. MS-SQL-Server 2000
  140. Creating a Unique Index
  141. Newbie Help With Query Please
  142. Script to store stored procedures in seperate files
  143. newbie to SQL Server
  144. DBDesign Q
  145. MSDE Connection Error
  146. SQL - a menu system - plz help
  147. Want expert opinion on a way of storing 'relations'
  148. temp tables, global and local
  149. Inner Join experts out there??
  150. trouble using the CONTAINS() function in sql server
  151. Update query with sub-queries to find the values
  152. Help with search results query
  153. Migrating from Excel to sql-server
  154. Chinese chars through stored procedures...
  155. Active Directory Implementation
  156. Help With Stored Proceedure Please
  157. How to avoid Reference problems
  158. Working Linked Servers
  159. Solution need in Replication
  160. How to store .wav or .mp3 file in SQL Server 2000
  161. increase Ram?
  162. Dynamic create table, create index based upon a given database
  163. altering data
  164. retrieving long texts from msqql
  165. TImeStamp or not
  166. Script out objects
  167. Query help
  168. Adding Calculated Fields
  169. Why isn't this variable updating?
  170. copying a table from one database to another "last" doesn't appear the same
  171. SQL Full-Text Search in VB code
  172. Query Analyzer - not printing output
  173. MYSQL rebrands SAP DB as MAXDB - $1.5K per CPU
  174. connecting jdbc type 4 with ms sql server.
  175. What shrinks when shrinking
  176. View or Stored Proceedure?
  177. SQl debugger ! how
  178. Important !!!!!
  179. pivoting query on t-sql
  180. Substring'ing a Number-field
  181. SQL Server replication with existing data on one server
  182. BULK INSERT FROM UTF-8 FILE
  183. Query Time Outs
  184. Query Help....
  185. Help with Select - into
  186. Connection Problems
  187. Purging records from subscriber/publisher database in merge replication
  188. Information on Installing 'QMF' In SQL Server on Win2000?
  189. Help with a stored procedure/query?
  190. Pros/Cons of using Win 2003 over Win 2000 for SQL Server Enterprise ?
  191. How to know what schema was modified
  192. >= in Case Statement - Stuck
  193. Database Alias
  194. TEXT data type column: Replacing chars : why isn't this routine working?
  195. Error while Creating table using Select Command
  196. HELP PLEASE: SQL Query Analyzer does not start
  197. Query optimization question...
  198. Parellism not working
  199. replicate error
  200. Date Comparison Issue
  201. Extra internal memory can't be seen ????
  202. acess I/O File
  203. SQL Reports.
  204. SQL 2000 Database files become read-only after reboot
  205. SQL 2000 Database files become read-only after reboot
  206. READ_UNCOMMITTED problem with SQL 2000 and i-net Opta 2000 JDBC
  207. ANN: SQL Converter (Oracle -> MS SQLServer)
  208. How to get values from queries, and then using in another query?
  209. good SQL book?
  210. Select where not exists
  211. Profiler TextData truncation
  212. Help with UPDATE
  213. To find any text in all Stored Procedures
  214. Error executing xp_cmdshell from within a SQL task in a DTS package...
  215. перестраиваются ли индексы
  216. Loading backed-up user database in SQL Server 2k
  217. SQL 2000 backup on DLT tape
  218. Is it possible to return last row out of multiple based on row index?
  219. Clearness needed in Sp_attach_db
  220. Running SQL 7.0+SP4 on XP Pro...
  221. Best way to import ASCII tab delimited file every week (5,000 records)...
  222. 'joining' results of 2 queries
  223. OSQL Output File Garbage
  224. Remote Backup?
  225. how to determine what locking behavior the query optimizer chooses?
  226. Large Scale Storage Planning
  227. Creating Deciles
  228. Migrating from Access to SQL Server with a web front end
  229. Improve performance in Query..
  230. Script line number
  231. Help using sp_xml_preparedocument
  232. Corrupt Stored Procedure?
  233. Processing the TEXT datatype with TSQL
  234. Is it possiable conversion
  235. SQL7 to SQL2000 Migration
  236. Problem SQL7.0 Server (MSDE) - ACCESS MDB
  237. READ EXCEL DATA CELL BY CELL FROM SP
  238. View with a query to an oracle database
  239. cross tab query
  240. Create trigger not firing via ODBC
  241. file name or extension is too long
  242. Corrupted log file
  243. shrink file tool from EM took all the empty space allocated to data file
  244. ADP revision numbers
  245. Worker Threads
  246. CA-AB-Calgary - Datastage / Metastage consultant needed - contract - 6 weeks
  247. Change logfile location durring setup SQL 2000
  248. bcp unicode files using format files
  249. bcp unicode data using format file problem
  250. SQL Server 2000 Trusted connection