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