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