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