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