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. SQL Server 2000 on AMD
  2. DTCXact transaction in DBCC openTran
  3. selecting the latest date from different columns
  4. Help Trigger
  5. URGENT database security question
  6. Data model for a web messaging application.
  7. Change local variable inside query
  8. transform recordset
  9. Update sql syntex question
  10. Text column slows down select
  11. Average Computation Question
  12. Mapping image pointers to page numbers
  13. See the good, the bad, and the ugly of your SQL Server data with OneClickRevelation(tm)
  14. Update Statistics failed, incorrect set options
  15. Temp DB growing to max available disk space
  16. Manual Log shipping
  17. SQL SERVER SMP configuration
  18. invalid object like view, function etc.
  19. invalid object like view, function etc.
  20. Creating view (transpose records to columns)
  21. Data Replication performance.
  22. saving changes made to database
  23. Transact SQL probklems with variable scope
  24. Book recommendation
  25. tran log reader/viewer
  26. Restoring the master to different drive letters
  27. sorting string
  28. DTS -- SQL Server Data to AS400
  29. Help - Server stops responding to connections, stops accepting connections
  30. run 3 dynamic selects from stored proc
  31. Group by on the text colum throws error
  32. SQL Server Service Account
  33. Query returning duplicate field names
  34. Can SQL Server 2005 Express and SQL Server 2005 be installed on same machine?
  35. Export data from SQL2000 to XML
  36. Backup Disabling Randomly
  37. Table size count
  38. Converting a smallint to an nvarchar
  39. Analsis Manager Parent-Child missing Writeback in Select Advanced Options
  40. How to configure sql server
  41. Firing Triggers from 1 SQL Server to another
  42. Is there a way we can implement business logic by storing it in colums of a table and calling it?
  43. database architecture and table design
  44. Second instance creation tiny wittle problem?
  45. Transposing rows into columns
  46. Stop time duration problem
  47. openrowset drivers msdaora
  48. Create query based on a field that won't be the same value in both tables
  49. 2 sql servers with Access Front-end
  50. Recommended method to obtain SQLDataPath
  51. random row
  52. Authors and Instructors Needed!
  53. Backup transaction logs and replication simultaneously
  54. Stored procedure performance optimization
  55. Another question (IN keyword)
  56. MSSQL acting strange
  57. Need to Change Developers Acct to Windows Authentication
  58. How to find the size of the database dump.
  59. Problem with a foreing key
  60. Follow-up: DTS question
  61. Problem with SQL generated from MS Access
  62. Hanging or lockup issue with SQL Server and Terminal Services 2000 on NT 4 Domain Server
  63. server heartbeat function
  64. Internal SQL Server error when using variable
  65. Changing datatype from char to datetime
  66. log shipping - out of sync
  67. strange performance
  68. SA to Windows Authentication
  69. sql books
  70. DTS global variable question
  71. Database Design
  72. Suggestions on front end development tools
  73. Advise: DTS
  74. Need your help with Microsoft Reporting Services
  75. OUTER JOIN problem
  76. Connecting to Analysis Services using HTTP
  77. Saving text to MS-SQL...
  78. Represent a value list as a table for Outer Join????
  79. Changing Data Format On Select
  80. How to connect to a MSSQL 2000 OLAP Server
  81. Strange SQLCloseCursor Problem
  82. user defined function issue
  83. Variables in SQL Statements
  84. Bulk inserts to Data Warehouse - Best Practices?
  85. SQL Web Administrator calls Visual Studio?
  86. Can't import Access DB into MSDE
  87. Pulling 2 values from 2 textboxes displayed in a third
  88. Showing friendly values in the GUI
  89. XP_SQLMaint
  90. Replace SQL server in multiple server network
  91. Replace SQL server in multiple server network
  92. Need help with query or possible Stored Procedure
  93. CAlling a sp outside a transaction
  94. Linked Server on SQL2000 to DB2 - desperate...
  95. Delete using another table's values
  96. Temporary table problem (maybe)
  97. Microsoft Reporting Service
  98. Front-end tools -- Which is the most productive?
  99. Database server connection
  100. How many records in a table?
  101. Replication: Transactional: Multi Publications, One Subscriber.
  102. Can't change datatype???
  103. How do I change the owner from a table in a database
  104. Timestamp Conversion
  105. Using a Select statment for the name of the field?
  106. Design Question
  107. Mailing Lists
  108. Runtime error data provider or other service provided an efail status
  109. Subform problem with unique-table-property set in access adp
  110. Print the Table Structure
  111. How to print the Table layout
  112. image question
  113. Outsourcinng is being outmoded
  114. Replication as backup
  115. Function that returns highest of two columns?
  116. Synchronization of multiple clients
  117. Removing Tuning Wizard Indexes
  118. Stored procedure to grant all users db_owner
  119. Record Snapshots
  120. convert date to MMDDYYYY
  121. Variable Arg Lists to PreparedStatements
  122. Need help with MS SQL research
  123. [webcast] SQL Server 2005: Integrating SQL, XML, and XQuery
  124. full database backup
  125. Missing Record - Phantom Record
  126. Query could not be processed. Access is forbidden
  127. Using Transaction log to update another database
  128. YUKON Setup Failure
  129. index questions
  130. What is the best way to move data from...
  131. Need help with Stored Procedure
  132. Datetime condition in 'where' - international problem
  133. Extended Stored Procedures DB-Lib Alternative
  134. Choosing DB Edition (Std vs Ent)
  135. DTS to add a field on imported data
  136. Entity Relationship Management Idea
  137. Very long rich text information - datatype?
  138. Remote Sync -- SQL 2000
  139. Optimization advice
  140. DTS Job hangs on 2nd DTS Task
  141. Hide databases in SQL EM from dbo owner
  142. Yukon - will it support sequence object?
  143. DB2 LINKED SERVER
  144. proc argument type array
  145. SQL Server 2000 - how do I change the name?
  146. Problem: mssql locks several records in a specific table, while no one is editing them
  147. Can a new field be added to an existing table.
  148. Anybody used the universal table broswer?
  149. ERROR 1141 on mySQL creating a User on NT 4.0
  150. How to see contents of image column
  151. Table updates -- SQL 2000
  152. Transaction-style Inventory?
  153. SQL Replication
  154. performance problem with linked sybase tables
  155. replicate a database automation
  156. sql batches in vs.net
  157. Report effective permissions for all users?
  158. php integration
  159. SQL Server Components
  160. DBCC PROCCACHE question
  161. OPENROWSET to Access error
  162. ETL library
  163. intermittent openquery error "..The OLE DB provider 'MSDASQL' indicates that the object has no columns.."
  164. Converting Access qrys with logical expressions
  165. Searching question....
  166. Inserting into two tables with one sql statement
  167. Querying single table for multiple summaries - how?
  168. xp_sendmail blocks trigger ?
  169. efficient select
  170. Is a GUID always unique?
  171. Repliation Between 2 Sites
  172. TPC-C Benchmark Kit
  173. Airline Res System Path finder query
  174. Table and Column request as variables error.
  175. JOINs and SUMs Not Giving Expected Results
  176. Capturing events in a DataGrid
  177. Log Shipping Problem/Question.
  178. Need help with query
  179. Weird Cast operator
  180. Attach DB with corrupt .ldf?
  181. Best way to search for all records (Using a Case Statement in a SP)
  182. Transaction Log Rollback
  183. Dell needs a SQL Server DBA/Developer
  184. Sql query with a stringfunction
  185. request data from specified time
  186. Disappearing Data -- SQL 2000
  187. temp db
  188. Installing SQL 7 On Workstation
  189. SQLServer 2000 Icoon is not visible in the SystemTray
  190. Updating system tables
  191. Cluster recovery from node failure
  192. SQL-Query Access by Date
  193. How to create a database on pendrive using MSSQL 7.0??
  194. How to query database with multiple queries
  195. How to generate Calculated Field
  196. simple system table question
  197. connecting to sql server (within windows domain) through linux?
  198. Case Statement & View
  199. most recent output
  200. Need to convert a date and time to a different format
  201. How to version control in SQL 2000?
  202. Slow SQL performance with Maximizer Enterprise 8.0 SQL
  203. Database Design Question
  204. Seperating the results of sp_dbfixedrolepermission by fixedbroles
  205. how to force a commit in a sp
  206. Running total count in stored procedure
  207. Changing the server name and IP address
  208. Row-Level Locking
  209. Accessing Estimated Query Execution Plan (QEP) statisitics
  210. Using two select statements in IF Exists
  211. HELP! Transaction Log Backup!
  212. faulting module
  213. Zombie Transaction in process -2 Blocking other Transactions
  214. [SQL-DMO]The name 'tdb_grabowy1' was not found in the Databases collection.
  215. Help on a query
  216. does MSSQL have the ability to do "named row types?"
  217. How to stop mssql
  218. SQL Query help
  219. Suggestions for HUGE DB Design
  220. Performance tuning for a stored procedure
  221. Fastest way to delete hundreds of table triggers and hundreds of stored procedures?
  222. sp_Rename Problem...
  223. xSQL Object 1.5 released - Faster, Better, more Robust
  224. Using Views
  225. Virtual Cube
  226. SQL Statement Count NULL Values
  227. Pass global variable into query through dts?
  228. Order By in Subquery + UNION
  229. Best way to update database behind firewall?
  230. Why use a backup device vs. backup to disk?
  231. Windows Open System/SQL - Sr Systems Analyst Position in PA
  232. Case Expression within a Stored Proc
  233. Sorry, ...
  234. Function to call function by name given as parameter
  235. Calling stored procedure from a C application
  236. Drop temporary tables whilst connected ?
  237. Update Query question.
  238. Database record disappear
  239. Superior SQL Builder version 1.5 released
  240. Query to get column name with specific value
  241. How to find the number of database transactions for a day
  242. HELP! Incomplete data in SQL Server table.
  243. updates across servers
  244. SQL Server Connection
  245. Subquery in FROM clause
  246. Need help on Create View
  247. Insert statement which uses a return value from an SP as an insert value
  248. sql select
  249. Capture existing table
  250. SQL 2000 tape backup fail
  251. Page vs Row locking...
  252. select and insert in one sp
  253. What fields are used?
  254. Looking for SQL Databases for
  255. Write from MS SQL to MySQL
  256. Tables not always replicating
  257. converting access db to mysql
  258. ROW LEVEL SECURITY
  259. Restoring backup from MSSQL6.5 in SQL Server 2000
  260. slow sql update MS SQL 2000
  261. configuring locks in awe system
  262. dropserver
  263. Wildcard doesn't match using LIKE '%' on a varchar field, wierd!
  264. Script to Export SQL Tables to Access
  265. Special Character
  266. How to force unique entries in a linking table?
  267. replication - use legato / veritas /or SQL's native replication
  268. Unable to create object error in sp_SendSMTPMail
  269. SQL server notification services : Help
  270. SQL and XML
  271. Counting Occurences
  272. Cumulative weeks
  273. Empty a table before using DTS to append records?
  274. Disaster - moving databases
  275. How to get String representation of a Hex number?
  276. help with data transformations with outer join?
  277. help with data transformations with outer join?
  278. SQL Server Identity Field
  279. Simple I think
  280. FoxPro ODBC Link Servers and the Dreaded 7399 Error
  281. Simple/General SQL Question
  282. SQL Server Identity Field
  283. DTS - import flat textfile into two separate tables
  284. SQLXML classes deserializing.... nothing....
  285. Help with Error Message
  286. DTS Excel Import, Transform - how do I use "OR" clause in SQL Query
  287. script to spot OS/SFW/HDW changes on my SQL servers?
  288. Database and Log maintenance
  289. Stop/Start MSDE Process
  290. SELECT query help - Zero padding
  291. SQL Server and Clipper/dBase
  292. OUTER JOIN with multiple tables and a plus sign?
  293. SQL Server 2000 & MS SP2
  294. auto-number/Identity column
  295. Clean up old SQL Server logins
  296. BCP Order on SQL Server
  297. SQLExecute takes 100% CPU usage
  298. problem with re adding a login
  299. Question on database/table priviledges with sql server
  300. How to view triggers in SQL server
  301. Secure Replication
  302. call a Oracle stored proc in SQL SERVER
  303. phone book lookup query
  304. Running Scripts
  305. ntext and AppendChunk in ASP
  306. user defined fields best design
  307. In SQLServer SI in ORACLE NO
  308. Reset msde sa password
  309. Any structure on Sql Server like WITH ... SELECT structure on DB2
  310. Error catch in SQL
  311. problem with timeouts
  312. Proper table structure and SQL Server limits
  313. Application times out while doing the updates
  314. Showing Records where count(*) is zero (in a stored proc)
  315. UMS.DLL failure
  316. Isql Command line parameters
  317. import dmp into SQL Server
  318. join or subselect ???
  319. detach database, attach database without log file
  320. General network error
  321. sql statement help
  322. Math function
  323. Can Transactional Replication affect Publishing Server?
  324. Enterprise Manager - slow updates when editing tables
  325. loooong columnnames
  326. Query value in between two columns
  327. Real experiences with 64 bit SQL Server
  328. Create Temp talbe
  329. Select .... where the Item.ID is in this array?
  330. What resources does truncate table use
  331. a player team tables design?
  332. Calling All Dynamic SQL Gods!
  333. deleted my database log file, can't reattach
  334. aliasing two columns in SQL
  335. can not access clustering SQL Server after relocation
  336. Query Help
  337. Best DataType for content system
  338. What do they need to know? - SQL Server
  339. Sorting so 0 is at the bottom
  340. SQL Server Data Types for Local Variables
  341. Cursor Based SQL?
  342. SQL Server import speeds
  343. tuningproblem : materialized table instead of view
  344. Query help needed (JOIN)
  345. MU ONLINE
  346. Logging into Microsoft Logfiles
  347. Compare like data
  348. granting permission to create view
  349. Identifying Connection
  350. Migrating large amounts of data from SQL Server 7.0 to 2000
  351. difficult select distinct query
  352. SQL Server 2000 Table Data Types
  353. ActiveX VBScript problem
  354. Changind date formats
  355. Tansaction/locking MSSQL2000
  356. SQL 2005 Express decided to fight SQL Server 7 ...
  357. msde
  358. Creating tables within my application.
  359. Move TempDB Database off of the SAN
  360. Password protecting XO Profession Control Panel
  361. Updating SQLServer db with VBA
  362. sql question - returning multiple rows as one record
  363. Fix my SQL "WHERE" Statement!!
  364. show tables
  365. logshipping setup with two standby db servers.
  366. Fail over - DNS change
  367. Possible to parse a column in a Select statement?
  368. MMC SQL Server
  369. Help with Trace
  370. Acessing SQL Server over the web with shared IP
  371. repair torn page?
  372. SQL Mail: Outlook
  373. MS SQL 2000 and Windows 2003 Cluster
  374. Delete Records From a Table Using Records in Another Table.
  375. Design flow suggestions needed
  376. More Info: Stored Procedure Security Question
  377. Stored Procedure Security Question
  378. Inflated number of records returned when adding bit field criteria
  379. TSQL Perplexity
  380. Decrypt credit card number for Reporting Services Report
  381. URL Parameters
  382. Partial searches over a lot of fields
  383. How to compare two databases using their DDLs?
  384. Geting event from ActiveX into database
  385. Creating UDT from another UDT
  386. WITH GRANT OPTION
  387. Divide by zero error trapping
  388. New Software 04.08.19
  389. Ignore Error in SP
  390. MS SQL Server Merge Replication
  391. sp_change_secondary_role problems
  392. How to concatenate multiple rows into one field?
  393. Updating more than 10000 records SQL Server 2000
  394. Weird issue on client laptop
  395. [?]Restore and Backup problem
  396. Looking for very good SQL Server DTS books
  397. Looking for very good SQL Server DTS books
  398. Looking for very good SQL Server DTS books
  399. General questions
  400. Storing variables from a user-defined function
  401. Starter question
  402. NON DOMAIN AND DOMAIN CONNECTION
  403. Conversion of Access application to SQL Server
  404. Range query
  405. ON DOMAIN AND NOT ON DOMAIN
  406. Versioning
  407. Using SQL server to process the data
  408. Century date conversions
  409. Tidying up of sproc
  410. Automatically create ODBC connections
  411. memory
  412. Derived Columns in one to many relationships
  413. Log shipping role change
  414. Problem creating indexed views with linked servers
  415. Selecting ONLY records from one table having ALL data contained in other table (GROUP BY?)
  416. Need help with designing a query
  417. Bulk insert into views that select from table on remote server
  418. User Defined Function: Convert String value of Table to Table Object
  419. speeding up Dynamic SP
  420. row-by-row process
  421. Check SQL Database offline
  422. Help with more Advanced functions
  423. DB Growth Issue
  424. Return two rows from one rows data
  425. Storing all stored procedures in one database to minimize different connection strings
  426. SQL aggregate fuction and GROUP BY
  427. sintassi per Creare un file .cub a partire da un cubo mssql
  428. track all changes
  429. Convert table using DTS
  430. help with linked server on sql2000
  431. copy two table
  432. Parametrizar nombre de BD (Espaņol)
  433. Joins versus relationships
  434. Problem with FILENAME as @variable
  435. compact
  436. upgrading hard drives, best way to back up and restore SQL
  437. Drop Index on System Tables
  438. Is there such a thing as too many relationship?
  439. permissions with sql server tables
  440. performance question
  441. One column is nullable on the composite key
  442. SQL Server table changes log
  443. Less than, equal to Operator question
  444. Less than, equal to Operator question
  445. SP waits for a delete trigger?
  446. use db-lib to update database records
  447. iODBC vs unixODBC ?
  448. How to catch an exception?
  449. NULL and MAX Query
  450. numbering a query
  451. SQL Query Help-- Order By Clause
  452. SQL Licenses
  453. ADO client disconnects after running a long query
  454. Problem With TSQL Subscription
  455. Count if Conditions Met
  456. Generating Scripts to Populate Tables
  457. DTS document or ebook
  458. more efficient - exists or in
  459. SQL Join Statement problem
  460. Giving users specific DDL permissions
  461. Permissions for dropping & creating triggers & indexes
  462. Open stored in Hexadecimal
  463. TCP/IP Connectivity
  464. Local table and OpenQuery
  465. Convert a Unicode Database into a non-unicode database
  466. Drop Primary key constraint of (#) Hash
  467. altering dynamically a set data type
  468. Merge replication and spids left behind
  469. TSQL command to call *.sql files
  470. localization and sqlserver
  471. SQL matching two multiple valued strings
  472. Is it wrong to allow user initiated DDL commands to facilitate an extensible schema
  473. Update Trigger - Update Query
  474. DB shrink problem
  475. How to copy table from oracle database to sqlserver database ?
  476. Why it is prohibited in UDF?
  477. Linked Server from SQL-Server 2000 to Oracle 8.1.7
  478. stored procedure
  479. sql
  480. Importing .prt files to SQL
  481. Time Stamp
  482. Unique values between two tables.
  483. Triggers running slow (Update Trigger)
  484. Fill stops /timeouts
  485. network packet size
  486. order of recursion in stored procedure
  487. SqlServer 2000 Enterprise Manager - Major Bug?
  488. Please help with this tough SQL query
  489. Finding out how many times a table is accessed
  490. Uniqueidentifier causing strange execution plan
  491. How Two JOINS from one table
  492. Merge WAN Database (Best way to add 1 new field)
  493. SQL-2000 Stored procesure or function
  494. "Dynamic" sorting inside a procedure
  495. Working wth XML
  496. Fine tuning this sql-query. help!
  497. Hibernate
  498. need a JDBC driver
  499. @@TRANCOUNT difference between SQL 7 and SQL 2000 in trigger
  500. CA issues million dollar challenge to open source community
  501. Last row in select question
  502. Need help to get this query up and running.
  503. what is this erroer Message ?
  504. xp_cmdshell resulted in "access is denied"
  505. ASP returning null sized field from MS SQL database
  506. Is it necessary to order again?
  507. Triggers from one MSDE to another using DTC
  508. One more solution for a pagination
  509. SQL select statement error
  510. Blocking
  511. "Query is too Complex"
  512. Delete help
  513. Return records through a linked server that uses ODBC data source
  514. Scalability problem With .Net and Sqlserver
  515. Inserting / Updating LongText Field using WriteText?
  516. Passing Temp Table Values into a UDF
  517. Performance Tuning UPDATE Statement
  518. Disregard some parameters
  519. Uploading SQL Server database to ISP
  520. SQL mail issues
  521. question for the 'senior' people
  522. Excel automation
  523. Automatic backup of MSDE database.
  524. Japanese words
  525. Could not allocate space for .. error
  526. SQL Server invoking batch file
  527. DXReport - Generator de rapoarte pentru Microsoft SQL Server 2000
  528. collation issue
  529. (Revised)Database Design question, Header with two detail.. pls help
  530. cryptoAPI
  531. Database Design question, Header with two detail.. pls help
  532. Great new application
  533. how to preserve users when restoring a database
  534. Identifying Unused Tables
  535. Query Question
  536. DTS Import Wizard fails
  537. Does SQL Server support XML Functions
  538. user table
  539. Slow procedure using view
  540. update deadlock question
  541. moving a heap to another filegroup
  542. Prototype for a web application
  543. Memory Leak. SQL Server sp3a, VB and MDAC 2.8
  544. sp_adduser and the old question of why??
  545. Install of SQL Server 2000 dev edition over MSDE. Any advice appreciated.
  546. is it possible to use a simple ODBC config on a unix client to connect to MS-SQL server?
  547. How to insert NULL char values in SQLSERVER with a SQL sentence?
  548. A Range Query Optimization
  549. Sql Query Help!
  550. DTS Yukon beta 2 Library not registered