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 error
  2. Multithreading?
  3. Parent Child Tables
  4. Slow query execution, SQL Server 2000
  5. Error 208, Missing Stats
  6. 1 row retrned for 3 rows of data
  7. Setting up a Real-Time Data warehouse
  8. concatenate two column.
  9. How to make full-text search accent-insensitive?
  10. test
  11. Problem convert varbinary to float
  12. Sorting via script
  13. Select Distinct - Incorrect result
  14. Stored procedure - user defined function.
  15. Column Formulas
  16. t e s t
  17. test
  18. test
  19. SQLAgent can't up
  20. Return Values from a Crosstab Stored Procedure
  21. Can't import an Access table due to null values.
  22. I/O Congestion Troubleshooting: Memory and Swap File Usage Question
  23. scope_identity()
  24. Contains Predicate and Double Quotes
  25. upgrade from SQL 7.0 to 2000
  26. Query Analyzer Script
  27. PEAR DB 1.6.0 has been released
  28. create linefeed in field
  29. 'Syntax error converting datetime from character string' with sp_executesql
  30. Calling parameterised views from VB
  31. text with ' character
  32. Profiler Performance trace template
  33. Problem with Stored Procedure
  34. computers that connected via dial-up modems
  35. retrieving the the max occurrence of a record
  36. sql connection fail
  37. Script to generate INSERT statements on table
  38. Complex Sql Query
  39. Mail Client...SQL Server and another app. on same machine?
  40. Script to copy entire table
  41. Indexing - Uniqueness vs Highly uplicate
  42. How can the Profiler textdata field be enlarged?
  43. Text file import with DTS
  44. Variable Parameters - which approach.
  45. Duplicate a row in SP code
  46. virtuelle Cubes
  47. FTP Question
  48. Difference between windows locale in remote settings and SQL server
  49. Dynamic field question
  50. ANSI_NULLS and null comparison
  51. Formatting @query results using xp_sendmail
  52. Passing an Array and/or Variable Field Name to an SProc
  53. Transfering tables from one dB to another.
  54. sp_spaceused
  55. sp_spaceused
  56. sp_addextendedproperty versus sysproperties
  57. SQL Join Problem
  58. In(..) and Like xxxx% performance
  59. indentify full-text indexed rows
  60. How to query two MS SQL DB's on the same server inside a Stored Procedure
  61. Records appearing and then disappearing
  62. Inconsistent DTS Error - Help please
  63. Unicode ..
  64. Brick Codes
  65. How do I find the max row size..?
  66. encryption of sql database
  67. Problem with Provider=SQLXMLOLEDB.3.0
  68. Advice needed: Combining multiple Access db's in to 1 SQL db
  69. Copying deleted into temp table in trigger
  70. Help with Recursive Function
  71. Dumb Stored Procedure Question
  72. SP3a + Extended Procedures = not nice (help!)
  73. Create a new User
  74. Farsi Collation
  75. Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
  76. Win2000 OS Access for SQL Server Admin
  77. SQL Server Books Online January 2004 Update
  78. duplicate database
  79. SCHEMA -- 1000 products with different attributes
  80. Help! I can't write this SQL Server query ... can you?
  81. Timeout on running views in Enterprise manager
  82. Embed SQL statement in another SQL statement
  83. Error handling in MSSQL - if error during call remote stored prcedure I need SQL code to continue...
  84. Benchmarking a server
  85. Using Mysysobjects table in Sql Server
  86. remote transaction on SQL Server
  87. PHP with SQL Server
  88. Access <- > SQL Server
  89. SQL 2000 - Row Level Locking
  90. Help needed in Crystal reports
  91. Is it posiable to close the screen
  92. SQL Query - Please Help!!
  93. Usage of e.g. Max(Date) aggregat function
  94. New SQL Server tool
  95. New SQL Server tool
  96. Storing and viewing UTF-8 characters...
  97. It works
  98. Senior Microsoft .NET Programmer/Analyst needed
  99. Large table schema changes
  100. Recursive Query Quesiton - Table Function
  101. Importing into Test Database
  102. Move DTS package to another server
  103. Set Approach instead of Cursor
  104. Test Database Copy
  105. Error returned with no error message
  106. using multiprotocol net library in the system DSN
  107. Long running backups
  108. MySQL between times
  109. Parse Data from a String Field in a SQL Query
  110. Merge Replication error: The schema script '....sch' could not be propagated to the subscriber
  111. SQL Server How to Prevent Locking To Do Read-Only Reports
  112. Quastion about Temp Tables
  113. Copy tables between databases using variables
  114. bcp_exec() Failed
  115. Profiler's TextData column has 'NULL' and longest Durations
  116. Grouping Records & Assigning Sequential Number
  117. Null Foreign Key
  118. Load Balancing
  119. HELP! - can't send mail
  120. Resource Accumulation on SQLServer
  121. name value pair design
  122. select question
  123. Installing SQL
  124. ER diagram
  125. Coping Databases
  126. sql replication
  127. best way to store simple up or down values
  128. Compact Database
  129. Connecting to a linked server with ODBC
  130. Help! What is the risk for data on insufficient hardware?
  131. Nonprintable / encrypted characters is not found
  132. Recursively update data on a row
  133. Can I tell how often the clustered index pages are spliting?
  134. Disecting date into segments
  135. Column Comparison
  136. Groups and Permissions question
  137. Why are scalar functions soooo sloooow?
  138. Want 1 to many relationship when child table has no primary key
  139. Update SQL Server from Access
  140. ODBC and SQLServer : does I need the client installed on ?
  141. Mysterious Access Denied Error
  142. Backups
  143. DELETE query syntax using subqueries
  144. SQL Server Agent notifications to multiple (three-plus) addresses fail
  145. Query runs OK in QueryAnalyzer, but fails in batch
  146. Memory usage - max setting
  147. Slow select on sql 2000 with like '%value'
  148. Date only fields in SQL Server
  149. How to write portable database access code?
  150. Advice Needed : Nasty Problem PHP/MS SQL Server and Varchar fields > 255 in Length
  151. Finding Duplicates
  152. sp_help can't see my tables
  153. Triggers Question
  154. how to access ms-sqlserver from a Linux based computer
  155. DWH problem: updating a table with every 1000 records a checkpoint
  156. Repost: 00000 display on upgrade to Windows XP
  157. spread query
  158. setting and restoring multiple connection options
  159. Pricing of a SQL Server clustering solution
  160. Create sequential numbers in a column
  161. Bulk inserting into table with computed columns
  162. need help on sql/asp
  163. mssql server to access script
  164. SQL Server Ports - Net-Library Encryption
  165. For the SQL Gurus out there, a question
  166. Help writing a query.
  167. Simple Update Error
  168. Delete rows from table
  169. ASP/SQL Query Build - Myth Breaking
  170. SQL Server 2000 capabilities
  171. insert into table-Primary key error
  172. reformatting DATE
  173. selecting first row from GROUP BY
  174. Maintaining partitioned views
  175. many DISTINCT queries
  176. Know the "country version" of SQL Server
  177. Alter table and column order
  178. First attempt at Stored Procedure - can anyone offer advice
  179. Audit Drop table
  180. write text files in transac sql
  181. parameters in sql server 2000
  182. Using host_name(): Crossing my fingers...
  183. wrong query results in SQL Server 2000 from VB.NET
  184. Database permission error
  185. XML "Undeclared Tag ID" Error
  186. SQL procedure parameters
  187. Monitoring
  188. T-Sql - Calculate Each Monday for a given time period. Help??!!
  189. Error concatenating string
  190. Timeouts - Disk Queues
  191. Timeout problem with large update query from VB.Net to SQL Server 2000
  192. View behaviour in join
  193. Tables in Muliple Servers
  194. Job Failure
  195. Help with a SP
  196. Output from Extended Stored Procedure
  197. Scheduled DTS package fails
  198. Send/Receive text file using to some server using FTP
  199. problem with duplicate keys
  200. Opinions about Insertion Technique
  201. Have all your cross platform databases on one application
  202. Converting Oracle SQL to TSQL
  203. Possible to lock a row within a stored procedure in SQL Server 2000?
  204. Extract lower case characters
  205. Outer Joins
  206. converting a query with *= into SQL 92
  207. Updating changed row via trigger in SQL Server 2000?
  208. performing a whitespace-insensitive query
  209. msdb database problem with MS SQL Server 6.5
  210. Trigger and Row Update Help
  211. How to connect to a remote database ?
  212. Union All - Index is not used
  213. passing column name as parameter to a stored procedure
  214. Dynamic SQL Question
  215. Benchmarking database
  216. simple distinct query
  217. Difference between 2 stored procedures
  218. UPDATE CURSOR - declaring and use.
  219. Design Question: Calculated Field
  220. DETERMINING WHICH HIERARCHY OF A DIMENSION IS SELECTED
  221. Help needed in sp_pkeys
  222. sql-server 2000 limit rows
  223. How to Migrate DTS packages between servers
  224. MS SQL 2000 TCPIP Port Number and SQL Replication
  225. Export Access table into MS SQL server preserving Unicode characters?
  226. help with query
  227. Time between the busy_end_time and the next busy_start_time
  228. ADP Problem
  229. Slow query
  230. toad and oracle vs. mssql and ?X?
  231. Error while connection
  232. MSDE 1.0 (MSSQL 7) and Win98 / Win98SE...
  233. Northwind and pubs default login/password ?
  234. Access hangs after opening connected project
  235. Scheduled backup silently fails
  236. UNION ALL query - HELP!
  237. Bound parameters failure (SQLBindParameter) using ODBC
  238. Calling Stored Procedures
  239. Rounding and Grouping
  240. Strange Behavior with 2757: There was a problem... error
  241. problem with database connectivity
  242. CPU usage comparison for MS SQL Server 2000
  243. Changing Data in SQL
  244. SQL query
  245. attaching a database without a log file
  246. Performance problem, lots of disk activity, running out of memory
  247. Valid T-SQL syntax?
  248. SQL 6.5 to SQL 2000 performance question
  249. using mssqlserver with win xp
  250. weird error when precompiling genwin.mak with nsqlprep
  251. Cursed Error Messages
  252. Locking Users Out of Table
  253. Outer Join syntax
  254. SQL Question
  255. Creating a string from Date Fields
  256. Storing a stored-proc's result into a temp table
  257. Adding entry to DB and getting unique ID at the same time
  258. How to return a range of rows in sql server
  259. SQL Server 2000 standard on Windows 2000 Advanced Server
  260. searching for latest date and time only
  261. How do I Copy back in a DTS script?
  262. Why select ... where 'Anna ' = 'Anna' returns TRUE?
  263. How to Stop Logging
  264. xp_smtp_sendmail html+plain text
  265. insert into indexed table
  266. Column-conscious bulk insert
  267. backups
  268. SQL Server Sercurity Outside the Firewall ...
  269. Service Pack Question
  270. Service Pack Question
  271. Extract Rows with highest values in the columns, MAX doesn't work
  272. Replacing a portion of text string in column
  273. error to executing job on Sql Server Enterprise Manager
  274. security hole in stored procedure
  275. new to cursors
  276. triggers audit
  277. Login to MSDE on Win 98
  278. delete record
  279. Nesting a SP within another SP?
  280. Primary Key problems
  281. URGENT HELP PLS: select substring('NY',status/1024&1+1,1) from master..sysdatabases where name=DB_NAME()
  282. Using xp_cmdshell in INSERT trigger: bad idea?
  283. IF statement in Stored Procedure
  284. Drop the time portion of a smalldatetime field
  285. Large Data needs to be Deleted??? HOW???
  286. Polish characters displayed incorrect after post
  287. Listing all Indexes
  288. output param & multiple recordests from stored procedures
  289. UPDATE query in SQL Server
  290. Preferred SQL tools for sql*server?
  291. DTS Import of a text file
  292. SELECT * not returning any rows, but SELECT COL_NAME does!
  293. please help with query
  294. how to change dts import/export window's size
  295. Trigger with exec statement blocking execution of triggering cmd?
  296. Is this MSDE or full SQL Server?
  297. No answer for your problem ?
  298. New to SQL Server
  299. function and linked server
  300. import .sql script into sql server
  301. Import Text File on remote server
  302. Problem with Check Constraints
  303. Problem restoring database ...
  304. Testing and documentation tip
  305. How do I create an in-line comma seperated list
  306. Using SQL to find primary keys
  307. HOW TO CREATE TRIGGER ?
  308. SQL 2000 and dynamic image manipulation.
  309. Query Help
  310. Exporting Query Analyzer data with column headers...?
  311. PROBLEMA GRAVE: DESHACER DELETE
  312. Transaction log restore
  313. Problem using Convert on dates
  314. Select specific number of records
  315. to dbo or not to dbo
  316. Data Schema Comparison and Migration Tools
  317. complex query / advice needed
  318. Create view script with dependencies
  319. How do I restore the transaction log?
  320. Performance Question
  321. Fix dependencies during or after renaming
  322. Rebuild dependancy Information
  323. WorkAlerts Application Information Monitoring
  324. Ownership issue problems..... (I think)
  325. using osql to apply SPs in mutiple threads
  326. Memory Leak problem... in SQL Server 2K
  327. Query Help
  328. Query Help is Needed
  329. DBNULL Error - SQL Server2000/ASP.NET
  330. How to get webpage HTML source in server-site or client-side
  331. jdbc distributed transaction support?
  332. INSTR Function in MSSQL
  333. DATABASE MIDDLEWARE
  334. Small business application: best RAD tool
  335. Meta-Information about Stored-Procedures
  336. min with a bit
  337. Autonumbering causing deadlocks.
  338. Passing parameters to nested parameter queries
  339. Cognos IWR Server
  340. MSDE UDF?
  341. sql server 2000 trigger
  342. how often should indexes be rebuilt?
  343. Numbering Rows with a Twist
  344. Backup restoration / append query
  345. SELECTing WHERE string is within other string
  346. Network
  347. transfer database
  348. Problem in loading Roman8 characters (, )into SQL server.
  349. Current log - too much entries?
  350. Create table script
  351. Using adodb command - output parameter problem- HELP!
  352. how to create rule which update other columns
  353. sql server wait interface?
  354. does SQL Server take advantage of 'bind variables'
  355. Updating Data - 2nd Query
  356. Views Efficiency
  357. Select Records Between Two Times
  358. ADO connection with a SQL cluster
  359. Reset the Identity Increment
  360. Help with this query please
  361. String replacement
  362. Loosing SQL connection while running ASP
  363. sp_change_users_login
  364. upgrade database from sql svr 6.5 to 2000
  365. Troubleshooting SOAP
  366. General SQL Error - 2147221164
  367. Server Workload Question
  368. Deleting semi duplicates
  369. Return a value from stored procedure to calling application
  370. Fast Way to Concat Records to Comma Sep VARCHAR
  371. View or Stored Procedures
  372. Create a string of records from a table in a stored procedure,
  373. can SQL Server do hot backups?
  374. Indexing Advice
  375. Connection Pool - Does not check for Server Status.
  376. remove double value
  377. Log shipping
  378. get highest count
  379. Data just disappears
  380. Database design question with time
  381. XML leading spaces problem solved
  382. problem with cursor
  383. find string
  384. Updating Data - A query
  385. Insert Into Probelms
  386. using ODBC for database connectivity in C++
  387. Backup format
  388. Deployment / Version Questions
  389. sql query
  390. Grid Computing
  391. Finding Changed Records
  392. Adding Field to Stored Procedure for Crystal Reports
  393. unable to delete duplicate records in database
  394. There has gotta be a better way
  395. Database compare software question
  396. Retrieve first row only in many-to-many relationship
  397. Optimizer Logic Tracing Tool
  398. Web Assistant and Active Directory
  399. Trigger Problems
  400. Pass parameter to nested view?
  401. Nubbin question :(
  402. Needed help in Query
  403. Error: -2147217900
  404. ASP ADO SQL Time Out
  405. Tuning an Application Statement with Bind Variables
  406. Need Help on tricky sql involving joins
  407. MSDE2000A + Windows 2003 Server
  408. I think there is a better way.
  409. Database Permissions
  410. Transactions, Locks and Deadlocks
  411. Send E-Mail TO SQL Server
  412. VB.NET SQL Server Stored Procedure
  413. Help with sp_executesql
  414. Simple way to determine the number of days in a month for any given date
  415. asp / sql server dates in recordsets
  416. Setting column length in sql ?
  417. Update Query Problem
  418. Record count begin with big number
  419. Query Help Please.
  420. SET QUOTED_IDENTIFIER OFF
  421. Lock hint question
  422. Using MDX to find an average for leaf members on rows...dynamically
  423. Value of a record based on a previous record
  424. Business Objects and Microsoft Reporting Services
  425. Truncate Table vs. Drop Table
  426. String / Variable Problem - Dynamic Table Name
  427. Fast way to get values from previous record
  428. Scheduled report for database names and sizes
  429. EM DTS Designer ODBC source as a file DSN doesn't work!
  430. {fn CURDATE()} inside stored procedure
  431. Stupid Problem - Please help
  432. Stupid Problem - Please help
  433. Monitoring Tools.
  434. sysjobhistory in SQL 2000 Server
  435. Help - With Script
  436. Multiple instances ready for Production prime-time?
  437. automatic number problem
  438. Extract a string in a Stored Procedure
  439. Whats better?
  440. how to lock the store procedure and allow one process to acces it at a time
  441. sql 2000 licenses
  442. Upsized ACCESS Database to SQL Server 2000 with AS/400 Link
  443. SQLServer 2000 JDBC /SQL Exception Error Messages - Meaning?
  444. Performing a query using two tables
  445. How to backup up Win2K and SQL server
  446. toad for sql server
  447. Problem restoring SQL Svr 2000 Master db - wrong server version?
  448. Joins on same table
  449. Way to view all stored procedures
  450. UPDATE values from an array?
  451. Assign records to Analysts
  452. Trapping errors
  453. Restoring database
  454. Query Analyzer question
  455. ado "sql authentication" connections affected by loss of domain controller
  456. complex security on SQL 7
  457. Beta testers wanted for new "blueshell Data Guy Professional"
  458. tracing sql from code
  459. TABLE Variables
  460. How to do this update?
  461. Data for source column is too large for the specified buffer size...
  462. Opening Mulitple Recordsets
  463. Delete trigger in SQL Server 7
  464. 2 query question...
  465. MSSQL Server accounting
  466. Stumped. Totally... (but there must be a way!?)
  467. converting rows to columns
  468. Path to a "personal knowledge database"
  469. Make MS SQL Server case-sensitive
  470. Calling user-defined function without 'dbo.' -- possible?
  471. Replication solutions?
  472. Script Question
  473. A cursor with the name 'deadrow' already exists.
  474. Production release methodology
  475. delete child table rows based on predicates in a parent table
  476. Registry key setting for MS SQL Server
  477. Odd syntax error with shape queries SQL2000/Win2003
  478. how to bring back a list of duplicates from a column
  479. Insert Question
  480. COALESCE as a Performance Enhancer??!?
  481. Creating a diary - structure problems!
  482. How to parse a string column with comma delimited
  483. Newbee
  484. Stream size limitation
  485. Encrypting data within the DB
  486. Pls Help: can't connect to server - login fails
  487. Only enable the string truncation prevention of ANSI_WARNINGS
  488. Append Query Problem
  489. Error reading password-protected FM in SQL Server
  490. changing default values
  491. problem with a simple check
  492. Stored Procedure Syntax Problem
  493. Read SP source code from VB
  494. Nested
  495. HELP - SQL Server Crash ? Memory leak ?
  496. Bol error
  497. performance degradation on data transfer
  498. Problem with .mdf File
  499. MSDE questions.
  500. Passing an IN (a, b, c) list to a sproc as a string -- best method?
  501. SQL DB move from one storage subsystem to another subsystem
  502. SQLExecMS ver 2.1 has been released
  503. How can you tell what the primary key of a new row will be?
  504. Creating a Script out of Sample Data
  505. locks preventing backup of database
  506. Tricky grouping query
  507. DTS package problem
  508. Small Business Server 2000
  509. Filtered out code
  510. Finding the port the MSDE is running on --
  511. Question regarding Stored Procedures, Views and ASP
  512. Help with file placement please...
  513. Invalid Cursor State Error
  514. Automatical table update within a database
  515. Stored Procedures With VB
  516. Syntac error (missing operator)
  517. windows authentication
  518. can you, by default, allocate uniform extents upon creation of index/table?
  519. Maintaining Variable After EXEC
  520. Assistance with Stored Procedure
  521. Question on SQL Installation
  522. missing tables in sysobjects
  523. Checking all views for errors after upgrade
  524. exec(select...), how supress the output?
  525. Problems with DTS package. Access denied
  526. startup account in SQL 7.0
  527. condition with group by
  528. Comment on Replication
  529. MS-SQL Script Question
  530. Normalization connundrum
  531. Pricision of float
  532. Wildcards in SQL Server stored procedures
  533. Logon time looks faulty
  534. sql server does not exist or access denied
  535. error 1069
  536. Problemer med en DTS-package
  537. Need help regarding index keys for MS7 and MS-2K
  538. Force Row Level locking in SQLServer 2000 ?
  539. DTS save to Meta-data services disabled?
  540. how to select max amount rows
  541. Deadlock Question
  542. dbuse function, and spaces
  543. Stored Procedure Syntax
  544. detect existence of datetime fields
  545. Tricky schema question - dimension can split and combine over time
  546. SQL Server developers edition on XP Pro?
  547. Shared memory in MSSQL
  548. Rows not importing through BCP
  549. Question about JOIN syntax
  550. Adding a new user login