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