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