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. Problem zw. MSSQL7 und MSSQL2000
  2. Check integrity
  3. Join Three tables?
  4. Database size question
  5. Select wheree ID like '%' ?
  6. How to detach System Databases...
  7. While INSERT loop takes forever over MANUAL
  8. Shrink log file
  9. DTS package editing for SQL Server 2000
  10. niceSQL / SQL Formatter
  11. Multiple column result from one table
  12. Log full
  13. OpTools - News 2003.10.27
  14. Problem with user permissions on tables - not yet resolved
  15. SQL Server 2000 and Interdev 6 (Error Code = 80004005)
  16. incorrect settings: 'ANSI_NULLS., QUOTED_IDENTIFIER'.
  17. query2 question
  18. Stored Procedures Syntax
  19. accessing remote sql server 2000 ( enterprise manager like tool)
  20. Dumping incremental changes to textfile
  21. Stored Procedure - Returning a Value
  22. Trapping error messages
  23. question about cascading deletes
  24. host variables and code page conversion
  25. Return new id
  26. Sorting in query with Union
  27. Books OnLine (chm files) Problem
  28. Problem with a scheduled job
  29. SQL Update Query Problem
  30. Query : Running a job/step in a loop for ALL databases
  31. Server MSDE2K don't START.
  32. Visual Studio 2002 Professional & MSDE
  33. Taste this correction patch
  34. Simply updating a count in a SQL DB
  35. what affect does level 3 processor cache have on SQL
  36. from access to sql
  37. sql server job
  38. Redirecting Physical Database Files at Reboot
  39. Update/insert trigger
  40. query help(2)
  41. query help
  42. Taking 70-228
  43. A simple (?) SQL query for someone clever
  44. HELP!! HOW TO CALL A DTS PACKAGE FROM A STORED PROC
  45. formatted output
  46. ODBC SQL SERVER .. data would be Truncated!
  47. Quick and Easy Replication
  48. Return identity
  49. MS SQL Server databases
  50. Crosstab Qry with dynamic field names
  51. Altering tables and database growth
  52. how to use server time as an event
  53. Create Table from XML or XML Schema?
  54. COLID discrepancy in Syscolumns / Information_Schema.Columns - SQL Server 2000
  55. Converting integer to datetime
  56. help very urgent
  57. Question about temporary table .
  58. Cannot find select stored procedure wizard in SQL 2000
  59. Format Date into Day Name i.e. Mon, Tue, Wed etc...
  60. Change Logical Name of Db and Log file
  61. sql server more than 2gb usage
  62. Sorting mixed type fields...
  63. Replacing columnn name programmatically
  64. SQL Server questions???
  65. Date comparison problem
  66. I'm baffled by the single quotes with STMT
  67. how long a table blocked
  68. general questions on this product (compatability)
  69. setting DTS to use TCP/IP
  70. Slow updates in SQL Server 2000 BLOBS
  71. Variable Table Names in DTS Package
  72. Wrong week numbers
  73. Novello dba
  74. Cannot retrieve data in utf-8 from php
  75. ORACLE or SQL SERVER (MS) ?
  76. URGENT - - A floating point exception occured in the user process
  77. error,again
  78. Converting IIF in Access Query to SQL Server
  79. how to convert varchar to numeric ?
  80. Indexes slowing down BULK INSERT
  81. DB question ... thanks
  82. varchar and nvarchar issue
  83. SQL Setting Command
  84. Timeout issues with .NET & SQL Server 7.0
  85. Query problem
  86. SQLAGENT.exe - Entry Point Not Found
  87. Default Fill factor
  88. Creation of reporting database
  89. BCP Deployment
  90. Sql Query help..
  91. Urgent problem - Resord Set
  92. Generating a series of numbers or dates?
  93. top question
  94. top 2
  95. variable always empty in stored procedure
  96. ???VPN connection to an SQL Server and/or database
  97. Stored Procedures
  98. Is this possible? please help (MS access query of sql database)
  99. Capturing value of identity column for use later?
  100. SQL Statement select from one table where not in another table
  101. help in sql query
  102. How to delete duplicate records from a table ?
  103. Trigger failing after table structure change
  104. SQL server
  105. Calling a stored procedure from Access
  106. Outer join query
  107. Copy without Locks
  108. Creating a PDF from a Stored Procedure
  109. Cascading Blocking ?
  110. how to modify colum (alter table) of table that is replicated?
  111. Using @@IDENTITY in manual commit mode
  112. Sql query... help
  113. Trigger problem
  114. How to speed Stored Procedure?
  115. sqlagentmail - properties - mail session grayed out
  116. using SQL case statements HOW???
  117. Moving SQL DB's from machine to another with the same name
  118. What type of TRIGGER to use?
  119. Help with an WHERE NOT EXISTS subquery please.
  120. sql errors
  121. serializable read and lock mode
  122. List with all Error numbers
  123. iif to case for sql server 2000
  124. Internet Facing SQL Server, Login Security? How?
  125. Interrupt processing of a large insert process in SQL server 2000.
  126. Syntax for UNIQUE constraint
  127. Data/records in other languages
  128. SQL Stats in a form
  129. Create date field from substring of text field
  130. Sql Query Help - self join
  131. Procedure cache test
  132. SQL Server 2000 Rollback?
  133. Transaction - how to?
  134. Determining a mySQL servers status.
  135. How to pass a parameter to a view?
  136. Using CVS and SQL Server
  137. Version Control for SQL Code
  138. Haw can I insert null value from a query
  139. How to put result from EXEC into a variable
  140. Consulta de SQL (Admin Corporativo)
  141. Implicit conversion of datatype text to nvarchar is not allowed.
  142. Query Date Type
  143. Query to find a value in column b based on an aggregate function on column a?
  144. Sql query
  145. Totaling Group bys?
  146. Error on SQL Enterprise Manager Display
  147. CF / SQL Server syntax error HELP
  148. Automating SQL Setup.
  149. Comparing data in two tables to find missing records
  150. Isolation Level - Quick Question
  151. Get Count from Union Select
  152. MDAC Upgrade
  153. Running DTS package on a different server...
  154. US - Los Angeles - Sr Business/Data Analyst (SQL Data mining exp required)
  155. tracing sql for locks
  156. On the subject of Data Warehouses, Data Cubes & OLAP….
  157. Scan document data to SQL Server
  158. Problem with variable in T-SQL
  159. getting a list of groups a specific user belongs to in sql server 2000
  160. Transaction Log Cannot Be Truncated Nor Shrinked, HELP!
  161. login id
  162. query group by anno multi colonna
  163. JDBC with mulitple databases
  164. MS SQL Server Indentity Jumps
  165. error(2)
  166. Extracting existing SQL Server 2000 config...
  167. Using the AS clause in a SQL stored proc -- problem using datetime column
  168. newbe question: calling function inside select
  169. error
  170. error
  171. Using the global variable switch (/A) with dtsrun
  172. ADO Error 3251: Current provider does not support returning multiple recordsets from a single execution?
  173. Cannot import/link data from dBase with SQL Server DTS nor Access anymore..
  174. AsyncExecute problem
  175. Auto Documenter
  176. how can i connect my sql server 2000 to Adaptive Sybase Server 11.5 and 12.0?
  177. Problem calculating moving average
  178. why i can't add a new operator in SQL Server Agent
  179. SQL 2000 DISTRUBUTED QUERIES FAIL
  180. change tracking for SQL Server
  181. related rooms query
  182. stop replication MS SQL Server
  183. Periodical import of Access db into SQL Server 2000
  184. How to wrap a UNION query in a totals query?
  185. select question
  186. Copying views
  187. Combining Columns and Grouping By....
  188. Simple query, but can't figure it out
  189. Combining tables from different databases
  190. Storing data in image field
  191. default value
  192. Adding a "DB Version" Table: Suggestions?
  193. logic error
  194. How to use date function in sql server
  195. SQL Server 7 ignores user permissions
  196. Need to execute dtsrun without installing client tools.
  197. [165]ODBC Error 0 Timeout expired[SQLSTATE HYT00]
  198. Replicate to local pc
  199. Alternative to dynamic sql?
  200. Pagination for Large data
  201. automatic data update from SERVER to all CLIENTS connected ???
  202. How to reference items from different database?
  203. select cast error
  204. max,min
  205. Select Statement...
  206. Create temporary table through select statement
  207. Shrinking Logs
  208. phpBB2 <--> NewsGroup.
  209. Replace zeros and nulls with 1 in table -- Using case, but not working
  210. SELECT returning multiple values in a stored proc
  211. Using Where..IN in Update query.. not working for some reason
  212. Extent fragmentation still high after index drop/create
  213. Storing Unsaved Word Documents as BLOBs
  214. Finding duplicate entries in a "smart" way - by comparing first two words
  215. Stored procedure calling another stored procedure_
  216. c++ wrapper for odbc
  217. SQL error on URL -cannot create new connection because in manual or distributed transaction mode
  218. Import Pr's
  219. linked server question
  220. default value of the foreign key field in a child table
  221. "Not associated with a trusted SQL Server connection"
  222. Converting .dbf to sql server table...batch file? command line?
  223. <undefined value>
  224. global update
  225. Can't Auto-Start Agent
  226. Max database size on SQL-SERVER7
  227. SQL Server manipulation on external server
  228. This wretched SQL has me stumped!
  229. How long to copy/replicate a database
  230. Getting first row
  231. Database design question...
  232. Intercept SQL : Spy / Driver-level / SQL Server Log...
  233. Stored procedure with resultset _
  234. Useful Stored Procedure Question
  235. Updating Cubes with DTS
  236. Creating temporary table
  237. Multiple triggers
  238. how to write an aggregate function which can used like MAX(filedname)
  239. Could I use SQL "Select Case .. When..." in ADODB.Recordset().open
  240. Query Analyzer shows negative numbers as positive numbers
  241. Stored Procedure Syntax Help
  242. Updating Next Run Date value
  243. Updating many records
  244. CASE Statement in Where Clause?
  245. Btrieve to SQL Server
  246. Permissions To Run DTS Package
  247. SQL-DMO header file for javascript?
  248. displaying extra characters with COLUMN-defined number format?
  249. ER relationship
  250. Index Question
  251. Alternative to Creating View with Union in two databases?
  252. Major query optimiser weirdness with UDFs and SPs on SQL 2000
  253. Identity column in query result
  254. Changing the owner of a user-defined data type
  255. SQLgetinfo
  256. Try on this corrective patch which came from the Microsoft Corp.
  257. Is there a Microsoft Document Exchange and Database System like Lotus Notes or Oracle Managment Content?
  258. Database Performance
  259. Filtering and Aggregate functions
  260. US-FL-MIAMI *** SQL SERVER DBA *** Temp - to - Perm. 305.944.3294
  261. Problm setting up user. Error: user is null
  262. DateTime
  263. Stored procedures and CTRL+ALT+DEL
  264. Sql 7 password has been corrupted...HELP.
  265. Moving rows to columns
  266. Question about optimization
  267. SQL query problem
  268. Help With a DATETIME Query
  269. Querying tables from different databases
  270. Carrage Returns, Stored Procedures
  271. INNER JOIN using surrogate ID, or [Date] BETWEEN?
  272. Assistance with Stored Procedure
  273. Reading text into varchar
  274. Help With Another UPDATE Query Please!
  275. Query Analyzer : losing the ___ rows processed message
  276. Update Takes Long Time to Complete!?
  277. arrays in tsql?
  278. SQL Logins
  279. Data type change in SQL view
  280. DEFINITIVE ANSWER PLEASE -- can you UPDATE ntext datatype field???
  281. Rebuild master never ends.
  282. STORED PROC to "UPDATE" ntext field -- PLEASE!
  283. Variable Paramters to Functions
  284. Check Data Before Update
  285. IIS crash and format
  286. Assigning values to multiple variables (via subqueries) for use in an update
  287. Merging rows within same table
  288. Stored Proc to assign variable from subquery not working -- ugh
  289. test
  290. Backup of active log after db failure
  291. Self Joins
  292. sql server 2000 - dts can't 'see' stored procedure
  293. SQL Server storing large amounts of data in multiple tables
  294. Error 7399
  295. Tracing values in DTS package/stored procedure
  296. DTS and stored procedure
  297. QUITTING
  298. SP3 & CURSORS
  299. Key Word Searching
  300. Auto-increment fields when moving a base from Access to SQL server
  301. Detecting or monitoring for long-running queries.
  302. eliminating (inverse) duplicates in result
  303. Insert problem with linked server
  304. Nested SELECT HELP....
  305. zusammengesetzter Primary Key mit Deleted-Flag
  306. SQL Server 2K truncating text fields at 255 chars
  307. Rotating information from Recordsets to columns.
  308. Inserting Duplicate Data
  309. Creating join statements
  310. Case Conditional in SQL Statement - MS SQL 2000
  311. Sound device/driver
  312. Fetch Question
  313. Custom Error Messages
  314. formula column
  315. Transaction Log - Audit
  316. get description in table
  317. Import Human-Readable text file into SQL Server 2000
  318. Retrieve One Row at a time
  319. Two "Cache" related full time positions.
  320. how to add column in database at runtime.
  321. TEMPDB now at 4 GB
  322. Website Monitoring
  323. SQL Server Hogs 100% CPU
  324. FoxPro Index called from SQL Server
  325. null pages
  326. Cannot convert Varchar to Numeric issue
  327. Looping database queries
  328. Changing table owner
  329. Calculating Time Difference
  330. Return Value in a Stored Procedure
  331. Many fields update from a Group by Clause
  332. No results from Full-Text Search in SQL 2000
  333. Table design problem
  334. Rows as Columns
  335. where clause messed up
  336. Cursor, Query, View and Recordset
  337. SQL Server Monitoring
  338. Magic upper limit to number of job steps in a job
  339. Select, insert and delete queries timing out
  340. multi-thread tasks using a single connection object concurrently
  341. SELECT a random row for each different Type
  342. Order by clause
  343. Order By Clause
  344. Data File in a Different machine on the network.
  345. Query Help
  346. Creating a Stored Procedure from 3 queries
  347. Reasonably simple query question
  348. Desktop Engine and DTC
  349. AutoNumber
  350. Performance Complex SQL Issue
  351. Erro running a query if dashes present in the string
  352. Recordset Problem
  353. How can i get a return code of 1 for an osql command which has a lower severity..
  354. How could I do that (Query)
  355. SQL Server Replication and the growth of the subscriber log
  356. Duplicate records are being inserted with one insert command.
  357. Bulk Insert - Cannot perform SET operation.
  358. DEFAULT keyword performance
  359. Alter table permission to dbo
  360. Looking for physical design suggestions...
  361. sum() for textual fields?
  362. Concatenating a field while grouping records
  363. Two int fields or one varchar field
  364. SRV_DONE_ERROR
  365. DTS import renames my SPs to previous names
  366. Which one to buy?
  367. SQL 2000 Server Hangs...!
  368. Problems installing SQLServer 2000 Developer Edition on Windows XP Pro
  369. Strange database deadlock
  370. Am I being role happy?
  371. Multiple selects on same column, same table, one query
  372. Bulk insert of long unicode strings
  373. Query Performance Problem
  374. How to Update with SQL EXISTS(?)
  375. To make an existing column become an identity column
  376. Unable to begin a distributed transaction
  377. Replication on SQL Server
  378. What is this ?
  379. Returning results while the query is executing
  380. Autonumber...
  381. How to set a User Variable within a DTS package...
  382. Deleting extra tempdb log and data files
  383. Convert Access Function to SQL
  384. Is there a High water Mark in sql server
  385. Changing SQL Keys
  386. Database Books and Whitepapers
  387. Help!! SQL Server 2000 extended stored procedure hangs in Windows 98
  388. Request: Help creating a difficult view.
  389. Problems with partitioned views and pruning
  390. SQL Server 2K BackUp
  391. syntax for updatetext
  392. Cluster Database Failover Data in SQL Server?
  393. DTS automatic dat file import
  394. full text search and ampersand
  395. Getting database size: a stored procedure to do it......
  396. Using Stored procedures in a join
  397. Brainstorming: Ideas for categories database structure please
  398. getting table counts
  399. autogenerate numbers from 000001 to 999999
  400. Remote Database updates take long time to complete
  401. basic design question re effective relationship
  402. getdate() causes locks in views
  403. overflowing a local varchar
  404. Error in connectiong to second named instance of SQL Server 2000
  405. 2 group by in a single query
  406. MS -SQL Server 2000 -connection closes randomly
  407. When executing DTS package in program, the application will have no response during the execution
  408. SQL query suggestions/help
  409. Select multiple records into a table
  410. question about dummy constraint
  411. Many to Many to Many SQL Query
  412. BEGIN TRANSACTION or BEGIN DISTRIBUTED TRANSACTION
  413. How to get list (text) of all tables and columns?
  414. How do I select a column from sp_spaceused into a local variable?
  415. Delete duplicate records from huge tables
  416. Can "CREATE DATABASE" or "CREATE TABLE" be wrapped in transactions?
  417. Move LDF -Has anyone seen this happen?
  418. Course 2073: Programming a Microsoft SQL Server 2000 Database
  419. Problem with JDBC Driver for MS SQL Server
  420. Sum of Two Union Queries
  421. Combining Data from Variable number of tables
  422. SQL7 on Windows XP Home
  423. Adding staggered running total and average to query
  424. SQL Server Error: Exception_Access_Violation
  425. SQL Server does not exitist or access denied error
  426. Learning SQL Server
  427. DTSRun Encrypted
  428. One Statement Update - Join, no cursor ?
  429. SQL Resource Kit - dbgen - Database Generator
  430. Stored Procedures vs ADO vs T-Sql
  431. can stored procedure run more than 1 sql statements
  432. SQL Statement
  433. information_schema permissions
  434. Cube/Rollup without Group By?
  435. Log to big in SQL
  436. Problem with linking servers
  437. Date format export/import
  438. Force shutdown of SQL Server Instance
  439. Slightly Dumb Question about JOIN
  440. SELECT Top. Which method is best?
  441. Suggestions for a simple/introduction to querying OLAP
  442. Large table/slow query/ can performance be improved?
  443. Dividing two Count() Results
  444. cascade update / foreign key
  445. Transactions with remote connection
  446. Replication
  447. 2000 Personal edition install question
  448. stored procedure
  449. Stored procedure in database X, executes stored procedure in database Y, wrapped in transaction?
  450. MS SQL on the machine with multiple network cards
  451. JDBC with MSDE
  452. I can't create a temp table
  453. Replication
  454. Replication
  455. Databse Offline
  456. add new record - weird results
  457. Problems running stored procedures
  458. Windows NT Logon Problem
  459. Multiple-step OLEDB operation generated errors
  460. Use Database
  461. Login failed - Catalog information cannot be retrieved
  462. Sql Server 2000 linked server to Access 97/2000 incompatability
  463. table structure problem
  464. How to repair torn page on SQL data file?
  465. Permissions Issue when linking to MS SQL 2000 DB from MS Access XP
  466. Invalid object name
  467. SQL Date Query
  468. Compatibility of SQL Server 7.0 with Windows 2K
  469. DTS run from .NET
  470. PHP mssql_connect(): Échec de connexion
  471. Trailing 0's
  472. Column encryption
  473. Keep a few connections open all the time or open/close connections on the fly?
  474. VB.NET Retrieving Identity form MSSQL2000 without using stored procedures
  475. Get the closest date
  476. trusted connection
  477. sql query help
  478. Deleting data by comparing to another table
  479. indexing question
  480. Find number of licenses
  481. how to get decimal to date form
  482. UNION statement doesn't work
  483. Pervasive SQL and Btrieve --> SQL Server
  484. ORDER BY earliest date in a row
  485. Key column information is insufficient ....
  486. Key column information is insufficient ....II
  487. parameter query
  488. ADO or ODBC Recommendations
  489. Help me create this Trigger
  490. prevent SP compilation
  491. Looking for query plan determination information
  492. HELP: SQL Server Won't Release Memory
  493. SqlServer 7.0 ODBC error when querying with order by
  494. User defined functions in SQL server 7.0
  495. DataDirect Server Wire vs. MS ODBC
  496. Blanks in ColumnNames causes ODBC-Error
  497. Pseudo code advice
  498. A really DUMB question...
  499. Snapshot Replication - Distribution Agent Missing
  500. HELP: OLAP data cube in web browser loads slow or errors!
  501. Monitoring progress on a join
  502. Exam 70-229
  503. Current Time of SQL-Server
  504. SQL2K: Performance Problem with a query after Security Patch Ms03-031
  505. Slow Stored Procedure - Easy located but wtf?
  506. Weird Date Query Problems
  507. help getting data to excel from sql database
  508. Install error
  509. Database Sizing for Microsoft Content Management Server 2002?
  510. Error 500, Maximum concurrent users have reached
  511. Suppressing duplicate rows
  512. Cannot support Chinese Tranditional Characters in MS SQL Server 6.5
  513. Functions
  514. Please help
  515. SqlServer weekend job blocked by a user left open screen
  516. Enterprise Manager (SQL2k)
  517. query performance question
  518. The worst asp.net host
  519. shared server issue?
  520. Procedure in Stored procedure??
  521. XMLBulk load and trigger
  522. Creating Stored Procs based on SQL Server Version
  523. need help with producing data on one live
  524. Recovery from crash
  525. Inserting empty values into NOT NULL columns via ODBC
  526. tcp traffic
  527. Error with Flow Logic when creating a JOB
  528. sql-server / rollback
  529. UPDATE Query
  530. export table from one database to another on different server
  531. can't install mssql2000
  532. Weird License Issue (plus update blocking)
  533. Last insert id
  534. Table locking
  535. Parameter view
  536. Full text generating speed decreases continiously
  537. Need help on inner joins.
  538. Echo sql which has been run
  539. summing from multiple tables
  540. Could not find stored procedure
  541. SQL HELP
  542. Ms sql-server 2000 with navision client
  543. Migrating From Access 2000 To SQl Server 2000
  544. error 10005 dbprocess is dead or not enabled
  545. Fast counting of records
  546. Re-creating a database from a new data source - comments please!
  547. Print report by using SQL 2000
  548. question about cyrillic data
  549. Relational Data Transfer in DTS
  550. 'Diff' for tables *structures* rather than data