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