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