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