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