View Full Version : SQL Server



  1. Doing a SELECT INTO using a Stored Proc as the data source
  2. [ANN] DataServices World (June 24, New York City) early bird registration expires 9 May
  3. Setting SQL Server Agent Account without being part of a domain
  4. SQL Statement Problem : Separate long varchar into word seqments 35chars long
  5. Limiting table access using stored procedure.
  6. optimal selection of all records for a certain month (illegal datesOK?)
  7. SQL Select All Items where one meets the criteria
  8. updating multiple columns with subselect
  9. sql/msde replication
  10. Selecting several types
  11. Prevent Excel and Access access to SQL 2000
  12. Stylus Studio 2008 Release 2: New EDI support & code generation
  13. Read HTML File though Network for Email.
  14. Disable and Rebuild or Drop and recreate Index
  15. How to implement Audit/Alert for Row level access?
  16. Force protocol encryption on hosted database
  17. Help with bbrowser cell focus ?
  18. Orphaned tupels, should I clean or is it ok to leave?
  19. ASP.NET 2.0 not connecting to SQL Server (not web.config)
  20. SQL and Database Design newsgroup
  21. Client applications
  22. Full text indexing scheduler SQL Options
  23. Problems With SQL Agent in SQL 7
  24. beginners question...
  25. Can you tell who last edited a SProc, and when?
  26. COLUMNS_UPDATED() with triggers
  27. Select date in british format
  28. Conditional data copy SQL Server to Oracle
  29. Why freetext query become very slow all of a sudden
  30. Select CASE returning NULL value
  31. How to show Median in a GROUP BY clause? (AVE works, Median doesn'
  32. MSSQL - MySQL
  33. Brand Watches TAG Heuer Women's Formula 1 Maria Sharapova DiamondWatch #WAC1215.BC0840 Discount, Swiss, Fake
  34. Brand Watches Seiko Arctura Kinetic Men's Black Dial Date RubberStrap Watch SKA207 Discount, Swiss, Fake
  35. back up jobs, re-index question
  36. capture and save running sql query to database table (for logging)
  37. How to recover deleted records?
  38. file crawler
  39. design question - type heirarchy with supertype queries
  40. Use of having with additional select
  41. Performance question concerning varchar(max)
  42. using LEN to find a first word greater than 17
  43. exporting a table with long field names to Access
  44. Job ends successfully even when it's not true
  45. Basic SQL Question
  46. Yet another basic SQL question
  47. Another new DBMS
  48. copying data from one server to another
  49. FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
  50. CHECKSUM to determine record changes
  51. first minimum date in the column for each distinct column a value
  52. How to find records with length greater than 17
  53. The Sql ranking OVERture
  54. how to create my own primary key which auto-increment
  55. select parent records that do not have a particular child
  56. sp_prepexec syscomments?
  57. Get rows whose sum matches a value
  58. HELP WITH SELECT STATEMENT PLEASE
  59. SQL Server 2005: functions become slow after a while
  60. How to get the sql statement of a view? (by running a query or from ado.net)
  61. Login Seems OK but doesn't behave correctly
  62. Granting permissions for a user from another database
  63. table trigger just hangs
  64. Dump table as INSERTs
  65. SQL 2005 XML Searching
  66. SQL Server Management Studio
  67. Query Japanese Text in an NVarChar?
  68. case-when error
  69. select cases where a datetime is not 3 or more hours older than asimilar case
  70. Performing Bulk Load of XML Data
  71. import ADO DLL
  72. Secure Auditor, 30 security tools at the price of one.
  73. Finding "missing" rows
  74. Login failed for user 'sa'. Reason: Server is in single user mode.
  75. Secure Auditor, 30 security tools at the price of one.
  76. Connection String on shared server- Almost there but need a littlehelp
  77. Please recommend SQL book with excercises
  78. T-SQL Duplicate Record Help
  79. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  80. default value wich is not in DDL.
  81. DataServices World program: SOA data modeling, data services architecture, LINQ, ADO.NET, Entity Framework and more
  82. An sql dream - thinking in terms of order AND sets at the same time
  83. Constipated publisher (SQL 2005)
  84. PHP/MS SQL - automatic formatting: varchar, datetime
  85. xSQL Profiler - monitor multiple SQL Servers from one centrallocation
  86. How can I avoid using a cursor here?
  87. How do I make a backup device file smaller ?
  88. Update including Top, Orderby and updating 2 columns in an updatequery using TOP
  89. list of services
  90. SQL 2005: Renamed 'sa' account
  91. MS SQL Stored Procedures , Visual Studio 2005 , "Input values cannotbe converted"
  92. Convert rows to columns
  93. Client side insert update
  94. Yellowfin discusses Consolidation and its impact on the BusinessIntelligence Market
  95. help,a regular text file how to sql 2000 table code ?
  96. Strange Access Query Behavior with SQL Server
  97. multiple process multiple threads read/write to a table
  98. evaluating statement within a parameter for stored procedure
  99. Problem Connecting .NET app to SQL Server
  100. Unable to insert database name in sql string
  101. An optimum query..?
  102. boot camp
  103. getting tables that link to a table
  104. tempdb size question
  105. [IAT ELEZIONI] Presentazione candidati
  106. Simple Concatenation Question
  107. XML vs. Relational Data
  108. List Columns in a Table in SQL 2005
  109. Documents select
  110. SQL Assistance required
  111. Error History?
  112. Deleting multiple columns from multiple objects
  113. Help needed with TSQL statement
  114. from 'image' to 'varbinary(max)'
  115. Default storage space - DB engine tuning advisor
  116. Mimic Windows Explorer sorting by filename
  117. What does it mean to SET a value?
  118. Data Browser for SQL Server
  119. Re: Doing Summation on multiple criterias on the same column in asingle query
  120. Complex Calculation
  121. CS0246: The type or namespace name 'Namespace' could not be found(are
  122. Table variables and joins
  123. difference between explicit inner join and implicit
  124. delete output into <xml column of audit table>
  125. testing if value is null
  126. Internal query processor error
  127. Namespace problem in Bulkload
  128. Encoding problem in SQLXML - bulkload
  129. How to Interrogate SQL Server Tables for Specific Values - Here's howto do it in MS Access
  130. Sequential Time and Cumulative Counts
  131. Violation of primary key
  132. CASE WHEN Equivalent in WHERE Clause?
  133. Uninstall SQL 2000 Workstation Components
  134. Scalar Query in SQL Server 2000 like in oracle
  135. Scalar Subquery in MS-SQL Server 2000
  136. SQL 2005 Express - problem with no "SQL Serevr Agent"
  137. SQL 2005 Express - problem with osql log in
  138. SSIS security
  139. Getting DATETIME in ADO
  140. _variant_t
  141. SQL Server 2005 disk layout - opinions?
  142. Recursive Queries?
  143. forte macauley developement co condos in forte green brooklyn josephforte and phil ford s wife
  144. converting SQLTable to Excel Sheet
  145. ADO.net + VC++ DLL
  146. SQLServer - VC++
  147. dbrpcparam datalen problem
  148. ADO vs ADO.net
  149. DLL -> Database
  150. SQL Server
  151. Design a database
  152. how to calculate rank in selected records in sql server 2000
  153. help with DDL trigger. Moved from other newsgroup.
  154. UTF-8 Coding of MSSQL 2005 DB
  155. SQL Server - synchronizing database changes across servers
  156. Help Me create XML Schema file for XML Bulk Load into SQL!!
  157. Rounding not working
  158. LAN ADMIN/ STRONG SERVER SIDE/ PERM/ IN
  159. Help needed for converting varchar value in to Datetime
  160. Getting record position in sql server 2000
  161. Deleting Tables
  162. Is it possible to cascade table and field name changes to views
  163. call script from another script
  164. nub question :(
  165. Triggers and Flag bit
  166. Re: Doing Summation on multiple criterias on the same column in asingle query
  167. Import XML in SQL 2005 with nested elements
  168. IO Completion Listener
  169. ODBC Connections using alternate windows credentials
  170. Selecting alphanumeric combinations that do not exist already intable?????
  171. Doing Summation on multiple criterias on the same column in a singlequery
  172. Data Type
  173. TUTORIALS ON COMPUTER PROGRAMMING
  174. Newbie - why are column properties greyed out?
  175. Table Schema
  176. How To Convert String to Numeric for Sorting?
  177. Trigger and Identity column : what's wrong ?
  178. Data Shifting Between Records
  179. Current week walkin updates - visit www.walkincareers.com
  180. Moving SQL 2000 to a new machine by copy-paste !!
  181. Duplicate key ignored AND statement terminated
  182. SQL 2005 Workgroup Edition - how to run a trace
  183. SQL2005 performance problem
  184. Inserting nothing takes a long time
  185. Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
  186. The combination of Dataphor and Sql Server resumes development
  187. What privilege is needed to run DTSRUN ?
  188. Can users be connected during a SQL backup?
  189. job died but why?
  190. using fn_trace_gettable on trace files where the path contains aspace.
  191. Top company interviews in your city - Jobs you dreamt off - Applytoday
  192. Whats in store for Yellowfin 4
  193. How to connect to sql server from dotnet
  194. Login failed for user '(null)'. Reason: Not associated with a trustedSQL Server connection.
  195. what occurs in a comparison when a value is NULL
  196. Top company interviews in your city - Jobs you dreamt off - Applytoday
  197. Trigger to modify a table
  198. Allow Guest account in Windows XP professional to use sql server
  199. Select header when ALL detail status = Y
  200. Car-Sharing Offered - ICC Birmingham MS UK Product Launch, 19th March
  201. Bigint from a SQL Server table and viewing with Access
  202. Where is SQL Server Enterprise Manager?
  203. Copying SQL Server databases
  204. MS SQL SERVER DBA/ CONTRACT/ IN
  205. Question: performance of MIN vs. Group By
  206. [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
  207. Triggers
  208. Performance QA Lead Openings in Top MNC
  209. How to avoid a table lock for a single-row insert?
  210. Rename column name using variable
  211. help - extracting metadata
  212. Stored Procedure to Insert OR Update
  213. Query Assistance
  214. DDL Trigger To Track Schema Changes
  215. =?EUC-KR?Q?=A2=BE=A2=BE=A2=BEDVDs_are_100=25_brand_new=2 C_and_factory_sealed?==?EUC-KR?B?ISBnb29kIHF1YWxpdHkgYW5kIGNoZWFwIHByaWNlISCiw KLAosA=?=
  216. Tricky query...
  217. osql
  218. DateTime Automatic Formatting
  219. Result Row
  220. Name value pair
  221. concurrency problem with lists ("check constraint" on groups of rows)
  222. ssis Bulk insert failed "Received an invalid column length from thebcp client...".
  223. function to extract delimited data
  224. MS SQL Trigger to update changes in a record
  225. Creating custom Primary Key in SQL Server 2005
  226. cursor is READ ONLY help
  227. Spurious ORDER BY error from the DBMS...
  228. Email
  229. Unable to CREATE ASSEMBLY
  230. copying data WITHOUT DTS
  231. Top companies recruiting this weekend - Apply with updated resume
  232. Exam 70-229 :Designing and Implementing Databases with Microsoft SQLServer 2000 Enterprise Edition
  233. Help needed with a SELECT statement
  234. Between Operator
  235. How to decode in SQL Server 2005
  236. Call for Speakers for DataServices World (June 24, New York City)
  237. Scheduled data import from heterogeneous sources
  238. How can I format a datetime as 'yyyymmddhhnnss'?
  239. Re: Linking error
  240. SQL Server 2005 Licensing concern.
  241. Lost Full Text catalog that won't delete!
  242. Re: Linking error
  243. History Tables: Always Subtables?
  244. Removing 1 hour from text field
  245. Linking error
  246. CIITS Req: Need SQL Server DBA; 12+ Months, Local to MA only.
  247. Can we rely on object_id always increasing?
  248. Each GROUP BY expression must contain at least one column that is notan outer reference
  249. Queue handling design pattern?
  250. SQL Server 2000 Varchar limit