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