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. error in recordsource after converting to sql server 2000
  2. local system privildges
  3. Pre-installed databases?
  4. Help for best logic
  5. Sr. SQL DBA job open in Texas
  6. Updating statistics
  7. Enterprise manager
  8. use of variables - why doesnt htis work
  9. Problems with 'sp_helpdb' stored procedure
  10. Looking for good free jdbc driver for sql server
  11. What is faster? C++ vector sort or sort in database
  12. Access Front End and SQL Server 2000 Record Level Access Control
  13. Replication
  14. Executing a reboot command from SQL
  15. Upgrade to Sql 2000 with minimal downtime
  16. SQL Trigger for trimming String fields
  17. Help for Trigger
  18. Help: Purge Table Stored Procedure
  19. error with linked server
  20. SQL query fails
  21. SQL server reboots my windows 2000 machine
  22. Creating database and table on MS MSQL server
  23. [QUERY] Help...
  24. SQL daily
  25. Replace function and regular expressions
  26. SQL Server Max Record, multiple table join problems
  27. License Requirements for MS-SQL 2000
  28. Invalid Udate SQL statement DOES NOT cause error... Does anyone know why??
  29. No of rows conflict in a table
  30. Finding out what a user did - help needed
  31. Help with Many-to-Many-to-Many Problem
  32. select * from a where (field1fromA, field2fromA) in (1,1)
  33. migrating rows between diferents schemas
  34. MSDE & database moving.
  35. SQL server image data
  36. Sql Scripts to Monitor another SQL Database.
  37. How can I query a trusted domain (from MS SQL)?
  38. transaction id mismatch
  39. Transferring from SQL 6.5 to SQL 2000
  40. trigger
  41. How to Parse Sentences into Words
  42. tools for cleaning name and address data?
  43. Median query with Group by clause
  44. Re: Table Information
  45. warning re ADO .UpdateBatch method
  46. RAM
  47. security with web-based access
  48. Primary and linking keys on SQL server tables
  49. View Problem
  50. Unallocated Space anomaly
  51. probably an easy one - 2 agregate functions
  52. [Q] complex output result again: the end of script was cutoff in the previous posting
  53. [Q] complex output result
  54. SQL Query- confused with nesting...
  55. Moving a SQL Server 2000 database that is in Standby Mode
  56. How can I show decimals after division update
  57. Help in SQL Query - easy
  58. Help in SQL query
  59. Max () query problem
  60. BACKUP TABLE(historical)
  61. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  62. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  63. Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
  64. Make a copy of parts of a ROW, but with a new Key.
  65. Member Property
  66. Image file, SQL Server, and web.
  67. It is not a real index but exists as statistics only
  68. EXEC Inside a cursor iteration problem
  69. domain user or local system account ?
  70. Alter Table - Change Column Datatype
  71. Creating Tables and automatically inserting data-HELP!!
  72. Output parameter from Sproc
  73. XACT_E_REPLAYREQUEST
  74. Calculated values and database design.
  75. huge logfile problem
  76. Retrieving Result Set from Dynamically called Stored Procedure or function in a Function
  77. sysindexes???
  78. How do I set values to DBPROP_DATASOURCEINFO (from SQL)
  79. Job Failed
  80. How do I store objectGuid (binary from AD) into SQL table?
  81. Change Collation Sequence
  82. DTS permissions and ownership
  83. Select and Update of records without being used by other users?
  84. Repeatable error, with script, with code
  85. MSDE Install Problem
  86. SQL Query Quandry
  87. a piece of theory
  88. Paging Advice Needed
  89. T-SQL ASP While not rs.EOF
  90. Locking Info
  91. who i am in MSSQL
  92. Generate SPs as text
  93. Syntax error converting the varchar value '10.136.20.20' to a column of data type int.
  94. Re: Behind the Curtain: Upgrade from 2000 Personal to 2000 Standard
  95. Search contents of stored procedures?
  96. SQL + everyday
  97. Connection Problems to SQL 6.5
  98. SQL Query Analyzer - Trace Tab
  99. Incorrect columns returned by view
  100. How to convert int to decimal
  101. SQL Server 2000 Newbie
  102. Cursor and row retrieval question
  103. Can anyone give me a query for this ?
  104. Any Column Updated / Inserted Trigger
  105. Stored Procedure Question
  106. Guid as primary key
  107. DTSrun in Stored Procedure
  108. Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?
  109. Using a trigger on a view
  110. Clarification about newid() function
  111. Storing Dynamic Table or View information
  112. Update Time Question
  113. update field with max from another table
  114. Data transfer from 6.5 to 2000
  115. 'Upgrade' from 2000 Standard to 2000 Development edition
  116. SQL Server text file continuous import problem
  117. Data Restore on Elm Street!
  118. Problems inserting rows using OLEDB and views
  119. Re: SQL scripts basic questions from a newbee
  120. creating Random Lists which do not have any unique records?
  121. SQL Server 7.0 installation
  122. TimeStamp
  123. Loading text files using DTS
  124. Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
  125. JOIN ON CONTAINS(Table1.Field1, Table2.Field2)
  126. Self Join Question
  127. Create Index via Stored Procedure?
  128. BCP in of hex data
  129. Software Developer earning his Doctorate needs help
  130. Insert rows from other server
  131. MS SQL vs PostgreSQL
  132. Checking obligated values in different rows
  133. Licensing
  134. Premission to create database!
  135. MSDE Question
  136. Checklist
  137. MS SQL Port
  138. Converting negative value
  139. Which SP3a for SQL 2000 Personal Edition?
  140. Direct access to records via timestamp
  141. Counting number of IO Accesses per DB
  142. DTS and Transaction
  143. Scripting data in tables
  144. 446: Impossibile risolvere il conflitto di regole di confronto per l'operazione
  145. SELECT issue
  146. Bypassing recovery for database
  147. Advice
  148. loosing Databases ??? Help
  149. Backup Text Report
  150. Howto work and manage Backup Logfiles?
  151. Changing Database within a stored procedure
  152. SQL Trigger for changed columns?
  153. SQL Server Analysis Series Cross Tab Crosstab Report
  154. SQL Server/ADO/XP problem "query cannot be executed"
  155. ID Edition? General MS SQL training?
  156. Geographically Diverse Data Deployment Doubletake, SRDF, Log Shipping
  157. Is tempdb big enough for what I'm doing, plus other questions.
  158. Weird select statement ?
  159. OLAP - Calculating Minimum Measure if NULL is present
  160. Looking for findcolumn script
  161. Can I create a 'Top n' statement within a stored procedure using a parameter?
  162. a heirarchical query
  163. UniqueIdentifier pros and cons ??
  164. Is there a macro (as in C lang) like facility in SQL server 2000.
  165. How do I do this is SQL Server? (from an Oracle background)
  166. Blocking and return parameters
  167. *** DTS Error Messages ***
  168. Matching Strings In Different Tables Of Same Database
  169. HostName Function with Access2K front end
  170. Sql server log File Full Error
  171. security question
  172. SELECT DISTINCT Problem
  173. DBCC commands stability
  174. SQL error 20029
  175. MSDE and Access 2000
  176. which file store startup parameters?
  177. Data/index locks in SQL Server
  178. DTS dilemma
  179. efficiency of query
  180. Indexing Results of Stored Proc (or new table created by one)
  181. multiple deletes with a stored procedure
  182. Database Diagram
  183. Surefire Method to Determine that SQL is running programmatically.
  184. How Do I use an ODBC database in Query Analyzer
  185. Linked Server Error Between SQL Server and Oracle
  186. alternative way
  187. Are text pages deleted when a column is converted to varchar
  188. FILE SIZE IN MODEL
  189. Basic SQL Query optimization involving freetext search
  190. Dynamic Cursor versus Forward Only Cursor gives Poor Performance
  191. Return one row
  192. SQL Statement to generate customer list whose last payment date is jan 04
  193. recording query
  194. Problem with string
  195. Does anyone know the difference in the locking behaviour between sql 2000 and sql 7?
  196. How to copy cube to Excel?
  197. SQL backup job - failed
  198. Logging on SQL Server 2000
  199. Multiple docs open in Query Analyzer
  200. IF Condition in Join??
  201. inconsistent behaviour linked server?
  202. Linked Server Query Problem
  203. App server unable to connect to SQL Server 2000 developer edition on localhost.
  204. Transaction logs
  205. Group newbie: question on parsing a field value
  206. Full-text Indexing
  207. Stumped by a BCP problem
  208. Newbie in SQL Server admin
  209. this is driving me nuts - solicit help from the gurus
  210. DTS error
  211. FULL OUTER JOIN
  212. Book suggestions for studying for MCDBA
  213. Incremental output in QA and writing to files
  214. Re: what is the impact of Database size on Performemce
  215. Can't upgrade to SP3 in Win Server 2003
  216. Load balancing and clustering
  217. Update statement performing table lock even though where condition on clustered primary index?
  218. MS SQL 2K server on windows 2K
  219. data synchronisation
  220. Auto created statistics and missing statistics
  221. trigger before delete in firebird or mssql
  222. Execution plan of UDF
  223. primary key autoincrement question.
  224. Helpdesk database statistics crosstab report
  225. SQL Statement for generating expired customer
  226. Advise on Multiple Column Updates
  227. 2 Qs
  228. ADO Recordset's object method Open
  229. "Tracking"
  230. Returning random records and NOT similar (random questions)
  231. Script, Save, Export SQL Database Diagrams
  232. Retrieving an Answer from Mulitple ResultSet statements
  233. Count of Columns <> 0
  234. Type 'adCmdStoredProc' is not declared
  235. Generate insert script
  236. Problem: must detect db changes
  237. SQL Server Agent confusion
  238. Sorry for dbl post but previous post was damaged somehow (WAS SQL Server agent weridness)
  239. SQL Server Agent
  240. Prepared Statement where value IS null or value = :x
  241. selecting x records from table n times according to variable criteria?
  242. Executing a DTS from another DTS...
  243. Using Image data type in a SQL Server 2000 table
  244. Trapping BCP error from SP
  245. newbiw SQL 2K DBA
  246. Common Table Expression?
  247. Problems using xp_smtp_sendmail
  248. Sending email from sql server
  249. About Store Produre
  250. Marrying SQL, XML, web services, grid computing (2 audio programs)