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