View Full Version : sql server answers


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

  1. SQL Query Help-- Order By Clause
  2. SQL Licenses
  3. ADO client disconnects after running a long query
  4. Problem With TSQL Subscription
  5. Count if Conditions Met
  6. Generating Scripts to Populate Tables
  7. DTS document or ebook
  8. more efficient - exists or in
  9. SQL Join Statement problem
  10. Giving users specific DDL permissions
  11. Permissions for dropping & creating triggers & indexes
  12. Open stored in Hexadecimal
  13. TCP/IP Connectivity
  14. Local table and OpenQuery
  15. Drop Primary key constraint of (#) Hash
  16. Convert a Unicode Database into a non-unicode database
  17. altering dynamically a set data type
  18. Merge replication and spids left behind
  19. TSQL command to call *.sql files
  20. localization and sqlserver
  21. SQL matching two multiple valued strings
  22. Is it wrong to allow user initiated DDL commands to facilitate an extensible schema
  23. Update Trigger - Update Query
  24. DB shrink problem
  25. How to copy table from oracle database to sqlserver database ?
  26. Why it is prohibited in UDF?
  27. Linked Server from SQL-Server 2000 to Oracle 8.1.7
  28. stored procedure
  29. sql
  30. Importing .prt files to SQL
  31. Time Stamp
  32. Unique values between two tables.
  33. Triggers running slow (Update Trigger)
  34. Fill stops /timeouts
  35. network packet size
  36. order of recursion in stored procedure
  37. Please help with this tough SQL query
  38. SqlServer 2000 Enterprise Manager - Major Bug?
  39. Uniqueidentifier causing strange execution plan
  40. Finding out how many times a table is accessed
  41. Merge WAN Database (Best way to add 1 new field)
  42. How Two JOINS from one table
  43. SQL-2000 Stored procesure or function
  44. "Dynamic" sorting inside a procedure
  45. Working wth XML
  46. Fine tuning this sql-query. help!
  47. Hibernate
  48. @@TRANCOUNT difference between SQL 7 and SQL 2000 in trigger
  49. need a JDBC driver
  50. CA issues million dollar challenge to open source community
  51. Last row in select question
  52. Need help to get this query up and running.
  53. what is this erroer Message ?
  54. xp_cmdshell resulted in "access is denied"
  55. ASP returning null sized field from MS SQL database
  56. Is it necessary to order again?
  57. Triggers from one MSDE to another using DTC
  58. One more solution for a pagination
  59. SQL select statement error
  60. Blocking
  61. "Query is too Complex"
  62. Delete help
  63. Return records through a linked server that uses ODBC data source
  64. Scalability problem With .Net and Sqlserver
  65. Inserting / Updating LongText Field using WriteText?
  66. Passing Temp Table Values into a UDF
  67. Performance Tuning UPDATE Statement
  68. Disregard some parameters
  69. Uploading SQL Server database to ISP
  70. SQL mail issues
  71. question for the 'senior' people
  72. Excel automation
  73. Automatic backup of MSDE database.
  74. Japanese words
  75. Could not allocate space for .. error
  76. SQL Server invoking batch file
  77. DXReport - Generator de rapoarte pentru Microsoft SQL Server 2000
  78. collation issue
  79. (Revised)Database Design question, Header with two detail.. pls help
  80. cryptoAPI
  81. Database Design question, Header with two detail.. pls help
  82. Great new application
  83. how to preserve users when restoring a database
  84. Identifying Unused Tables
  85. Query Question
  86. DTS Import Wizard fails
  87. Does SQL Server support XML Functions
  88. user table
  89. Slow procedure using view
  90. update deadlock question
  91. moving a heap to another filegroup
  92. Prototype for a web application
  93. Memory Leak. SQL Server sp3a, VB and MDAC 2.8
  94. sp_adduser and the old question of why??
  95. Install of SQL Server 2000 dev edition over MSDE. Any advice appreciated.
  96. is it possible to use a simple ODBC config on a unix client to connect to MS-SQL server?
  97. How to insert NULL char values in SQLSERVER with a SQL sentence?
  98. A Range Query Optimization
  99. Sql Query Help!
  100. DTS Yukon beta 2 Library not registered
  101. Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.
  102. Copy stored procedures to another database
  103. Stored Procedures on SQL 2000 compared to dotnet's Datatable.select
  104. Date inputs (UK format) in SQL svr 2000 with OLE DB
  105. invalid attribute/option identifier
  106. Bloated database wont shrink after backup/restore SQL 2000
  107. Print Attributes in Stored Procedure
  108. Help with date parameter and if/else statement
  109. Getting Memory usage through T-SQL
  110. Session memory usage
  111. Defining AS400 Linked Server
  112. Separate foreign keys with shared ID space
  113. admin realted questions
  114. passing table/column name as parameter
  115. basic sql query needed
  116. Newby: Administer a database remotely?
  117. System Monitor / SQL Server
  118. How do I select all records in one table that have NO related records in another table?
  119. Do for each - how to write it more graceful?
  120. Resources
  121. Cannot Register Instance of SQL Server 2000
  122. select statement
  123. ODBC Connection busy error
  124. Format of tables
  125. backup
  126. How to convert string to upper case using Field's Formula Property
  127. How to compare database structures?
  128. IDENTITY_INSERT Problem
  129. finding out table names
  130. SQL 2000 Q: duplicate database
  131. Locating a table using index page
  132. Converting C++ Unix time_t Julian date to SQL date
  133. is sqlserver 2000 compatible with windows 2003 ?
  134. RSS Search
  135. variable
  136. Looping through a recordser in a stored procedure
  137. How to upload more than one field?
  138. Arnold Schwarzenegger Commits Suicide
  139. Finding BINN directory for Multiple Instances
  140. CAL & MSSQL Security Question (by an ignorant)
  141. Help for a new user
  142. Size of SQLServer databases with indices
  143. device CALs
  144. Procedure performance in QA vs Sql Agent Job
  145. c++ ole DB stack overflow during sql server compilation
  146. Stored procedure permissions with xp_cmdshell on SQL 6.5
  147. Changing drive letter
  148. type mismatch : Error
  149. SQL server 2000 memory reclaim
  150. Replication Distribution Agent Does Not Start
  151. trusted SQL server connection
  152. Using BCP/xp_cmdshell as NON serveradmin
  153. Bradmark's NORAD monitoring utility
  154. SQL Server under VMWare
  155. SQL Full Outer Join
  156. Hourly batch process locking my database
  157. anyone has xp_gettable_dblib source code?
  158. replication/distributor problem
  159. UpdateText through a stored Procedure on a input parameter
  160. Server Crashed/Need to move SQL 2000 DB
  161. Delay before uncomplete transaction removed
  162. Bring Data into SQL Server
  163. INT Size
  164. Insert Trigger and xp_cmdshell with carriage return text
  165. MSDTC is unavailable.
  166. Unable to connect with Enterprise Manager
  167. Passing Parameters to Extended Stored Procedures
  168. Adding a time column to a date column
  169. Analysis Services connection "No Go"
  170. Script for SQL Agent "Weighted Job Duration"
  171. Returning # of columns with non-null value
  172. Need dynamic SQL
  173. Someone else editing record ? Only me on the server ?
  174. DTS - Dr Watson Error
  175. Pocket PC and SQL Server CE.
  176. Linked server to oracle
  177. row delimiter from osql output
  178. Distributed transaction....
  179. Code does not select any data for information from the different tables in the database
  180. SQL MSDTC
  181. Many to One with Max Date Query?
  182. password for sa was changed spontaneously
  183. Incorrect Syntax
  184. SQL syntax - INNER or OUTER JOIN vs. WHERE
  185. Text manager can not conitinue with current statement
  186. Blocking problem
  187. Script for Transfering Database Diagram
  188. horizontal positioning
  189. join 2 complex queries to 1
  190. How to get the amount of bytes exchanged during a Merge replication between 2 MSSQL servers
  191. Error... Invalid object name 'data1'.
  192. sync'ing 2 databases
  193. Transaction Log
  194. Web site with database models
  195. Math is driving me nuts
  196. Recovery SQL Server
  197. Hardware question
  198. instead of trigger example
  199. Unique Identifier Crystal Reports Parameter
  200. simultaneous updations and deletions between databases
  201. Differences between SQL Server Versions
  202. Stored Procedure to upload data from one db to remote db
  203. updating and deleting parent and child table simultaneously
  204. Pass Scope_Identity() back to the calling application
  205. Access2K Connecting to SQL Only as LocalAdmin
  206. Access2K Connecting to SQL Only as LocalAdmin
  207. Huge Imports using DTS - advice needed ...
  208. SQL 2K Security Baseline or Security Checklist
  209. SQL Solution
  210. Record insertion
  211. Table Overwrite
  212. deadlock error
  213. adding some rows to a select
  214. Scalar Function Columns
  215. problem with attach database
  216. syncronising SQL tables between seperate servers
  217. Finding Last Updated with a timestamp
  218. Problem: Replication fails over modem but works on LAN
  219. Creating a simple update trigger
  220. performance issue (repost)
  221. Update query question
  222. Stored procedure
  223. optimizing a query to delete duplicates
  224. Table Qualification in SQL Server 2000
  225. bcp within batch file
  226. SQL Server Overrides My ANSI_PADDING Setting
  227. I thought I posted this one but don't see it. Problem with querying a query
  228. Having problem with sql create
  229. Using like predicate
  230. Need Assistance Creating a stored procedure
  231. Dangers of Client batch cancellation
  232. ..\MSSQL\Data\ - Directory saturated
  233. SQL many-to-many query problem. HELP !
  234. How to Restrict all SQL Database's Size
  235. Small problem with DateType
  236. MS SQL 2000 Backup. where r my Indexes?
  237. Ageing data using Sql Server 2000
  238. Using identity to generate a primary key
  239. export (from mdb)-> import (to MS Sql server)
  240. Delete SQL Table using a variable that refers to the Table Name
  241. A better way to handle repeating dates
  242. views across databases
  243. Deployment Question, Connection string issue.
  244. Deployment Question, Connection string issue.
  245. Min pool size
  246. tool that create sql script to recreate a database
  247. How to count number of rows
  248. Is this DELETE possible?
  249. Create a file using a SQL DB Trigger
  250. count multiple distinct columns
  251. Setting up SQL Mail
  252. Complex query
  253. How do I append string to end of sql query results?
  254. New db cant be found
  255. BCP -k option - Very urgent
  256. insert into many rows
  257. Follow up to Exec..master and sp_dboption
  258. performance
  259. Problem with dates
  260. Block Port 1433 on windows 2000 server
  261. Using Unique Indexes
  262. Determine winner from two distinct lines
  263. O/R mapper
  264. Query Optimization Assistance w/ Joins
  265. Problem unauthorize deleting of primary key in SQL
  266. Inner Join question
  267. Determining if foreign key constraint exists
  268. SQL Server Lab Design
  269. Locking hint problem on multi-servers
  270. Problem with MSSQL SPRINTA 2000 JDBC Driver
  271. Problem with MSSQL SPARTA 2000 JDBC Driver
  272. mssql2000 on emc mirrorview volume
  273. Design issue
  274. SQL order question
  275. IsNull ordering
  276. IsNull ordering
  277. Using NEWID() as a parameter to a stored procedure
  278. find
  279. cant start sql 2000 on port 1433
  280. How to update using a function
  281. Fill Column with Sequence
  282. Compare and Restore Tables
  283. ISO dates?
  284. Easiest way of combining multiple fields from different records into one record?
  285. send email to me when job fails
  286. Importare txt in SQL
  287. Utilities to check for errors in stored procedures
  288. SQL Report Generation
  289. storing passwords in database
  290. Possible Bug in SQL Server 2000?
  291. SQL Server 2000 Hardware Recommendations
  292. MS Sql Server and Windows 2000/XP
  293. How can I make a SQL agent job to ignore warnings?
  294. Help with a View
  295. Script to copy permissions for all objects given to a user or a role
  296. Generating Foreign Key Script
  297. How to Identify Hot Tables
  298. SQL Query Help - - Table Normalization
  299. need help with converting old style subselect to ANSI joins?
  300. Invalid object name
  301. fastest way to insert range/sequence
  302. Stored procedure with output variable
  303. SQL Agent Job failed
  304. Loading Data into SQL Server from a SAS Dataset
  305. Compound Statements
  306. Determine closedate depending on a metatable and this closedate will be used in a query
  307. Grouping by unrelated field- SQL masters, try this!
  308. How to transfer data from SQL Server 2000 to Db2 V8 using DTS and Odbc driver
  309. Web server hardware design with SQL back-end
  310. SQL Server setting has any effect on queries?
  311. Drop tables with unknown names and unknown quantity
  312. Cursor problem
  313. how to parse a name
  314. Why, "Invalid column name"?
  315. business logic in Stored Proc VS aspx.vb page
  316. Pb to retreive max value with aggregate subquery
  317. SQL Server Backup Failure
  318. SQL Server + SSL Hangs?
  319. SQL Server + SSL Hangs?
  320. Image files and SQL Server
  321. help forms
  322. Reading rtf from an image field
  323. SQL Float Operation with Round() fails completely
  324. is ASP the only way for SQL remote access via internet
  325. SQL Profiler info req
  326. Weird Optimizer Choice
  327. CASE alias in WHERE
  328. New user needs help
  329. .exe to insert data in SQLServer database
  330. Row Handle Invalid
  331. WAITFOR DELAY
  332. examples
  333. SQL Game
  334. is it good idea to replicate sql server db files?
  335. hOW DO I KNOW THE HOW MANY INSTANCES OF SQL SERVER RUNNING SINGLE MACH
  336. Help! Sql Server 2005 kicked my Sql Server 7's You-Know-What
  337. Bug (?) in nsqlprep.exe (SQLServer 2000)
  338. Export relations from SQL Server Database to MS Access
  339. Finding if a REAL is LIKE '%[49]9'
  340. Difficult Query: is this possible in SQL?
  341. Calling methods, functions threw Extended SP in a DLL
  342. Outlooksoft
  343. Need to speed up query.
  344. Concurrency puzzle (ODBC API related)
  345. Lock Stored Procedure
  346. SQL SERVER 2000 - EXEC master..xp_cmdshell permissions
  347. question about launching an application at sqlserver startup
  348. XLOCK and ROWLOCK
  349. Null & one more table
  350. question about launching an application at sqlserver startup
  351. How to properly restore transaction log
  352. Example code for database configuration(MSDE)
  353. Dynamic SQL trouble
  354. Search Multiple Columns with REGEXP
  355. Development Environment Needs?
  356. Help with NOT EXISTS query
  357. Sending an e-mail via SMTP in SQL Server
  358. Login With Domain Account
  359. Drop Column problem
  360. Backup and Restore
  361. Aborting CALL to stored procedure
  362. SQL Checkers Game
  363. jet to sql
  364. how to get a list of configuration settings for a database
  365. Selecting Unique Record
  366. SQL Server to Oracel
  367. Eliminating Combinatorial Relationship Multiplication
  368. HELP with TIME Calculations
  369. Slow performance on ADP forms using filter
  370. SQL Syntax problem
  371. howto: calling sp_executesql from a function ?
  372. SQL Data Compare Error
  373. Fundamental help required with SQL connection
  374. Help: MS-Word apostrophes in Query Analyzer
  375. fail to configure my server for replication
  376. Replicating LDAP entries to a SQL Database
  377. Converting MS query to SQL Server 2000
  378. Linked Server request...
  379. I need BETWEEN on speed
  380. Vyas, Neil and others Please post your views ---- SAN , active transaction logs
  381. does anyones knows polyserve products
  382. sp_makewebtask
  383. Multiple many to many
  384. MS SQL 6.5 Procedure to Send Query results via Email
  385. Why the transaction log file full
  386. EMC Clarion Performance Issue
  387. checklist for moving a database from one server to another?
  388. How do I loop thru a result set?
  389. Custom SQL Server Job Schedule
  390. XML Output
  391. Parameter value from empty text box - null or 0 length?
  392. SQL update on multiple tables
  393. PRINT only takes effect after T-SQL completion ?
  394. Invalid character value for cast specification: SQL Server 2000
  395. Data Processing Script Justs Stops
  396. sqlserver7 connect
  397. View performance, linked servers, query specifiying uniqueidentifier
  398. University of Plymouth Computing Industry Perception Study
  399. Guid vs Identity
  400. parameterized queries running slower than non-parameterized queries
  401. Converting numeric data type to text data type
  402. PERC RAID Controller settings?
  403. get current table name in stored procedure
  404. sp_prepexec and compatiblity mode 7: float variables comparing to string field fails
  405. Beginner's Question on SQL-DISTINCT
  406. Database field length problem
  407. xp_cmdshell missing
  408. Running DTS through Access VBA
  409. Using MS SQL server to copy files
  410. Age Old Question about GROUP BY clause (i think) - Probably easy answer
  411. Help with 2 queries / Join problem
  412. Sccheduled packages don't run
  413. MDX Query Help
  414. Help with returning a certain # of records from a view.
  415. The size of the image data type
  416. Write Conflict.. please help!
  417. SQL Server to Oracel
  418. Very puzzling count
  419. Installing SQL Server 2000
  420. I can't restore the transaction I needed! Help!
  421. SQLAgent crash
  422. help how to create a row progressive..
  423. error 'Login failed for user sa', and the backup fails.
  424. Update, case statement and sum
  425. SQL Server ASP Syntax error
  426. DTS Package
  427. Big problem with triggers
  428. Restaurant databases
  429. SP Technique --
  430. SQL CPU Utilization goes to 0
  431. differential backup failure
  432. OT? mysql groups
  433. Deadlock Problem
  434. Modifying Sysxlogins Domain Names in SQL2000, strange result..
  435. Help with SubQueries?
  436. converting date/time to just date?
  437. SP problem with editing records
  438. SQL Server Licensing Question
  439. MS Network Monitor Utility - How to get for Win 2000 Pro
  440. Database Access Right Issues
  441. DBA guide
  442. Read Data from Cube and Dump in a SQL table
  443. Automatically Sort Table when Table is Opened in Project
  444. Vo2Ado/MSDE Create Index problem
  445. Using triggers
  446. SQL instances
  447. storing phone numbers
  448. Using User defined type instead of varchars
  449. SQL Server - Remote Command Line Management
  450. Add a second databse - benefits?
  451. Goup by clause confused....
  452. test
  453. sql
  454. MSDE 2000 Release A won't talk
  455. No default entries in SQL Server 2000 Service Manager Options
  456. Needs Help in Making Database
  457. indexing
  458. Comments on InterSystems Cache Database Platform
  459. Analyze LDF files MS SQL Server 2000
  460. sql server service pack 3 update, delete question or problem
  461. Determining if a parameter exists in a stored procedure
  462. Looping In SQL 2000 (Can it be a nested loop)
  463. Inserting few Recordsets into Temp Table containing NULL Values
  464. WARNING. A simple cut and paste of 8 records can distroy a SQL Server table
  465. Help with an MS SQL Server Query to return the latest dates against each recordID.
  466. HElp :)
  467. select between date
  468. Update rows with next higher id, if it exists
  469. SQL Server ORDER BY bug?
  470. denormalize data in a temporary table
  471. Web publishing in Visual Manfacturing
  472. Error creating linked server to Excel
  473. Syncing Database
  474. slow select statement -- please help
  475. DTS workflow problem when encountering On Failure
  476. query question
  477. Modelling large trees in SQL Server
  478. Superior SQL Builder
  479. Is this too much data for SQL?
  480. SP Error
  481. query question
  482. Different behaviours on different servers
  483. explain plan
  484. getting an int id from an inserted record
  485. Format File Easy one (not for me)!
  486. I give up on this one...
  487. Bulk Insert Problems
  488. sql date contraints
  489. Concatinating Variables
  490. Passing a specific cursor record to a function
  491. Exporting SQL to Excel Hourly
  492. SQL Server 2000 filling a key field
  493. Non sharing data cluster
  494. No Subject
  495. sp_executeSQL Syntax Question
  496. Bcp and Bulk Insert not working
  497. I need the istance name in my SQL 2000
  498. restore from different server - user (sid) does not match restored db - fix with sp_changeobjectowner
  499. Declare an array of int in SQL Server
  500. INFORMATION_SCHEMA query question: constraint columns
  501. Record lost with UPDATE statements
  502. MS SQL Server -
  503. Alter Table Alter Column
  504. sql insert problem
  505. I/O Component Bottleneck Theory
  506. Fixing my table based on Dbcc Showcontig results
  507. Scheduling a backup
  508. How do you "dump" a database with MS SQL?
  509. Problem with conversion of string
  510. MSDE and Windows 98.
  511. NEED HELP and GUIDANCE!
  512. multiple records, only want one
  513. Example of a University database
  514. Help with multi Join or multi tier select.
  515. DESPERATE help needed....
  516. Complicated Update Statement
  517. Databases Syncronization
  518. SQL SERVER Backup
  519. Where is stored Columns Description for SQL Server Tables?
  520. Sql Server & Java. Book Recommendation.
  521. UPDATEs with multiple aggregate functions
  522. Performance Question
  523. Databases Syncronization
  524. Storing Time in SQL Server 2000
  525. Upsizing from Access Data Type Problems List
  526. Stored Procedure Question
  527. View not working SQLSERVER 2000
  528. archiving analysis server dbs
  529. connection to sql server 2000 from Solaris
  530. OPENQUERY Question. How to update using 2 tables
  531. strange problem
  532. MS SQL Server - a plethora of limitations...
  533. interupt JDBC SQL query connection
  534. Parameter Query
  535. function
  536. Please Help - dBASE
  537. Upsizing to SQL 2K
  538. Restoring Master from Enterprise Edition to Standard edition
  539. # of billing cycles
  540. Computer Books, Inc SQL Server 2000 Books - up to 80% off
  541. Replacing characters in a text field
  542. What's in a full SQL Server backup?
  543. Order by "string not empty"?
  544. Microsoft certification test 70-229
  545. Building dynamic tsql statements in a loop
  546. Problem with LEFT JOIN... please help!
  547. Duplicate Removal and Intelligent T-SQL
  548. Data script
  549. Deleting a record from a VIEW
  550. Need MAX from Each Group