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