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