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. WAITFOR DELAY '000:00:05'
  2. Converting binary to text
  3. Suggestions for a reporting system
  4. function call with table as parameter
  5. db_owner rights
  6. Subquery parameters
  7. One ms sql server 2000 instance blocks the other (thru a dts-job)
  8. Parsing a SQL Statement as a parameter and executing it
  9. Need help creating query
  10. BINARY_CHECKSUM algorithm
  11. Alternate to a not in query
  12. Has anyone seen a 25 TB data warehouse on SQL Server?
  13. Concurrency Handling In Stored Procedures
  14. OpenQuery and passing variables
  15. No disk activity during database restore
  16. Change ODBC pointer on workstations after database move
  17. Query table based on multiple keys
  18. Indexing etiquette
  19. Replication Problem!
  20. Returning average of multiple rows in a table join
  21. selective sql request
  22. SQL Openquery & Oracle
  23. Sql Query with one column as the name to another column
  24. selective sql request
  25. Search multiple job sites for you!
  26. Create Views via Access ADP
  27. query to trace all parents
  28. Problem with script
  29. Caller identity
  30. CHARINDEX
  31. Reporting Services Menu -Web
  32. MSQuery Question
  33. exclude query
  34. Problem In Doing Shrink Database
  35. Win 2003 x64 + SQL 2005 < Win 2003 32 + SQL 2000?
  36. Beginners Question
  37. sql server causes No buffer space available (maximum connections reached?): recv failed
  38. A Query
  39. Advance SQL question
  40. Fast copy big table content
  41. Union Query
  42. Can an update statement be used for interpolating missing data?
  43. merge history ip address
  44. retrieving agent id?
  45. Sql Server Password Expiration?
  46. Sorting - character after 'Z'?
  47. QUESTION: Status column of FK Constraints in sysobjects - ????
  48. set of dates
  49. using a stored procedure as a sub query
  50. Problems with Windows Authentication
  51. bulk copy error: Received invalid row length x from bcp client. Minimum row size is y
  52. SQL server process architecture
  53. Delete-operation performance problem
  54. Programming Field Lengths
  55. Change SQL Server Serial Number
  56. How to Disable ALL Constraint In ALL Tables
  57. request issue
  58. Have a better UPDATE statement than what I wrote?
  59. Please help with this query
  60. Tedious but not difficult!
  61. Top 1 Row for each ..,
  62. Top N rows, discard duplicate
  63. Wide Primary Keys
  64. MSSQL linked server to Oracle RDB
  65. Encrypt payroll fields
  66. Join Small Table to Big Table or Vice Versa, does it matter?
  67. AUTHORIZATION with WINDOWS AUTHENTICATION -- HELP!!
  68. Accessing publication properties from Visual Basic (VB6)
  69. formatting question with osql batch file
  70. Appending data to a table but not duplicates
  71. Outer Join not working when using SQL-92
  72. moving data files to a new disk, same server
  73. Care and Feeding of Databases
  74. sorting based on various data types
  75. ordering problem
  76. deadlocks involving parallelism
  77. Problem converting rows to a string
  78. Excel - Read-only
  79. Please help with a query
  80. Temp Table in a Stored Procedure
  81. To Use Triggers or Not?
  82. SQL Server 2000 - restoring (point in time)
  83. Restoring a DB
  84. Raising Error from Trigger to Stored Proc
  85. SQL Server performance problem!
  86. Locking on Tempdb...
  87. Own Query language for non-technical Users, any frameworks known?
  88. Searching
  89. Normalization Question Regarding Column Combinations
  90. VB6/SQL Server application runs locally, but not from server
  91. Problem in Update Trigger in SQL Server 7.0 - Need some help!
  92. Running VB Function in SQL?
  93. Multiple insert
  94. What happens if a table has no Primary Key?
  95. Transferring Data from MSDE Database to SQL 2000 Database
  96. SQL Server Process and Memory Usage
  97. BACKUP ERRORS MISSING IN THE EVENT LOG
  98. DTS Import Wizard Causes Crash
  99. Restoration of Transactional log Backup
  100. SQL Server Agent + SQL Mail
  101. cursor application?
  102. Restricting returned rows
  103. multi keyword search SP
  104. merge database content
  105. SQL Query: Merging Tables
  106. xp_sendmail Error
  107. Printing a word document from T SQL
  108. Retieving data with "for xml"
  109. Put multiple results in one field
  110. Connect via ip not name - why?
  111. Create view with data from multiple servers
  112. SQL Date Fields ASP.NET
  113. data deletions
  114. sql query
  115. How to write trigger for ON_DELETE_CASCADE?
  116. SQLSever not using index
  117. CHECKSUM_AGG and BINARY_CHECKSUM performance problems
  118. Deadlock in View with Select Union - Creating A/S Dimension
  119. SQL Server Row Size - Stored Procedure ?
  120. How to connect to sql server on another machine through asp.net
  121. Secure/selective data access
  122. Best way to add to DB while checking for duplicates
  123. Obtaining count for identity
  124. Transact-SQL Tutorial
  125. Multiple Queries
  126. How find user is sending a packet every .02 sec to MS SQL?
  127. SQL query to check against a list
  128. Convert Informix Stored Procedure
  129. Ver número de Serie en SQL Server
  130. Create a time series
  131. The Curse of Dynamic SQL
  132. Truncation errors in MS SQL
  133. UPDATE SQL Statement in Excel VBA Editor to update Access Database - ADO - SQL
  134. Linked server insert problem
  135. Why is my Output Parameter not working?
  136. Shrinking SQL2000 Database w 20 datafiles.
  137. Rookie question about query/View
  138. Bulk insert from netware problems after applying SP4
  139. Help with full-text search
  140. Backup Query
  141. Insert or Append?
  142. Maintenance job fails
  143. nested queries, stored procedures, temporary table
  144. key column from 0000001 to 9999999
  145. Locking behaviour on JOIN
  146. Date format in Sql Server 2000 italian and english
  147. Table order when inserting data
  148. Need Help with Adding a Duplicate record count column to Query
  149. Upgrading from 3.23 to 4.1
  150. replication problems sql server to db2
  151. WRITELOG lock on databases set to SIMPLE recovery
  152. Conceptual ideas - 2 tables one changes other complete Cursors?
  153. MSDTC: Receive Returning Out Of Resources Error
  154. Misunderstanding of backup
  155. A curious case of data corruption
  156. Query/Workload Generator
  157. predicate locking
  158. SQL Server 2000 SP4
  159. Fastest way to build a database out of SQL scripts
  160. Text and Ntext fields
  161. .net / weserver problem
  162. Strange behavior
  163. Trigger assistance
  164. List of columns from tables across databases.
  165. The specified file was not found
  166. xp_startmail return code checking
  167. Sort procs in a given db by most recent modification
  168. SQL 2005 testing
  169. List of columns from tables across databases.
  170. Backup Plans and Locking Database
  171. The specified file was not found
  172. xp_startmail return code checking
  173. Speeding up inserts
  174. Sort procs in a given db by most recent modification
  175. ANSI-89 DB JOINS
  176. sql2000 replication
  177. question about performance issues w/SQL2000 with NO indexes
  178. SQL 2005 testing
  179. Windows 2003 Server and ASP
  180. Query word starting with....from string caught in web app
  181. Backup Plans and Locking Database
  182. triggers
  183. Testing for cursor's existence
  184. sql2000 replication
  185. Speeding up inserts
  186. ANSI-89 DB JOINS
  187. question about performance issues w/SQL2000 with NO indexes
  188. Windows 2003 Server and ASP
  189. Query word starting with....from string caught in web app
  190. triggers
  191. Testing for cursor's existence
  192. stored procedure issue
  193. Non-Unicode to Unicode Data conversion
  194. Max Filegroup Size set to 20 how do I change it?
  195. QUESTION: Converting Oracle shell scripting from AIX to Windows
  196. long running transactions w/ other users needing to read data
  197. SQL DTS query using WHILE Statement successfully executes (only updating 200 of 1494 records)
  198. Sql Server Backup - Remote -> Local
  199. SOLVED: [dbnetlib] connectionread (recv()) error
  200. Best Practises for Server Sizing for MS Reporting Services
  201. CreateFile error while generating Snapshot with SP4
  202. SQL server job timeouts?
  203. SQL and UNIX
  204. test
  205. How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data
  206. How to export a DTS
  207. SQL2K WIN2K3 CONNECTION SECURITY
  208. what type of Constraint to prevent duplicates
  209. How can I restrict bandwidth between to SQL servers
  210. Select distinct one some fields, but return all feilds
  211. When changing to type text from nvarchar, the 255 character limit is maintained?
  212. sp_who2 output
  213. SQl server using high Virtual Memory
  214. Triggers on tables underlying a partitioned view
  215. How to Use Varchar with Int column
  216. Scheduled DTS
  217. Using DiskIO in sp_who2
  218. Reporting Services PDF Size
  219. Connection is busy with results for another hstmt & Win2003 SP1
  220. Exception repeately occurring
  221. Deadlock detection problem! help
  222. Two records of same Partner together
  223. Table Backup
  224. EMC Replication Manager/SE
  225. When this fabulous offer is going to expire.
  226. Index Creation Date
  227. Help on INI file
  228. Does the transaction log on a publisher SQL server get truncated when the database is backed up, but the distributor is down?
  229. Enumerating instances without DMO
  230. Issue with msxisapi.dll
  231. row length exceeds 8060 bytes
  232. Want to grab a list of available databases on a given server
  233. query with a table name that has a space...
  234. Log Shipping and BLOB data
  235. Date/Time Stamp
  236. Error with OPENXML
  237. Need help with query
  238. Conversion Probs..
  239. authentication issues, security groups
  240. identity column
  241. Backup strategy
  242. TimeOut with ms sql 2000
  243. INSERT failed because of incorrect SET options
  244. Format function in SQL
  245. Issue in browsing msxisapi.dll please help
  246. RS - Multiple Development Environments on one machine
  247. how to script security permissions?
  248. How to repair sql table - Error in DTS
  249. Licence Question
  250. Strange Backup Problem!
  251. general question of before image vs checkpoint
  252. Export view result using transferdatabase
  253. Which has the best performance?
  254. Network performance for simple select statement
  255. Help with a simple query please
  256. Finding designation of an employee on a given date
  257. top n percentage
  258. Problem faced in Join(T-SQL)
  259. What is purpose of semi colon after procedure name
  260. UPDATE/INSERT to make One-to-Many table become One-to-One
  261. How to convert datetime to DATE '1936-04-13 07:00:00.000'
  262. log shipping - synch
  263. log shipping - synch
  264. Restore latest backup and logs
  265. SQL Server only use one cpu
  266. How do your keep text formatting when you insert it into database
  267. problem returning rows from SPROC
  268. SQL UPDATE Database from Excel Table
  269. Rows to Column Names
  270. Stored Procedure vs SQL huge difference in execution time
  271. Upgrade Wizard
  272. Missing Program group
  273. Sort Expression as Store Procedure Parameter?
  274. SELECT works but UPDATE fails. ?
  275. test
  276. Printing query results from sp
  277. binary_checksum and validated software environments
  278. checksum_agg and row size error. Require explanation.
  279. Loading Flat File using DTS
  280. Stop replication of deletes
  281. SQL Server license checker
  282. Can someone tell me what's wrong with this code?
  283. SQLTransaction locking up table
  284. Getting Data from a storeed procedure in a stored procedure
  285. query in dataview.rowfilter
  286. How to add a foreign key constraint using the SQL server 2000 enterprise manager
  287. SQL Server Performance and permissions
  288. New to merge replication - simple scenario......
  289. Case Insensitivity
  290. Port Fowarding or VPN with Linked Servers
  291. Import schema into SqlExpress
  292. My first trigger
  293. Is Cursor Best Way To Go?
  294. EMC Replication Manager long recovery time
  295. table/index and page mapping
  296. passing parameter
  297. Cannot use TEXTIMAGE_ON when a table...
  298. SQL view / joins query
  299. SQL server - 'cold' database clone, was this ok?
  300. Restore Problem
  301. SQL query in vb.net
  302. SQL Connections with VB.NET
  303. How to find transposed data and near misses
  304. how to determine dbas?
  305. current date/time formula
  306. Incrementing number in a column -- rookie sql user
  307. Finding a column in a database
  308. sql server and vpn: performance/speed
  309. ODBC driver for MySQL does not work properly after version upgrade
  310. Code in the database or middle tier (the CLR controversy)
  311. Script for adding fields to table
  312. stored procedure and if exists
  313. dates issue
  314. clustered index on composite primary key
  315. QUERY HELP: Selecting distinct for two columns group by one
  316. Tx Log Truncate and Deadlock
  317. Giving Active Queries Priority
  318. Query Question
  319. Filter Expression
  320. sqldmo ListAvailableSQLServers crashes
  321. Need help returning a null value, please
  322. Query to compare table data between Test and Production?
  323. text or varchar ?
  324. Set READ UNCOMMITTED (dirty read) at login.
  325. Problem to Run DTS from Stored Procedure
  326. datatime error
  327. Logic problem in cursor/SPROC
  328. Question: ODBC Connection Error .. multiple thread (urgent, pls)
  329. Creating index on a view to prevent multiple not null values - Indexed view?
  330. Blocking
  331. Need an allround DBA (development&Admin) in MSSQL and Oracle
  332. Can't install MSDE
  333. Column name in functions
  334. IF SELECT UNION
  335. ADO Error Code:0x80040e4d
  336. One-to-many with a twist
  337. Problem with DateTime and strings in stored procedures
  338. SQL Server Database Comparison
  339. sa Vs sysadmin login
  340. log-file for interface-use
  341. deadlock
  342. Stored procedure fails execution sometime
  343. tips on securting sql server
  344. How to delete a big amount of data
  345. How to delete a big amount of data
  346. system time on sql server is wrong?
  347. What is the right value for BCP's ROWS_PER_BATCH
  348. deadlocks
  349. Change SQL Server Authentication Programmatically
  350. Can MSSQL load a tab delimited text file?
  351. SQL Server Express
  352. Query Help, thanks!
  353. Encryption and "WHERE encrypted_column LIKE"
  354. Getting Plan of previously executed Queries
  355. SQL Memory Issues - Need Advice
  356. Help Needed With Job Scheduling
  357. displaying a table
  358. SQL Automatic Growth
  359. Displaying database name within select within UNION
  360. Doubt to be Clarified
  361. What's the difference? Unque Constraint and unique index, etc.?
  362. Need some help with design of tables/views
  363. Db Owner
  364. Setting password for each database
  365. Upgrade from SQL Standard edition to Enterprise edition
  366. Restore master database from 64bit sql server to 32 bit server
  367. ACCESS 2003 query size high problem help
  368. Converting Text to Proper Text in SQL
  369. Increase number of process(thread)
  370. Writing multiple queries to a file with BCP
  371. Help with SELECT please
  372. Concurrent queries error
  373. Permissions with views and tables
  374. some sort of cross tab query in sql
  375. getting a stored procedure's code
  376. Find similar strings in two tables
  377. Error While Reindexing Job
  378. EM
  379. Creating a DB by restore - problems
  380. Multiple SQL statements in a stored procedure
  381. Help with SQL Query
  382. Sql Server incorrectly functioning
  383. retrieving backup
  384. BCP fmt and Create Table
  385. VALUE IN FIELD NULL OR VOID STRING!?
  386. URGENT - DTS - Need to run the object to perform the operation - Exception Access Violation
  387. Trigger Error
  388. Passwords in Sql Server 2000
  389. Create table from Text
  390. Proportional fill
  391. sql server transaction syntax help
  392. Locking an MSSQL record with ADO.NET
  393. setting remote path for "text file (source)" - DTS
  394. sql 2000 with windows 2003
  395. DTS
  396. Display Image Datatype from a table in Reporting Services report..!
  397. what is the true definition of catalog table?
  398. Backup Help
  399. SQL Union / Intersection
  400. DBs not appearing in query analyer dropdown
  401. Question on generating SQL scripts using Enterprise Manager
  402. Heterogeneous queries
  403. Selecting Min/Max over multiple rows
  404. Easy way to remove international alphabet from all rows?
  405. Help with the Security/Login/User area of operations
  406. Suggestions?: Querying tables from multiple databases
  407. how to continue on error
  408. Returning a count of items including zero
  409. update sql errors using linked server
  410. Crystal reports - maximum group total??
  411. Insert performance different between two servers
  412. SQL Injection Attack
  413. Forbidden access to ReportServer (error 403)
  414. Subquery in case statement
  415. Joins on UPDATE
  416. Copying Database from 2000Server Machine To 2003 Server Machine
  417. SQL Job failing error 8198
  418. Collation conflict isssue
  419. How to reclaim space in columns changed from nvarchar to varchar
  420. personal edition then move to enterprise
  421. Test
  422. bad page ID
  423. Foreign key constraints?
  424. Compare SQL objects
  425. CS vs CI database
  426. Network Restoration Of Database
  427. help with for xmp explicit
  428. Cant use ODBC data source on SQL SERver 2000 sp3a named Instance
  429. Order Schedule.
  430. Problem linking tables
  431. Informix Date Function Equivalent
  432. Delete Duplicates
  433. Using IN(xxx, yyy) with table row
  434. Update question
  435. MSCS SQL2000 Cluster 64 and 32 bit servers
  436. Conversion Error...nvarchar to Datetime
  437. Data Comparison
  438. Query Analyzer on 2003 WE
  439. Procedure Encryption - Any side effects?
  440. Restore database April CTP 2005 Failed?
  441. Sql query help
  442. SQL Query Analyzer Greyed Out
  443. How long is a SQL statement allowed to be?
  444. SQL server 7 physical storage
  445. BULK INSERT Question
  446. How to assign quota on a specific datafile?
  447. Updating indexed views - who pays?
  448. Updating SQL Server Database from Access
  449. Adding Active Directory login (ca vs. samaccount)
  450. Checking The User's Server Role
  451. Very Urgent: Required document for R/3 installation on SQL server in disrtibuted environment
  452. Collation problem
  453. A floating point exception occurred in the user process. Current transaction is canceled.
  454. Extended stored procedure performance tuning
  455. creating data for a histogram.
  456. IF...ELSE error
  457. Front Page 2002 and SQL Query
  458. Confusion over "ANY" keyword
  459. Remote ODBC Connection problem \
  460. Service Pack 3 to Service Pack 4
  461. Service Pack 3 to Service Pack 4
  462. Error 7201: Permissions problem?
  463. SQL SERVER BACKUP problem in different DEVICES
  464. Company-calendars
  465. [Fwd: Reverse pattern matching]
  466. Using EXISTS
  467. Negative values for RowModCtr col in sysobjects tbl
  468. Working with date ranges
  469. Building / Modifying an SQL Database remotely
  470. complexity of nested self left joins?
  471. Changing collation when installing SQL2000
  472. ODBC connection to SQL server failing
  473. Delete recordsets with same Date and Line
  474. SQL Files Query
  475. Problem finding values with aggregate functions
  476. Moving all DTS packages from server to server
  477. Deadlocks & BEGIN/END TRANSACTION
  478. Excessive stored procedure [COMPILE] lock
  479. Bad executed Plan and wrong Result by SQL
  480. NOT FOR REPLICATION, Enterprise manager
  481. Date poition comparison of a datetime field
  482. How to deploy a report in Reporting Services without using VS 2005?
  483. hash table (#) order by problem with more records
  484. Avoid index scan with LIKE and a variable
  485. help with exists
  486. Query Produces Jumbled output / output not in sequence
  487. Compare two databases and update objects?
  488. Will it auto convert datatype???
  489. db_owner to all tables
  490. Which is more efficient, join or straight select
  491. importing from .txt
  492. How to send data from a remote Client to my FTP site
  493. How to send data from a remote Client to my FTP site
  494. How to Copy and Rename a Database: same server
  495. SQL query - highest rated or least voted items
  496. FK on a column to a table where the column is not the PK but a Unique Index
  497. Could not find the index entry for RID...
  498. Script for comma seperated values
  499. Output Select results to a text file.
  500. Storing pdfs in an image field
  501. compare data
  502. ntext and update/insert triggers
  503. A query runs fast in Query analuser but slow in APplication
  504. Cannot start MSSQL Server 7
  505. Insert datetime problem
  506. Why....'PRIMARY' filegroup is full????
  507. insert current date/time
  508. How to insert new rows to master table
  509. storing text data in a binary field
  510. dynamic SQL variable with Output ??
  511. Need hardware suggestions for SQL 2000 server
  512. Basic Syntax explanation
  513. lookup table relationships best practice
  514. Serverwide Rollback
  515. Troubleshooting failed job
  516. Insert Trigger to Update table
  517. Split a field
  518. Date Format Conversion
  519. Can't create table
  520. SQL Syntax - group by and having count
  521. Can I recover from the database files?
  522. BCP and SQL Server 2K
  523. Sending data to a Stored Procedure with ASP error
  524. Syntax question
  525. Theta join or equijoins??
  526. Importing from PL/SQL to MSSQL
  527. How to convert binary or hexa to decimal?
  528. WHERE clause delima
  529. XML Problem in SQL Server 2000
  530. Syntax Question
  531. removing data
  532. varchar only up to 256 characters?
  533. Xquery Support in SQL-Server 2005
  534. equivalent Oracle rownum in SQLServer
  535. Memory leak in SQL Server
  536. Create Second 'sa' Account ('sa2') on SQL 6.5?
  537. SQL Databases compare tool
  538. Need help relocating transaction log file.
  539. C# SQL-DMO ExecuteImmediate
  540. Propagation of event notification when tables are updated.
  541. Which is better for making a copy of a database, restore or DTS?
  542. testing a connection string
  543. Process Info (SQL Server Enterprise - Management - Current Activity)
  544. Slow MDB Linked View
  545. delete last added row -how to
  546. Memory Running Out
  547. Help With Some SQL
  548. Global temp table permissions
  549. How to restore database to point in time (no full backup)
  550. time from datetime