View Full Version : 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
  1. question about retrieval of client process IDs
  2. Update Top 30%
  3. how to drop all keys & indexes
  4. last row
  5. Update all tables in database
  6. Triggers
  7. Disabling primary key
  8. stored procedure result set
  9. last day of previous month
  10. long query alert
  11. changing one column in each row
  12. Access linked to SQL Server - 2 day offset error
  13. FOR SELECT
  14. Embedded select query?
  15. SQL Server makes our server reboot!
  16. Insert into two tables, both with auto increment fields
  17. Sudden xp_send mail error
  18. SQL pieces-parts
  19. Query: How can I get this result?
  20. Adding Identity Column to BIG table
  21. Date/Time select Problem
  22. are nulls bad
  23. Novice question regarding client notifications from a server
  24. Mapping SQL Server Data Types to C DataTypes
  25. Query to get the Domain from the email
  26. script to remove nulls from DB?
  27. Wrong record retrieved after move to SQL Svr
  28. Log shipping wizard doesn't show up in Enterprise Manager
  29. Cretae a view in one DB with a stored procedure from another DB
  30. Sql server-compi question
  31. @local_var really cannot hold table name ?
  32. data types
  33. Which is faster?
  34. Trouble with Update syntax
  35. Conversion Problem
  36. Inserting a select with an additional static field
  37. Correlated Subquery with distinct Record
  38. deadlocks in sql server
  39. Query in a Loop
  40. case-sensitive search in sql 7
  41. SQL Server DB Backup job problem
  42. Log Shipping for replication
  43. Displaying images clarafication
  44. Performance Tuning for Row-by-Row Update Statement
  45. Allow zero length
  46. noob question how to make a mailto function
  47. 3rd party tools for job scheduling
  48. NooB Scripting Question How to use mailto
  49. Date functions
  50. Stored Procedure Across SQL Servers
  51. Using alias in an expression
  52. Spacing problem in SQL Server
  53. Query too slow
  54. Tricky Record Locking Problems
  55. find missing/deleted records?
  56. Book recommendation on performance
  57. Closed transaction keeps running...awaiting command
  58. 1:m database relation "Flattened" for reporting purposes
  59. SQL 7.0 to 2000 upgrade
  60. Performance problems with query
  61. Risks of single MSSQL domain account for mult servers?
  62. sql server 2000
  63. MSDE and SQL Server 2000 design questions...
  64. Mainframe Datatype Scrubbing
  65. Securing mdf file
  66. unable to submit more than 8000 characters with stored procedure
  67. Backup/Restore locks up EM
  68. MSDE and NetUserAdd Error
  69. Analysis Services
  70. Update stmt with an Table alias?
  71. Access vs SQL
  72. Sql 2k Database Log file Full ... How to empty that
  73. Filter Criteria - Temp Table Join or Where clause?
  74. SQL Server Report Generator - beta testers needed
  75. TempDB Disk placement with Log files?
  76. Enterprise Mgr Can Not Sort?
  77. Linking to MS Word
  78. 'Primary' filegroup is full.
  79. Select Max query - please help
  80. Nulls in calculations
  81. Something like MIN(f1, f2)...?
  82. Can table ownership be changed?
  83. Help - how to concatinate strings from multiple rows?
  84. Translate Function?
  85. data dictionary
  86. SQL Server Performance varies by NT account
  87. Sorry: Trying to understand this piece of code
  88. help with sql script
  89. eseguire un dts
  90. update data in a field
  91. Which Raid?
  92. pick list values into a table
  93. multiple values into a table
  94. Recovering from transaction log deletion in 6.5
  95. MSDE
  96. MSDE
  97. MSDE & Web Pages
  98. A question of SP technique...
  99. SQL Mail and SQL Agent Mail @!~$%!%#^$%&^#&#%
  100. memory utilization
  101. export view table into excel
  102. Sintaxis mysql
  103. Is it possible to re-reference a column alias from a select clause in another column of the same select clause?
  104. CPU 100%
  105. "dbuse" fails when database name is larger than 28 characters
  106. xcopy command failed in sql server 2000 as scheduled task
  107. Entry point not found with MS SQL Server
  108. "GO" used in a stored procedure
  109. Exporting to Excel
  110. How do I copy a database
  111. View & SP's for just a few users
  112. row number.
  113. Can not create views, tables etc * URGENT*
  114. Caching UDF
  115. decreasing number of records.. is it important?
  116. MS-SQL Server equivalent to Oracle 9i?
  117. Anything wrong with this query?
  118. Help with TEXTCOPY
  119. Difficult query help
  120. help with nested Query
  121. Difficult query: return recordset from concatenated strings?
  122. Creating New Views on SQL 2000
  123. tempdb log full
  124. Link Pervasive SQL Server - how ?
  125. sql server sizing planning - architecture help
  126. DTS vs Excel numeric conversion
  127. Oracle9i: SQL Exam# 1Z0-007 wanted
  128. SELECT DISTINCT with JOIN
  129. how to break out of a cursor and out of a SP all together
  130. Representation for Deleted Entities: difficult question
  131. Looking for a db schema read/write/synch tool
  132. TSQL to run DBCC rebuild_repair on an MSDE 2000-hosted DB
  133. Database Design Question
  134. ms access query problem
  135. SQL Mail
  136. PK
  137. SQL Server Job Wanted - Philly Metro Area
  138. More on dependecies
  139. DTS Package is dropping trailing spaces
  140. Logging Sql queries
  141. Stored Procedure Syntax
  142. Data Access Laws In the UK
  143. How to Modify a views' SQL source from a program
  144. Scribe Report Generator - beta testers needed
  145. DTS package and Firewall
  146. Locks and "forever runnable" processes
  147. Calculating Hours with Overlapping Times
  148. can't connect to Oracle
  149. uso del top en el mysql
  150. one frontend different type of backends
  151. SELECT DISTINCT
  152. SQL use statistics
  153. Total SQL users?
  154. Alias name for addressing SQL databases
  155. How do I avoid this corelated subquery?
  156. How do i grab a simple list of SQL Server views, tables or sprocs?
  157. SQL and ASP
  158. SQL and ASP
  159. SQL server and ASP
  160. Index Tuning Wizard - headache
  161. SQL SERVER DBA
  162. convert Access DB to MS SQL with dtswiz(command line)
  163. SQL Server 7 switches to Windows Only Auth on Reboot
  164. How to redirect a DTS package and connections
  165. Stored Proc Recompiling over and over
  166. Get message : The query cannot be excuted because some files are missing...
  167. Remote hosted database - SQLServer 2000
  168. DB increased the size
  169. FTP from within T-SQL
  170. Database Wars: Oracle vs SQL Server Lock Escalation
  171. sqlserver access datatype differences
  172. SQL funnies :o)
  173. REQ:how does one run SQL 2000
  174. Q: Analysis Services Cube Design
  175. Schedule Local Package to perform FTP and DB restore
  176. Check null value of long data type
  177. Query help: need at least one row for each value in each of two columns
  178. Get Current Identity(Procedure)
  179. Generate XML file from stored procedure
  180. Cannot make server as Target server or link from Master Server
  181. SQL server installation reboots my machine
  182. Query length
  183. referencing to a function..
  184. Passing error message to ASP.NET
  185. tuning the sort step of execution plan
  186. How to setup default value using GETDATE?
  187. New version of AbaPerls available!
  188. Help loading data from Excel to Analysis Services
  189. using conditional statement in stored prcodure to build select statement
  190. Help with query
  191. Send formated query result by mail
  192. sql server certifcation website wanted
  193. floating point calculation
  194. System catalog tables?
  195. converting datetime int
  196. Disabilitazione trigger [DISABLE TRIGGER]
  197. Update in SQL Server 2000 slow?
  198. Thoughts about the smart way to a task
  199. Coding in standard SQL ?
  200. 1-multiple to string
  201. displaying related data from a table
  202. displaying related data from a table
  203. PRIMARY file group is full
  204. Recursive Query
  205. Update query
  206. UPDATE query problem
  207. Returning database schemas
  208. Can There be a single Index
  209. I inteded to ask a different question
  210. Maximum Date in a group of records
  211. RDBMS Report Generator - beta testers needed
  212. How to ensure data is no longer on disk
  213. Hiding a SP in Access under Query, but retain Execute on SP
  214. Adding comments to TEXT field...
  215. Inserts failed sometimes ...
  216. INSERT ... SELECT PROBLEM
  217. DTS w/dynamic source & query
  218. problem analyzing logs with lumigent's log explorer
  219. test post - ignore
  220. re-indexing job takes more time
  221. Column Count from Stored Procedure
  222. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  223. Data/Transaction log files for two databases have same file name
  224. SS 2000 Backup programatically
  225. Cannot set job alerts on Notifications tab if a non-sysadmin user
  226. About MDF file
  227. Restore puts copy of user tables in master
  228. sister caught with the kid next store 4033
  229. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  230. problema con la funzione except
  231. Round funtion on entire columns in MSSQL?
  232. Cant create database with > 4 GB log
  233. Update multiple records
  234. INSERT ... SELECT PROBLEM
  235. Extended SP Questions
  236. xp_Sendmail does everything but actually sending the message
  237. DTS w/dynamic source & query
  238. What so special about PostgreSQL and other RDBMS?
  239. problem analyzing logs with lumigent's log explorer
  240. test post - ignore
  241. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  242. Export & import DTS Packages
  243. ODBC Connect from MS Access to SQL Server 2000-Viable?
  244. re-indexing job takes more time
  245. Column Count from Stored Procedure
  246. Non trovo il link
  247. Importare dati con bcp in sql server 2000
  248. third party sql tool
  249. Torn page error
  250. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  251. Data/Transaction log files for two databases have same file name
  252. Add Keywords to Query Analyzer's Syntax
  253. SS 2000 Backup programatically
  254. Cannot set job alerts on Notifications tab if a non-sysadmin user
  255. Dirty Read ?
  256. About MDF file
  257. Restore puts copy of user tables in master
  258. Can not install Reporting Services, Help!
  259. Merge Replication + Structure Changes
  260. Compressed Drive Support in Yukon (SQL2005)?
  261. sister caught with the kid next store 4033
  262. Retrieve a list of db roles from within T-SQL????
  263. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  264. Compare 2 DateValues -> maxvalue in transact sql
  265. problema con la funzione except
  266. Data Structure -- It's been a while
  267. Round funtion on entire columns in MSSQL?
  268. Using results of query in a query
  269. Cant create database with > 4 GB log
  270. storage snapshot
  271. FlexGrid in VB
  272. alter identity property of a column to NOT FOR REPLICATION
  273. problem passing UDF scalar result to UDF table function
  274. SQL Server Report Generator - beta testers needed
  275. Update multiple records
  276. Extended SP Questions
  277. xp_Sendmail does everything but actually sending the message
  278. What so special about PostgreSQL and other RDBMS?
  279. Inserting row and scope_identity()
  280. Export & import DTS Packages
  281. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  282. Reverse Wildcard Searches Impossible?
  283. Measure data transfer between replicated servers
  284. ODBC Connect from MS Access to SQL Server 2000-Viable?
  285. Senior DBA Positions in Dallas, Austin, Atlanta.....
  286. SQL Server Alerts...
  287. how to discover either windows group or SQL login
  288. 3 Login failed every second
  289. Non trovo il link
  290. Method Execute of Object - Command Falied(Runtime error-2147217900)
  291. Importare dati con bcp in sql server 2000
  292. third party sql tool
  293. How do I calculate the sum of each number in a string of numbers?
  294. Torn page error
  295. multiquery in a store procedure...
  296. How to find out which field in a table is updated
  297. Help won't open up for Enterprise Manager or Query Analyser
  298. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  299. percent of executed procedure
  300. SQL Server
  301. how to get online/offline status
  302. Add Keywords to Query Analyzer's Syntax
  303. Migrating StarOffice spreadsheet data to SQL Server
  304. SQL user
  305. Dirty Read ?
  306. Importing Big Text fields with <CR><LF> in them
  307. Can not install Reporting Services, Help!
  308. Merge Replication + Structure Changes
  309. Assigning parameters in a function
  310. SQL Server Object Security
  311. Compressed Drive Support in Yukon (SQL2005)?
  312. How to identify fragmented index for rebuild
  313. How to identify fragmented index for rebuild
  314. Retrieve a list of db roles from within T-SQL????
  315. Compare 2 DateValues -> maxvalue in transact sql
  316. Bin Laden Captured - photos and video
  317. divide INT get decimal output
  318. Data Structure -- It's been a while
  319. Using results of query in a query
  320. After copying a record with an SP all textfields has max lenght
  321. Create a view in VBA
  322. DIsk quotas
  323. dumping data from database
  324. storage snapshot
  325. alter identity property of a column to NOT FOR REPLICATION
  326. FlexGrid in VB
  327. problem passing UDF scalar result to UDF table function
  328. SQL Server Report Generator - beta testers needed
  329. sybase driver
  330. Send email notification for Scheduled Job completion
  331. Output to the log file with XP_CMDSHELL
  332. Inserting row and scope_identity()
  333. LINK WITH SQL SERVER
  334. ISNUMERIC and CAST
  335. Reverse Wildcard Searches Impossible?
  336. Sql maint plan not removing .trn files
  337. Measure data transfer between replicated servers
  338. Senior DBA Positions in Dallas, Austin, Atlanta.....
  339. SQL Server Alerts...
  340. User ID limit per database, Msg 15065
  341. how to discover either windows group or SQL login
  342. DB2 ODBC Error using in DTS (MDAC 2.7)
  343. SQL Server - failure to replicate
  344. Dynamic Cross Tab Using Cursors.
  345. 3 Login failed every second
  346. SQL Web Services
  347. Method Execute of Object - Command Falied(Runtime error-2147217900)
  348. Connected to which database
  349. How do I calculate the sum of each number in a string of numbers?
  350. multiquery in a store procedure...
  351. Performance tuning and measure on MSSQL 2000
  352. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  353. How to find out which field in a table is updated
  354. Help won't open up for Enterprise Manager or Query Analyser
  355. Installing SQL Server 2000 Developer on Windows XP Pro
  356. SQL 2000: Inserting multiple rows into a single table
  357. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  358. percent of executed procedure
  359. SQL Server
  360. how to get online/offline status
  361. SQL user
  362. Migrating StarOffice spreadsheet data to SQL Server
  363. Importing Big Text fields with <CR><LF> in them
  364. Open up SQL Server for central server application...
  365. SQL Eliminate Duplicates
  366. reading Transaction Log.
  367. Assigning parameters in a function
  368. Can I carry my existing DB users to a new server and restore???
  369. SQL Server Object Security
  370. How to identify fragmented index for rebuild
  371. Need help
  372. How to identify fragmented index for rebuild
  373. Need Sql statement
  374. Bin Laden Captured - photos and video
  375. Index Performance
  376. divide INT get decimal output
  377. column update function
  378. After copying a record with an SP all textfields has max lenght
  379. DTS from Excel to SQL?
  380. Create a view in VBA
  381. DIsk quotas
  382. Problem When using Recordset paging
  383. dumping data from database
  384. Should SQL concatenation return a null value if one field is null?
  385. Problem: Stored Procedures not completing from Web Application
  386. sybase driver
  387. regarding: Least expensive way to develop SQL 7 or 2000
  388. Least expensive way to develop SQL 7 or 2000 Database on website?
  389. Send email notification for Scheduled Job completion
  390. Sum query
  391. @ local variable makes query slower?
  392. Index is being rebuilt
  393. Count records when RecordSource is a Stored Procedure
  394. Output to the log file with XP_CMDSHELL
  395. LINK WITH SQL SERVER
  396. Unique constraint index
  397. ISNUMERIC and CAST
  398. Sql maint plan not removing .trn files
  399. BackUp Quastions
  400. error in recordsource after converting to sql server 2000
  401. Pre-installed databases?
  402. local system privildges
  403. User ID limit per database, Msg 15065
  404. DB2 ODBC Error using in DTS (MDAC 2.7)
  405. SQL Server - failure to replicate
  406. Dynamic Cross Tab Using Cursors.
  407. SQL Web Services
  408. Connected to which database
  409. Help for best logic
  410. Performance tuning and measure on MSSQL 2000
  411. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  412. Sr. SQL DBA job open in Texas
  413. Installing SQL Server 2000 Developer on Windows XP Pro
  414. SQL 2000: Inserting multiple rows into a single table
  415. Updating statistics
  416. Enterprise manager
  417. Open up SQL Server for central server application...
  418. use of variables - why doesnt htis work
  419. SQL Eliminate Duplicates
  420. Problems with 'sp_helpdb' stored procedure
  421. reading Transaction Log.
  422. Can I carry my existing DB users to a new server and restore???
  423. What is faster? C++ vector sort or sort in database
  424. Need help
  425. Need Sql statement
  426. Index Performance
  427. column update function
  428. DTS from Excel to SQL?
  429. Access Front End and SQL Server 2000 Record Level Access Control
  430. Problem When using Recordset paging
  431. Replication
  432. Executing a reboot command from SQL
  433. Upgrade to Sql 2000 with minimal downtime
  434. Help for Trigger
  435. Should SQL concatenation return a null value if one field is null?
  436. SQL Trigger for trimming String fields
  437. Help: Purge Table Stored Procedure
  438. Problem: Stored Procedures not completing from Web Application
  439. error with linked server
  440. SQL query fails
  441. SQL server reboots my windows 2000 machine
  442. Creating database and table on MS MSQL server
  443. regarding: Least expensive way to develop SQL 7 or 2000
  444. [QUERY] Help...
  445. Least expensive way to develop SQL 7 or 2000 Database on website?
  446. Sum query
  447. SQL daily
  448. Index is being rebuilt
  449. @ local variable makes query slower?
  450. Count records when RecordSource is a Stored Procedure
  451. Replace function and regular expressions
  452. SQL Server Max Record, multiple table join problems
  453. Unique constraint index
  454. BackUp Quastions
  455. License Requirements for MS-SQL 2000
  456. error in recordsource after converting to sql server 2000
  457. local system privildges
  458. Invalid Udate SQL statement DOES NOT cause error... Does anyone know why??
  459. Pre-installed databases?
  460. Help for best logic
  461. Sr. SQL DBA job open in Texas
  462. No of rows conflict in a table
  463. Updating statistics
  464. Enterprise manager
  465. use of variables - why doesnt htis work
  466. Finding out what a user did - help needed
  467. Problems with 'sp_helpdb' stored procedure
  468. What is faster? C++ vector sort or sort in database
  469. Help with Many-to-Many-to-Many Problem
  470. select * from a where (field1fromA, field2fromA) in (1,1)
  471. migrating rows between diferents schemas
  472. Access Front End and SQL Server 2000 Record Level Access Control
  473. MSDE & database moving.
  474. SQL server image data
  475. Sql Scripts to Monitor another SQL Database.
  476. Replication
  477. Executing a reboot command from SQL
  478. Upgrade to Sql 2000 with minimal downtime
  479. Help for Trigger
  480. How can I query a trusted domain (from MS SQL)?
  481. SQL Trigger for trimming String fields
  482. Help: Purge Table Stored Procedure
  483. error with linked server
  484. SQL query fails
  485. SQL server reboots my windows 2000 machine
  486. Creating database and table on MS MSQL server
  487. transaction id mismatch
  488. [QUERY] Help...
  489. SQL daily
  490. Transferring from SQL 6.5 to SQL 2000
  491. Replace function and regular expressions
  492. SQL Server Max Record, multiple table join problems
  493. License Requirements for MS-SQL 2000
  494. Invalid Udate SQL statement DOES NOT cause error... Does anyone know why??
  495. trigger
  496. How to Parse Sentences into Words
  497. Median query with Group by clause
  498. tools for cleaning name and address data?
  499. No of rows conflict in a table
  500. warning re ADO .UpdateBatch method
  501. RAM
  502. security with web-based access
  503. Finding out what a user did - help needed
  504. Primary and linking keys on SQL server tables
  505. View Problem
  506. Unallocated Space anomaly
  507. probably an easy one - 2 agregate functions
  508. Help with Many-to-Many-to-Many Problem
  509. [Q] complex output result again: the end of script was cutoff in the previous posting
  510. [Q] complex output result
  511. select * from a where (field1fromA, field2fromA) in (1,1)
  512. SQL Query- confused with nesting...
  513. Moving a SQL Server 2000 database that is in Standby Mode
  514. migrating rows between diferents schemas
  515. MSDE & database moving.
  516. SQL server image data
  517. Sql Scripts to Monitor another SQL Database.
  518. How can I show decimals after division update
  519. Help in SQL Query - easy
  520. How can I query a trusted domain (from MS SQL)?
  521. transaction id mismatch
  522. Help in SQL query
  523. Transferring from SQL 6.5 to SQL 2000
  524. Max () query problem
  525. BACKUP TABLE(historical)
  526. trigger
  527. How to Parse Sentences into Words
  528. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  529. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  530. tools for cleaning name and address data?
  531. Median query with Group by clause
  532. RAM
  533. warning re ADO .UpdateBatch method
  534. Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
  535. security with web-based access
  536. Make a copy of parts of a ROW, but with a new Key.
  537. Image file, SQL Server, and web.
  538. Member Property
  539. Primary and linking keys on SQL server tables
  540. It is not a real index but exists as statistics only
  541. View Problem
  542. Unallocated Space anomaly
  543. EXEC Inside a cursor iteration problem
  544. domain user or local system account ?
  545. probably an easy one - 2 agregate functions
  546. Alter Table - Change Column Datatype
  547. [Q] complex output result again: the end of script was cutoff in the previous posting
  548. Creating Tables and automatically inserting data-HELP!!
  549. Output parameter from Sproc
  550. [Q] complex output result