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. XACT_E_REPLAYREQUEST
  2. SQL Query- confused with nesting...
  3. Moving a SQL Server 2000 database that is in Standby Mode
  4. Calculated values and database design.
  5. huge logfile problem
  6. sysindexes???
  7. Retrieving Result Set from Dynamically called Stored Procedure or function in a Function
  8. How can I show decimals after division update
  9. Help in SQL Query - easy
  10. How do I set values to DBPROP_DATASOURCEINFO (from SQL)
  11. Job Failed
  12. Help in SQL query
  13. Change Collation Sequence
  14. How do I store objectGuid (binary from AD) into SQL table?
  15. DTS permissions and ownership
  16. Max () query problem
  17. Select and Update of records without being used by other users?
  18. BACKUP TABLE(historical)
  19. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  20. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  21. Repeatable error, with script, with code
  22. Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
  23. Make a copy of parts of a ROW, but with a new Key.
  24. MSDE Install Problem
  25. Member Property
  26. Image file, SQL Server, and web.
  27. It is not a real index but exists as statistics only
  28. EXEC Inside a cursor iteration problem
  29. domain user or local system account ?
  30. Alter Table - Change Column Datatype
  31. Creating Tables and automatically inserting data-HELP!!
  32. Output parameter from Sproc
  33. XACT_E_REPLAYREQUEST
  34. Calculated values and database design.
  35. huge logfile problem
  36. SQL Query Quandry
  37. Retrieving Result Set from Dynamically called Stored Procedure or function in a Function
  38. a piece of theory
  39. sysindexes???
  40. Paging Advice Needed
  41. T-SQL ASP While not rs.EOF
  42. Locking Info
  43. How do I set values to DBPROP_DATASOURCEINFO (from SQL)
  44. who i am in MSSQL
  45. Job Failed
  46. How do I store objectGuid (binary from AD) into SQL table?
  47. Change Collation Sequence
  48. Select and Update of records without being used by other users?
  49. DTS permissions and ownership
  50. Generate SPs as text
  51. Syntax error converting the varchar value '10.136.20.20' to a column of data type int.
  52. Repeatable error, with script, with code
  53. Search contents of stored procedures?
  54. SQL + everyday
  55. MSDE Install Problem
  56. Connection Problems to SQL 6.5
  57. SQL Query Analyzer - Trace Tab
  58. SQL Query Quandry
  59. a piece of theory
  60. Paging Advice Needed
  61. T-SQL ASP While not rs.EOF
  62. Locking Info
  63. who i am in MSSQL
  64. Incorrect columns returned by view
  65. Generate SPs as text
  66. Syntax error converting the varchar value '10.136.20.20' to a column of data type int.
  67. How to convert int to decimal
  68. Search contents of stored procedures?
  69. SQL + everyday
  70. Cursor and row retrieval question
  71. Connection Problems to SQL 6.5
  72. SQL Query Analyzer - Trace Tab
  73. Can anyone give me a query for this ?
  74. Any Column Updated / Inserted Trigger
  75. Incorrect columns returned by view
  76. Stored Procedure Question
  77. Guid as primary key
  78. DTSrun in Stored Procedure
  79. Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?
  80. Using a trigger on a view
  81. Clarification about newid() function
  82. How to convert int to decimal
  83. Storing Dynamic Table or View information
  84. Cursor and row retrieval question
  85. Update Time Question
  86. Can anyone give me a query for this ?
  87. update field with max from another table
  88. 'Upgrade' from 2000 Standard to 2000 Development edition
  89. Data transfer from 6.5 to 2000
  90. SQL Server text file continuous import problem
  91. Any Column Updated / Inserted Trigger
  92. Stored Procedure Question
  93. Guid as primary key
  94. Data Restore on Elm Street!
  95. Problems inserting rows using OLEDB and views
  96. DTSrun in Stored Procedure
  97. Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?
  98. Using a trigger on a view
  99. Clarification about newid() function
  100. Storing Dynamic Table or View information
  101. creating Random Lists which do not have any unique records?
  102. SQL Server 7.0 installation
  103. Update Time Question
  104. update field with max from another table
  105. TimeStamp
  106. Data transfer from 6.5 to 2000
  107. 'Upgrade' from 2000 Standard to 2000 Development edition
  108. SQL Server text file continuous import problem
  109. Loading text files using DTS
  110. Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
  111. Self Join Question
  112. JOIN ON CONTAINS(Table1.Field1, Table2.Field2)
  113. Create Index via Stored Procedure?
  114. Data Restore on Elm Street!
  115. BCP in of hex data
  116. Problems inserting rows using OLEDB and views
  117. Insert rows from other server
  118. MS SQL vs PostgreSQL
  119. Checking obligated values in different rows
  120. Licensing
  121. creating Random Lists which do not have any unique records?
  122. Premission to create database!
  123. MSDE Question
  124. SQL Server 7.0 installation
  125. Checklist
  126. MS SQL Port
  127. Converting negative value
  128. TimeStamp
  129. Which SP3a for SQL 2000 Personal Edition?
  130. Loading text files using DTS
  131. Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
  132. Direct access to records via timestamp
  133. JOIN ON CONTAINS(Table1.Field1, Table2.Field2)
  134. Self Join Question
  135. BCP in of hex data
  136. Create Index via Stored Procedure?
  137. Insert rows from other server
  138. MS SQL vs PostgreSQL
  139. Checking obligated values in different rows
  140. Licensing
  141. Counting number of IO Accesses per DB
  142. Premission to create database!
  143. MSDE Question
  144. DTS and Transaction
  145. Checklist
  146. MS SQL Port
  147. Converting negative value
  148. Scripting data in tables
  149. Which SP3a for SQL 2000 Personal Edition?
  150. Direct access to records via timestamp
  151. Counting number of IO Accesses per DB
  152. DTS and Transaction
  153. Scripting data in tables
  154. 446: Impossibile risolvere il conflitto di regole di confronto per l'operazione
  155. SELECT issue
  156. Bypassing recovery for database
  157. loosing Databases ??? Help
  158. Advice
  159. Backup Text Report
  160. Howto work and manage Backup Logfiles?
  161. Changing Database within a stored procedure
  162. SQL Trigger for changed columns?
  163. SQL Server Analysis Series Cross Tab Crosstab Report
  164. SQL Server/ADO/XP problem "query cannot be executed"
  165. Geographically Diverse Data Deployment Doubletake, SRDF, Log Shipping
  166. Is tempdb big enough for what I'm doing, plus other questions.
  167. Weird select statement ?
  168. OLAP - Calculating Minimum Measure if NULL is present
  169. Looking for findcolumn script
  170. Can I create a 'Top n' statement within a stored procedure using a parameter?
  171. a heirarchical query
  172. UniqueIdentifier pros and cons ??
  173. Is there a macro (as in C lang) like facility in SQL server 2000.
  174. How do I do this is SQL Server? (from an Oracle background)
  175. Blocking and return parameters
  176. *** DTS Error Messages ***
  177. Matching Strings In Different Tables Of Same Database
  178. HostName Function with Access2K front end
  179. Sql server log File Full Error
  180. security question
  181. SELECT DISTINCT Problem
  182. DBCC commands stability
  183. SQL error 20029
  184. MSDE and Access 2000
  185. which file store startup parameters?
  186. Data/index locks in SQL Server
  187. DTS dilemma
  188. efficiency of query
  189. Indexing Results of Stored Proc (or new table created by one)
  190. multiple deletes with a stored procedure
  191. Database Diagram
  192. Surefire Method to Determine that SQL is running programmatically.
  193. How Do I use an ODBC database in Query Analyzer
  194. alternative way
  195. Linked Server Error Between SQL Server and Oracle
  196. Are text pages deleted when a column is converted to varchar
  197. FILE SIZE IN MODEL
  198. Dynamic Cursor versus Forward Only Cursor gives Poor Performance
  199. Return one row
  200. SQL Statement to generate customer list whose last payment date is jan 04
  201. recording query
  202. Problem with string
  203. Does anyone know the difference in the locking behaviour between sql 2000 and sql 7?
  204. How to copy cube to Excel?
  205. SQL backup job - failed
  206. Logging on SQL Server 2000
  207. Multiple docs open in Query Analyzer
  208. IF Condition in Join??
  209. inconsistent behaviour linked server?
  210. Linked Server Query Problem
  211. App server unable to connect to SQL Server 2000 developer edition on localhost.
  212. Transaction logs
  213. Full-text Indexing
  214. Stumped by a BCP problem
  215. this is driving me nuts - solicit help from the gurus
  216. DTS error
  217. FULL OUTER JOIN
  218. Book suggestions for studying for MCDBA
  219. Incremental output in QA and writing to files
  220. Can't upgrade to SP3 in Win Server 2003
  221. Load balancing and clustering
  222. Update statement performing table lock even though where condition on clustered primary index?
  223. MS SQL 2K server on windows 2K
  224. data synchronisation
  225. Auto created statistics and missing statistics
  226. trigger before delete in firebird or mssql
  227. Execution plan of UDF
  228. primary key autoincrement question.
  229. Helpdesk database statistics crosstab report
  230. SQL Statement for generating expired customer
  231. Advise on Multiple Column Updates
  232. 2 Qs
  233. ADO Recordset's object method Open
  234. "Tracking"
  235. Returning random records and NOT similar (random questions)
  236. Script, Save, Export SQL Database Diagrams
  237. Retrieving an Answer from Mulitple ResultSet statements
  238. Count of Columns <> 0
  239. Type 'adCmdStoredProc' is not declared
  240. Generate insert script
  241. Problem: must detect db changes
  242. SQL Server Agent confusion
  243. Sorry for dbl post but previous post was damaged somehow (WAS SQL Server agent weridness)
  244. SQL Server Agent
  245. Prepared Statement where value IS null or value = :x
  246. selecting x records from table n times according to variable criteria?
  247. Executing a DTS from another DTS...
  248. Using Image data type in a SQL Server 2000 table
  249. Trapping BCP error from SP
  250. newbiw SQL 2K DBA
  251. Common Table Expression?
  252. Problems using xp_smtp_sendmail
  253. Sending email from sql server
  254. About Store Produre
  255. Marrying SQL, XML, web services, grid computing (2 audio programs)
  256. Converting Number to Text
  257. Convert Punctuation to Spaces?
  258. SELECT MAX statement
  259. How to make self-backup log in msde?
  260. output parameter with text data type in stored procedure
  261. Best way to install a database at a remote site
  262. Anyone recently installed SQL Server 2000 Eval version???
  263. Inserting data into tables having triggers...
  264. Doubt in " HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET"
  265. Delete record based on existence of another record in same table?
  266. When denormalizing is essential
  267. Communication link failure...
  268. Help - Recovering a deleted job
  269. SQL 2000 performance
  270. Help with this script!
  271. Update table row by row
  272. Transaction...
  273. No log operation
  274. How to extract data from one database to another.
  275. Select datatype of datetime
  276. What's your compensation for carrying a pager???
  277. Access2K Connection to SQL Server2K
  278. stored procedure denies EXECUTE permission
  279. Value of @@Error after performing update that finds no records?
  280. DECODE?
  281. Counting items and returning values
  282. Query performance with order by clause?
  283. MS-SQL issue with server browsing
  284. Should I split this 175 Million record table?
  285. Retrieving updates made within a transaction?
  286. web content database. Is there a limit?
  287. Select boolean values merged in a text statement
  288. Can't edit table design in Enterprise Manager without dialing in to internet! :(
  289. Microsoft SQL Server 2000 Standard w/ 5 CALs
  290. data loss
  291. Using CHARINDEX vs LIKE in WHERE?
  292. challenging sql queries
  293. DISTINCT QUERY
  294. Runtime build sql in stored procedures with output param Q?
  295. Stripping non-numeric chars from a field string - SQL 2000
  296. DTS for insert/update
  297. info on MAS90 / MAS200 for SQL server
  298. Design to accomodate entity based schema versioning
  299. Why Cluster a Primary Key?
  300. How To Do An Average Of A Count
  301. Assistance please using txt
  302. SQL Error in Application Log File
  303. Issues with LEFT join on four tables
  304. Unknown Token Received
  305. Problem movind a datbase from ACCESS to MS SQL
  306. MSDTC error on Windows 2003
  307. -"Access Denied (Error 5)
  308. Problem with simple Where Clause
  309. pk-fk problems
  310. Procedure Stopping
  311. bcp data to a txt file
  312. Rebuilding indexes
  313. search multipe fields, compounding fields, like, contains...?
  314. Translate sql statement into SQL-92 standards
  315. bcp_moretext & NULLs
  316. i need help please
  317. BCP output with header and trailer
  318. Selecting one greatest number from two columns?
  319. Attaching and Detaching a Database
  320. Help: How to detect inserts, updates, deleted on a table from within C++ application?
  321. outher joins formats
  322. debugging DTS custom task written in C#.NET
  323. Something wrong with "select max" in this query?
  324. Application roles
  325. select statement that returns the column names and keys
  326. i need help please
  327. ODBC Memory Leak
  328. DTS Select using record position
  329. My guess is stored procedures
  330. Avoiding time-outs
  331. Multiple conditions in "IF" statement in T-SQL?
  332. Point-in-time backup of database & filesystem
  333. expanding databases in SQL 6.5
  334. SQL between Problem with dates
  335. Problem is forming Query
  336. how to configure connection pooling
  337. BI tool users - message for u
  338. complex SELECT
  339. calling Stored Procedures from different DBs
  340. SQL Query - Find block of sequential numbers
  341. space used by a table?
  342. Finding affected tables
  343. DTS package
  344. SQL Server Backups
  345. I want to restrict the my clients to access database through EnterPrise Manger Or Quer analyser
  346. Calculated Member uisng a Member Property
  347. strange optimizer
  348. Looking for a reporting tool for sql views
  349. Handling # (temp) table
  350. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  351. Date problems between VB and SQL
  352. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  353. Help ! Dangerous user with SA permissions
  354. sql dinamic
  355. sql server tools
  356. Allowing a user access to only a few tables
  357. how data file and log file grow?
  358. creating / changing owner problem
  359. modifying user security
  360. use column names and not positions when inserting from one table into another
  361. select parameter order
  362. Event driven log backup?
  363. searching for encrypted fields in data columns
  364. System Schema & Documentation
  365. SQL Profiler Hanging
  366. REPLIKACJA SQL2000 BEZ DOMEN
  367. DB Questions
  368. CountrySelector control
  369. Problem selecting count, comparing 2 fields in same table
  370. Make two query in too one
  371. Reference SQL Parser
  372. Restore databases into a new installation of SQL Server
  373. How to write a function that will return true if user is in a certain role?
  374. create an incremental counter in the stored procedure
  375. Set operations (EXCEPT/EXCEPT ALL)
  376. Holidays in SQL Server
  377. linked tables
  378. Creating a Table
  379. auto recompile in sql server
  380. Calling an Oracle Procedure via a DTS
  381. stored procedure to create new database
  382. TempDB tran log growing slowly - yet we are in simple mode!
  383. Image datatype problem?
  384. SQL Agent question
  385. cluster sql server 2000
  386. Is installation secure ?
  387. setting the query time out....
  388. Haversine SQL trouble - Distance between zip codes
  389. Data disappear - SQL server 2000 / ASP interface
  390. Array in Store procedure
  391. Access File/Get Data can't attach to a SQL table.
  392. search the primary key given the table name
  393. MSDE & SQL 2000
  394. Two tables and count
  395. Deleting records in the logfile
  396. Getting Database Stats
  397. Converting Rows into Columns MS SQL 2K
  398. world atlas database
  399. Combining data from differnet Excel sheets
  400. How to fix SQL Server 2000 after machine name & domain change ?
  401. MS SQL Server XML Query Help
  402. SELECT problem...
  403. Tables in Linked Server
  404. Group dates by month
  405. Question : How SQL chooses an index for a process
  406. Correlated Subquery Efficiency
  407. recursive call in stored proc
  408. Filter data in sql reporting services
  409. database logic report
  410. Alter Column Type.
  411. sp_spaceused reports over 40 GB unused for a table
  412. Extra parameters being added onto SP call with ADO?
  413. back everything up in a single file?
  414. LAN SQL set up question
  415. Cristal Reports for OLAP CUBE
  416. test
  417. aba_lockinfo - new version available
  418. wmi access to sql server
  419. SQL Server Import Problem (UInt64 to Int32)
  420. using contains clause
  421. changing object owner syntax
  422. Dynamic Cross-Tab Query too long?
  423. Composite primary key on a table variable?
  424. Using OPENXML
  425. Server failure
  426. SQL Server Interview Questions
  427. ASP, SQL Server and double insert...
  428. Exporting MS SQL Server or Oracle Databases to MySQL
  429. how do I query this?
  430. BCP call to stored procedure - broke during upgrade from SQL 7.0 to 2000
  431. Problem with SQL Statement
  432. How to do an update on existing records?
  433. SQL error
  434. Multithreading?
  435. Parent Child Tables
  436. Slow query execution, SQL Server 2000
  437. Error 208, Missing Stats
  438. 1 row retrned for 3 rows of data
  439. Setting up a Real-Time Data warehouse
  440. concatenate two column.
  441. How to make full-text search accent-insensitive?
  442. test
  443. Problem convert varbinary to float
  444. Sorting via script
  445. Select Distinct - Incorrect result
  446. Stored procedure - user defined function.
  447. Column Formulas
  448. t e s t
  449. test
  450. test
  451. SQLAgent can't up
  452. Return Values from a Crosstab Stored Procedure
  453. Can't import an Access table due to null values.
  454. I/O Congestion Troubleshooting: Memory and Swap File Usage Question
  455. scope_identity()
  456. upgrade from SQL 7.0 to 2000
  457. Contains Predicate and Double Quotes
  458. Query Analyzer Script
  459. PEAR DB 1.6.0 has been released
  460. create linefeed in field
  461. 'Syntax error converting datetime from character string' with sp_executesql
  462. Calling parameterised views from VB
  463. text with ' character
  464. Profiler Performance trace template
  465. Problem with Stored Procedure
  466. computers that connected via dial-up modems
  467. retrieving the the max occurrence of a record
  468. sql connection fail
  469. Script to generate INSERT statements on table
  470. Complex Sql Query
  471. Mail Client...SQL Server and another app. on same machine?
  472. Script to copy entire table
  473. Indexing - Uniqueness vs Highly uplicate
  474. How can the Profiler textdata field be enlarged?
  475. Text file import with DTS
  476. Variable Parameters - which approach.
  477. virtuelle Cubes
  478. Duplicate a row in SP code
  479. FTP Question
  480. Difference between windows locale in remote settings and SQL server
  481. Dynamic field question
  482. ANSI_NULLS and null comparison
  483. Formatting @query results using xp_sendmail
  484. Passing an Array and/or Variable Field Name to an SProc
  485. Transfering tables from one dB to another.
  486. sp_spaceused
  487. sp_spaceused
  488. sp_addextendedproperty versus sysproperties
  489. SQL Join Problem
  490. In(..) and Like xxxx% performance
  491. indentify full-text indexed rows
  492. How to query two MS SQL DB's on the same server inside a Stored Procedure
  493. Records appearing and then disappearing
  494. Inconsistent DTS Error - Help please
  495. Unicode ..
  496. Brick Codes
  497. How do I find the max row size..?
  498. encryption of sql database
  499. Problem with Provider=SQLXMLOLEDB.3.0
  500. Advice needed: Combining multiple Access db's in to 1 SQL db
  501. Copying deleted into temp table in trigger
  502. Help with Recursive Function
  503. Dumb Stored Procedure Question
  504. Create a new User
  505. SP3a + Extended Procedures = not nice (help!)
  506. Farsi Collation
  507. Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
  508. Win2000 OS Access for SQL Server Admin
  509. SQL Server Books Online January 2004 Update
  510. duplicate database
  511. SCHEMA -- 1000 products with different attributes
  512. Help! I can't write this SQL Server query ... can you?
  513. Timeout on running views in Enterprise manager
  514. Embed SQL statement in another SQL statement
  515. Error handling in MSSQL - if error during call remote stored prcedure I need SQL code to continue...
  516. Benchmarking a server
  517. Using Mysysobjects table in Sql Server
  518. remote transaction on SQL Server
  519. PHP with SQL Server
  520. Access <- > SQL Server
  521. SQL 2000 - Row Level Locking
  522. Help needed in Crystal reports
  523. Is it posiable to close the screen
  524. SQL Query - Please Help!!
  525. Usage of e.g. Max(Date) aggregat function
  526. New SQL Server tool
  527. New SQL Server tool
  528. Storing and viewing UTF-8 characters...
  529. It works
  530. Senior Microsoft .NET Programmer/Analyst needed
  531. Large table schema changes
  532. Recursive Query Quesiton - Table Function
  533. Importing into Test Database
  534. Move DTS package to another server
  535. Set Approach instead of Cursor
  536. Test Database Copy
  537. Error returned with no error message
  538. using multiprotocol net library in the system DSN
  539. Long running backups
  540. MySQL between times
  541. Merge Replication error: The schema script '....sch' could not be propagated to the subscriber
  542. Parse Data from a String Field in a SQL Query
  543. SQL Server How to Prevent Locking To Do Read-Only Reports
  544. Quastion about Temp Tables
  545. Copy tables between databases using variables
  546. bcp_exec() Failed
  547. Profiler's TextData column has 'NULL' and longest Durations
  548. Grouping Records & Assigning Sequential Number
  549. Null Foreign Key
  550. Load Balancing