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