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