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