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