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