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