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