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