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