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. Replication
  2. ORDER BY Bug in SQL Server?
  3. Spam emails from Pinnacle
  4. SQL server access through VPN
  5. sql script
  6. How to join two tables
  7. SQL Server Product
  8. Intercept SQL Queries sent to DB
  9. SQL 2000 to Oracle 9i Migration Problems
  10. Complicated (at least to me) insert
  11. Determine who entered data?
  12. help with table data in Russian (cyrillic) and other languages
  13. Is there a way to track View usage?
  14. table names as keys?
  15. Print report from SQL 2000
  16. Plz, what is the most "correct" method
  17. Print report from SQL 2000
  18. Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000
  19. Can't kill backup process
  20. COUNT depending on data
  21. SELECT...LIKE: How to get '100' string whithout getting '45,100'
  22. Auto Printing from SQL using VB6 program
  23. sleep for n seconds
  24. export alll tables and data into a ms access file?
  25. #Temp Tables
  26. Explorer?
  27. How to verify the agent is up on a remote host?
  28. Here's the Problem Again With Sample Data
  29. BCP help
  30. Script, Compare and Synchronize SQL Server Objects
  31. iif and case statements
  32. Dynamic SQL
  33. Strange behaviour in ORDER BY Statement
  34. Funny network behaviour
  35. restore a SQL2000 db to a SQL7.0 server
  36. intermittent performance problems while insertig records
  37. SQL Mail Probelms
  38. VERY strange problem with DB Instance
  39. Importing data from SQL to Magic 75?
  40. SQL JOIN SYNTAX
  41. Postcode radius searching
  42. Left Anti Semi Join
  43. Limits to length of Stored Proc
  44. someone drop a database....
  45. Error while executing nested DTS Packages...
  46. SQLDMO.BulkCopy
  47. Security problems when hosting an SQL DB on a fixed IP SBS 2000 Server
  48. Expressing Values as Percentages
  49. Access / SQL Query issue
  50. SQL Query vs MS Access
  51. Runaway log files
  52. Problem creating FOREIGN key
  53. Method to insert all record from Access table to SQL server one
  54. Restoring logs to a database
  55. Advance ORDER BY
  56. SQL Help Needed
  57. Installing SQL Server 2000 Personal Edition on Windows XP SP1
  58. How to migrate from MSDE to MSSQL
  59. How to detect if column data changed and know prev. and new value
  60. Critical Patch KB824105 and SQL Failure
  61. Tutorial; Accessing MS SQL Database using C++!
  62. Foreign Keys between databases
  63. Simple query
  64. getting my inner join to work
  65. System account for MSSQLSERVER service in SQL Server 6.5
  66. Win2000 Platform??
  67. Cumulative wait time on server replies ???
  68. How to get Full-Text to not ingore special characters
  69. One question
  70. log all queries
  71. Instr() Equivalent in SQL Server
  72. INSERT INTO - Data is not inserted
  73. SQLDMO Installation
  74. Wizards unavailble
  75. "Waiting for Buffer Latch" Error
  76. NCHAR, NVARCHAR and NTEXT through JDBC-ODBC bridge
  77. Id (indentity) is increments on faults.
  78. Security Question
  79. How to do the following sql query
  80. Converting datetime to integer and back
  81. Failing to create relationship (SQL Server claims table lacks PK for some reason ?)
  82. Documentation to get started
  83. Please help -- So stuck now -- Cant connect to sql from external source
  84. Linked server using msdaora.
  85. Help: ADO with Unix and Oracle
  86. Backup to Flash Drive
  87. cross tab??
  88. Table not optimized or what ?
  89. Is there a SQL Server API to flush all buffers to disk?
  90. NULL to Zero
  91. DTS customization
  92. DataReader is blocking my tables
  93. INSERT INTO - Data is not inserted - Using #temp table to populate actual table
  94. programtically capture query runtime
  95. Import PARADOX Problems
  96. Trying to recover physical disk space.
  97. SQL
  98. mysql and ASP
  99. Transactional Replication
  100. Declaring USER_NAME() as SQL Variable
  101. DTS Trimming My Data
  102. error finding in SQL server
  103. TimeOut Expired
  104. composite primary key
  105. query??
  106. SQL Server 2000 and Transaction Log Error - more info
  107. SQL Server 2000 and Transaction Log Error
  108. SQL Query
  109. Server install script
  110. SQL Problem
  111. Copy Database on same machine
  112. Executing a stored proc on another server from a Scheduled task
  113. Maintenance Wizard
  114. System DSNs, SQL and regedit
  115. Long table locks
  116. What significance do Filegroups have on Indexes
  117. MS SQL Issues
  118. control over select output results
  119. pass a value
  120. data base design
  121. INSERT UPDATE Trigger Question
  122. filter data from multiple tables crashes app!
  123. "W32_SQLEXP_Worm_Propagation"?
  124. Finding SQL-servers in a network
  125. outer join and indexes
  126. Character set translation / tp performance
  127. Transaction logs size not increasing
  128. Starting SQL Server 7 causes hundreds of threads
  129. Unexpected SQL syntax error!
  130. Working around a bad vendor
  131. subsum
  132. Transaction Log
  133. Execution plan
  134. Covering index
  135. Indexes
  136. TSQL Questions
  137. analysis serices, cubes and access
  138. Silly question
  139. question
  140. OLEDB stored proc question
  141. Large data warehouse handled bei SQL server?
  142. Adding a time stamp to the records
  143. SP returning a table -- ?
  144. partially update webpage
  145. SP_TABLE_VALIDATION
  146. Indentity Insert
  147. Need help with query
  148. String or binary data would be truncated
  149. SQL 2000 install anomaly
  150. MDAC 2.8 on Win95
  151. Formula column.
  152. Calling a DLL using Javascript?
  153. Checking for Primary Key Dependencies
  154. More date format grief
  155. Can S2K use >2gb mem on enterpise edition?
  156. Querying for calendar, grouped by hour?
  157. Monitor data per session - available?
  158. Problem with writting a Report (SQL slow running)
  159. Problem with slow running SQL
  160. VarChar Problem
  161. List when Changes occur
  162. Recordset's Order and Database's Physical Order?
  163. Re-try count of Replication
  164. Date/Time overlaps - urgent.
  165. Transaction on stored precedures
  166. Choosing values for primary keys
  167. Using many to many tables
  168. can not retrive @@identity value
  169. Updating records from db2
  170. Restoring a database only from MDF and Log file
  171. DTS - from table to xml file
  172. Triggers - It cannot be this difficult
  173. replication and log shipping
  174. query differences Query analyzer vs php-file?
  175. ALTER table command
  176. Restore database to a certain point of time.
  177. Adding new columns to all tables using a script
  178. Java variable for db not found
  179. Multiple ids in a field
  180. Obtain contents of stored procedures
  181. ORDER BY columns in SELECT list?
  182. The following prints out "0" - SQL procedure and use of the "charindex" function.
  183. xp_sendmail failed with mail error 0x80004005
  184. Extension- Urgent Help Required - Recovery
  185. Urgent Help Required - Recovery
  186. SQL Statement help (GROUP BY)
  187. column type
  188. Replace-type function for Text datatype
  189. Help with SQL Update Query -- Not sure how to approach this situation
  190. Installation of SP3 on an instance of SQL Server 2000
  191. fabricated hierarchical recordset
  192. Drop all table
  193. Calling Executables from SQL Server and getting return value.
  194. Another database transfer question
  195. Headaches moving an SQL2K database between servers
  196. University Of Washington News
  197. Unique Index for two columns in a table
  198. Row cannot be located for updating
  199. export data from postgresql on linux to ms-sqlserver 2000 on windows
  200. SQL Server Installation Problems - Pls Help
  201. Stored procedure to a script
  202. Scheduling a job containing a DTS package on Sql server 2000
  203. Need help on Performance Monitoring
  204. determining what are "system" objects in sp_help or system tables
  205. DTS Package Schedule
  206. Linked server SQL to DB2
  207. How to backup/restore the server list in Enterprise Manager
  208. Export table to dbf file
  209. Help with query required...
  210. Storing Date in SQLServer
  211. Outsourced DBA?
  212. Trapping Errors in Stored Procedure
  213. SQL vs Btrieve
  214. Stored Procedures/ table permissions
  215. Using an Identity Field as Primary Key
  216. Change SQL Server registration?
  217. Looking for db replication tool
  218. Very, very slow database - Mystified
  219. AIX Server Client Software
  220. AIX Client Software
  221. Question about MDB upsizing to SQL Server
  222. Creating a heirarchical output from SQL statement
  223. Timeout issue when connection to SQL Server in Wireless environment
  224. Web based reporting - suggestions needed
  225. Uploading data SQL - next problem
  226. Generating overnight data vs Live - suggestions needed.
  227. Problem with uploading data SQL
  228. Using Trigger to populate another table
  229. Why wouldn't this work?
  230. add and subract time to a date
  231. Use getdate function in a own Function
  232. Help with Deadlock
  233. Giorni della settimana
  234. Converting hexadecimal String Values to int in SQL Server.
  235. Getting 0 padded values in the columns.
  236. Can't Use SQL Server with Firewall
  237. How to provide security to Stored Procedures
  238. nubee sql question.
  239. I am struggling through views
  240. Sony laptop with AMD processor - Cannot install SQL
  241. Random Rows
  242. opening cursor on result set from stored proc
  243. DTSRUN: To multi-tier or not to multi-tier. that is the question...
  244. PATINDEX and '[' character
  245. Converting Oracle SQL to MS-SQLServer SQL
  246. here is my search sp!
  247. Combobox
  248. Installing MS sql server 2000 on win 2003 server
  249. Replication - Changes to Server database's impact to local database
  250. stored procedure make string from table field
  251. SQL Question
  252. Copying data from SQL2000 to DB2 8.1
  253. Implementing CRC 16 in SQL Server.
  254. Stored procedure
  255. System tables
  256. Local or global variable in an interaction session of the SQL analyzer
  257. ORACLE BEFORE INSERT EQUIVALENT IN SQL SERVER
  258. Unable to ALTER a temporary table in TSQL
  259. creating an existing db schema baseline
  260. Mind bender: Hierarchy/Many to Many/Temporal data
  261. Is It possible to disable drop database for sa or sysadmin also ?
  262. MS Access and SQL issue
  263. Treatment of Special Characters
  264. SQL 2000 desktop
  265. Upgrading from Sybase Sql Anywhere 5.5.04 to SQL Server 2000
  266. SQL Server Space
  267. SQLAgent can't up
  268. DB Maintenance Plan - single user mode
  269. sql sub query question with count
  270. Need a function
  271. Table Scans - more rows brought back than in table
  272. Server Configuration Advice Requested
  273. SQL eqivalent to VB FIX or INT?
  274. Query Analyser 2000 vs 7.0
  275. Altering column fields with a Stored Procedure
  276. script to combine multiple rows into a single row
  277. How do you lock table (or view) fields from editing???
  278. Index name conflict
  279. Writing to a text file from a database query.
  280. How would you execute sp_changeobjectowner stored procedure using sqldmo object
  281. Quick question: Exporting data
  282. RIGHT OUTER JOIN?
  283. Calculations in views
  284. What is the xx_log.LDF file do?
  285. computer name
  286. single user mode..
  287. SQL7 Desktop
  288. how can i to get the trigger sentence?
  289. ODBC connections.
  290. How can I find out who is running dangerous queries
  291. A stored proc to search all Procs, Views, Triggers and functions
  292. How can I find out who is running dangerous queries
  293. SQL Server Runtime Licence
  294. Stored Procedure into a Cursor
  295. Using a "dynamic top" statement with a cursor
  296. How do you log on as SA????
  297. MS SQL 6.5 Error 3403
  298. SQL Server backup error
  299. use ADO/html in SQL 2000
  300. MSDE 2000 Administration tool
  301. How do I copy data from similar tables knowing unique ID fields
  302. complex Join / display issue
  303. Advanced Enterprise Database Planning/Design Books
  304. sorting Conundrum
  305. Legato backups.
  306. How to Concatenate Strings That Have Trailing Spaces?
  307. problem with stored procedure and tablename parameter
  308. SQL Server Replication
  309. help me! read text file in sql
  310. database design question
  311. Norton Internet Security & SQL Server
  312. Fastest way of updating a row
  313. Default connection in Access to SQL server
  314. Tough Problem, need help
  315. Question about getting the latest identity field in a specific table
  316. rollback segment?
  317. a resourse good for problems replication in sql server 2000
  318. convert a btrieve file to a sql server file
  319. Log
  320. How can i take backup of logfile of one specific database?
  321. Executing Multi-lines SQL Scripts From Command-line
  322. Generating various statistics from data in MSSQL7
  323. SQl 7.0 issue while attaching a database
  324. Employee Suggestions workflow template
  325. Weigh resultset
  326. using ISQLW to call a stored proc that needs a parameter
  327. Performance question
  328. Update problem
  329. Need help with collations
  330. Foreign key relationship
  331. Identity Seed
  332. DTS/Async Stored procedure/Import huge data
  333. Good book about MS-SQL replication...
  334. Access2K front end to SQL SVR 2K -- users cannot see forms???
  335. Database design question
  336. database suspect
  337. SQL server stored procedure question
  338. Scripting text, image columns
  339. SQL 7 job question
  340. client database
  341. Change collation in tempdb
  342. Help on Oracle RDB Migration to SQL Server.
  343. Need to create case sensitive Uniqiue Indexes
  344. Err. 823 Torn Page Detected
  345. Double space replaced with single space by dbms ??!
  346. Table Structure in XML
  347. Connection Problems with Data Analyzer
  348. unique keys
  349. Why isn't table updatable????
  350. SQL Debugging
  351. finding active users from sysprocesses
  352. MSDE login problem
  353. how to group/list top 3 of each category w/o using Union?
  354. Help with a query
  355. schedule problem
  356. Inner join to lookup values twice?
  357. Update order
  358. test papers on SQL DB
  359. Problem with rollback trigger
  360. How to move data files
  361. database comparison
  362. Converting Rows to Columns in SQL7
  363. The TIMESTAMP data type
  364. Errore su transazione con trigger??
  365. Is it possible to "disable" all restrictions on a Ms sql DB?
  366. Diff. performance in Query Analyzer than when using stored procedure
  367. SQL UPDATE Conditionally
  368. Read Oracle Sequeneces into MSSQL Table
  369. SQL server 2000 installation problem on Windows 2000 Professional
  370. "Order by" error running DBCC DBREINDEX
  371. How can I debug Stored Procedure?
  372. Change Object Owner to dbo
  373. Optional parameter on joined field which could be null?!
  374. Database level change
  375. SQL statement question
  376. Need answer to SQL question
  377. query problem
  378. MetaData
  379. sql query
  380. Standby Server
  381. Microsoft SQL server 2000 can't stand up after change administrator password?!?!
  382. SQL Server 2000 & Active Directory: Problems querying
  383. MSDN's Estimating the Size of a Table
  384. Replication problems
  385. running script
  386. What is MVP - SQL Server
  387. Add IDENTITY column in runtime in a View...
  388. published paper for db performance strategies?
  389. ms-sql to sapdb
  390. DB Ezine ?
  391. Swap column position
  392. Script with descriptions
  393. drop not null
  394. Method for compressing varchar/nvarchar columns?
  395. One column
  396. retrieve records affected count from ADO?
  397. secure jdbc and mssql
  398. SQL backup (Network)
  399. ODBC statement hangs on connection broken with sqlserver
  400. Tracing Stored Procedure (SP) Usage
  401. Archive data suggestion
  402. Table design stratagem??
  403. SQL statement help please
  404. Close unattended multi-user applications automatically after idle time
  405. Restoring Database From External Application
  406. Finding the filegroups associatted with a table in T-SQL
  407. exporting from SQL to an Outlook group or Dist List?
  408. UDF starting with fn_...
  409. Deleteing duplicate records from my table
  410. Sub query message
  411. Using udl in the connection for a linked table in Access from sql server
  412. NULLIF or CASE - Decode
  413. QUERY Exceeding variable max length
  414. Error -239 with IMPROMPTU 6.0 and SQLSERVER 2000 using User Defined Functions (UDF)
  415. how to query this table into the result like this?
  416. table variables and update statements
  417. ntext field from profiler
  418. Duplicate full-text catalog population schedule?
  419. How can I insert a column using a script (instead of appending)?
  420. Optional values in a Stored Proc
  421. Accessing SQL Server 2000 via UNIX
  422. DTS Question
  423. RETURN statement odd behavior?
  424. Update trigger on Linked Server View
  425. Job skips certain queries?
  426. Merge Replication Conflict Problem
  427. proc hangs on web but executes in query analyzer
  428. When I compare two string in Unicode format.
  429. Strange view results
  430. mssql server
  431. semaphore timeout
  432. Why can't I connect to the databases??? ahhhh!!
  433. Can a DTS package be scripted or transferred to another server?
  434. autoCode Beta Programme for MS SQL Server
  435. Copy of SQLServer software
  436. SQL Aggregation Poser
  437. Query In Error?
  438. How can I administer SQL Database on remote Web Server
  439. how to creeat a trigget witch will run DTS
  440. How to Installing MSDE in win2K pro
  441. What's the equivalen function of StrConv ([FirstName] , 3 ) in ACCESS in Sql Server 2000?
  442. Need help with SQL statement!
  443. Microsoft Course 2073?
  444. Howto use joins instead of subqueries?
  445. Temp Tables Vs Temp variables
  446. query/read database size?
  447. Delete a file from the Server
  448. Inserting Text into table replaces apostrophes with ?
  449. Problems with JDBC
  450. Query on 2 bases
  451. Presenting UTF-8 encoded data in an e-mail with ISO encoding
  452. How to restore a log? Now we get an error
  453. SQL Server Full-Text Replacement
  454. How to keep the DB password saved for a MS SQL Server DSN??
  455. dts copy text to table only
  456. SQL-2000 GUI
  457. rO: ¹ï§Ü¤£´º®ð rO:
  458. Inter-Database References
  459. How to create Cube
  460. Comparing queries for flagging conflicts
  461. ALTER Table query
  462. NOT problem. this should be easy
  463. speeding up SQL query time
  464. sql size vs. access size
  465. DTS execution from client machine fails connecting to Oracle
  466. Merge the results of two queries
  467. YYYY-MM-DD not working in UK
  468. Index Tuning Wizard
  469. Total spaceused and total allocated
  470. Restore Database daily without SP's
  471. Linked Tables - After Path Updated Can't Add Records
  472. Updating SQL Server from mySQL
  473. How to design "product kits"
  474. New MySQL Turbo Manager
  475. Null Date Values and order by
  476. Updating the database
  477. incomplete processing of T-SQL script
  478. incomplete processing of T-SQL script
  479. One Command Keeps Causing "'tempdb' is full" Error
  480. Searching character data using like
  481. Deadlocks and use of nolock
  482. SP3a installation- Cannot find setupsql.exe
  483. Moving Data tables between SQL Servers
  484. Database alias name
  485. Linking CACHE' dbms
  486. How To Run SQL Script
  487. Like '' & '' & ''
  488. how to write (post) to a url
  489. Visual Basic 6.0 connect to SQL Server 2000
  490. problem with join
  491. Stored procedure rollback
  492. Stopping Replication before failover
  493. SQL Server Hardware Setup
  494. Automating installation of ODBC data source
  495. Switch to another user
  496. DTS - From FTP .txt file to SQL Server database table
  497. DTS - From FTP .txt file to SQL Server database table
  498. log file for database 'tempdb' is full
  499. Full-text search for Japanese characters
  500. Create a copy of a table in sql server
  501. Indexes on Bulk Insert data
  502. do my users need a copy of access
  503. what is equivalent of format(date) function of MS Access in MS Sql Server 2000
  504. DTS transfert AS400 --> SQL Server 2000
  505. Question about data import in MS-SQL server
  506. Problem of MS SQL ----ntwdblib.lib NOT found
  507. sp_spaceused - too much unused space
  508. Window.Open IIS
  509. ms access query help
  510. Insert Query with stored procedure
  511. Not clear about this query
  512. Extract "GroupName" from "sp_helpuser"
  513. Several SQL questions
  514. Windows XP and SQL Server Developer Edition
  515. SQL and MSMQ
  516. Two articles on error handling
  517. Loop thru a SQL Table in stored proc?
  518. Primary key not set
  519. One to Many Join causes Duplicates
  520. Copy column of data into another column in the same table
  521. Writing functions in SQL Server
  522. Updatable Cursors
  523. Trouble with update trigger modifying table which fired trigger
  524. Tabella Elenco Comuni
  525. SQL Server 2000 Client Tools
  526. question on locks
  527. SA Login failure
  528. database backup
  529. A Game Company in Trouble
  530. Hot backup in SIMPLE mode
  531. DTS text file export missing records
  532. Fliegroups and Primary Keys
  533. xp_cmdshell and BLAT
  534. Help with data transfer
  535. inheritance advice in a database...
  536. SQL Online Backup...
  537. Yukon
  538. Need help with email address management software
  539. binary varbinary question
  540. Multipurpose Foreign Key
  541. ASP, SQL, long text data problems...
  542. Variables in the FROM (table name) clause
  543. How to call a stored procedure in a scheduled job
  544. index corruption issues
  545. Pretending to restore
  546. Using column number inplace of column name in SQL Select statement
  547. SQL Server Enterprise Manager could not start the service 'MSDTC'
  548. DTS performance
  549. How ROUND?
  550. Restricted Data Type Attribute Violation - hel-lo?