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. Cannot connect to Server through Visual Studio .NET and Query Analyzer
  2. Need help with Avg and decimal
  3. Calling sp_helptext from ASPNET
  4. Optimal configuration for report generator
  5. Solution to: Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server
  6. SP3a and strong password problem
  7. Need help with count
  8. Continuation of long SQL statement syntax
  9. Selecting records where multiple foreign keys are a certain value
  10. dtsrun to start a package - cannot find xp_cmdshell
  11. Update only one record
  12. Incorrect syntax near the keyword 'Declare'.
  13. Exporting sql table into csv format retaining the column names
  14. LIKE N'@numericvarhere%'
  15. returning string length
  16. Fatal System Error
  17. XML export
  18. Connecting sql 2000 sp3 with asp
  19. Restore SQL hanging
  20. specify a non-linear order by
  21. Marking a table as a System Table
  22. Upgrade Client connectiviity tools on client machines
  23. Textfields show up with NULL but are NOT empty
  24. Query Analyzer vs Isqlw different Format
  25. Recover A Database From Another Hard Disk With A Corrupted Windows 2000 Installation.
  26. Query to group sequential items
  27. Filtering duplicate ID's?
  28. Upgrade Client connectiviity tools on client machines
  29. sql performance monitoring
  30. staff ratios
  31. Query in bat file?
  32. Triggers Won't Script
  33. Connect to remote server
  34. SQL Server Agent overhead / sysperfinfo
  35. Primary Key / Referntial Integrity Question
  36. Repost : Using forms with Sql Server
  37. SQL Server Reporting Services
  38. Different execution plans - same data, same server
  39. Concurrency (recap and idea).....
  40. Error while performing a Distributed Transaction on Linked Server
  41. Simple way of telling if I'm using MSDE or full SQL Server?
  42. Consuming results sets in a calling SQL procedure
  43. Query dbowner
  44. Update clustered column in place?
  45. Replication Reporting
  46. NT, SQL 2000
  47. To name dbo or not?
  48. Using DTS to import data - no rows returned.
  49. Using DTS to import data - no rows returned.
  50. Backup & recovery history
  51. string to datetime
  52. Quick question about performance....
  53. Query Execution Speed
  54. Table Row Count + Index Row Count
  55. SQL Query
  56. Slow Query with Date
  57. Deleeing database
  58. Upgrade of SQL Server driver
  59. Problems with starting Personal server 2000
  60. SQL query
  61. Localization issue
  62. inserting xml data
  63. ADO connection pooling and pepared statements
  64. Hide subquery results in stored procedure
  65. Getting last (newest) one record (datetime column or id)
  66. Logging "On Delete Cascade"
  67. BUG? SQL 2k - IN () allows invalid syntax and fails silently
  68. Frontpage 2000 AND SQL Server 7
  69. timeout Expired when trying to do a 'where' or filter recordset
  70. All my databases are missing
  71. Problem with creating views
  72. Why is SQL Server using so much Virtual Memory?
  73. can't see server
  74. 2 ms sql server backup
  75. Using Forms with Sql server
  76. Exported queries to excel an spreadsheet file
  77. Exported queries to excel an spreadsheet file
  78. How to Deploy SQL server Database to another PC while creating SetUP package in .Net VB
  79. REMOVE DUPLICATE ROWS
  80. Fyracle: Oracle-mode Firebird
  81. sql alert percent log used
  82. Stored procedure and query plans different
  83. IN() operator problem
  84. Send a warning to current connections
  85. User-Defined functions in DTS
  86. beginner student PL/SQL to T-SQL
  87. Automate restore
  88. Avoiding compilation
  89. Alter column causing log to fill
  90. Calling sp_oa* in function
  91. Variable inside a nested loop
  92. Auto Number or Identity Seed on Oracle Database
  93. sp_who_3 : An Enhanced and Efficient Version of sp_who
  94. Using REPLACE with NCHAR in a stored procedure
  95. Is the MSSQL server on the local machine?
  96. easy table based update statement???
  97. Little puzzle on data selection
  98. not in
  99. Multiple values in one column
  100. Will this query be optimized for a partitioned view?
  101. Number of foreign keys
  102. Can you add an Index to a table variable?
  103. Identity insert doubt
  104. Get one row from detail/child table
  105. Merged columns in OrderBy
  106. automatic process
  107. generating alter table script
  108. How to obtain just the last record grouped by
  109. stupid... simple question
  110. the most recent date and time
  111. Query too slow! Need some performance enhancing tips!
  112. SQL joins
  113. SQL Server Agent Question
  114. Database Trigger in MSSQL
  115. DB replication
  116. Tricky SELECT and ORDER BY
  117. counting the inserts and updates on a table in a sql server database
  118. How to change TrimTrailingBlanks from No to Yes
  119. DTS Help with Update?
  120. What is a cursor?
  121. question re process id's
  122. Is a subselect possible on a stored procedure
  123. dumbest question of the day: run a simple query and save the results into a text file
  124. MS Sql 2000 vs. Pervasive SQL
  125. Query to get all user tables with columns
  126. Select-into with identity
  127. Kaliedo
  128. Query that returns record that arn't duplicated in another table
  129. User Guest
  130. relationships as a table
  131. table columns storage
  132. Enterprise Manager: defaults lost in import/export
  133. use column alias in another calculation
  134. Help! SQL Collation
  135. combine 2 queries
  136. website hosting
  137. Data update
  138. email being sent, but no message
  139. SELECT and UPDATE in the same query
  140. Update Table
  141. Storing japanese characters
  142. Use TSQL to create a data matrix
  143. Help on DTS and selective dates
  144. Daily Devotion
  145. link to access.mdb
  146. Triggers
  147. Store procedure's debug
  148. MS SQL Server JDBC Driver Type 2 and Driver Type 4 Differences
  149. apology in advance for multiple post re AUDIT TRAIL...
  150. Audit trail..
  151. audit trail...
  152. Audit trail..
  153. Audit trail..
  154. Audit trail..
  155. Audit trail..
  156. Audit trail..
  157. Audit trail..
  158. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
  159. if..then
  160. Technique for concurrent access?
  161. LIMIT in MS SQL ??!!
  162. sql7\sql200 connectivity
  163. locking and rowid
  164. Executing Script Files From Transact-SQL
  165. audit tables, delete triggers, and asp.net
  166. common UPDATE syntax for SqlServer and Oracle
  167. How to use a value from one recordset in another..?
  168. SUM function with negatives values
  169. good table design...
  170. Join stored procedures?
  171. Data replication from MSSQL to MYSQL
  172. SQL Server 2000 Enterprice Manager Error
  173. Peak During Time Period
  174. Table Rowcount question
  175. Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions
  176. SQL Delete Syntex
  177. When to use the NOLOCK hint.
  178. SQL 7: One column's value is repeated throughout entire result set
  179. Help Cursor Based Stored Procedure Is Getting Slower and Slower!
  180. Please recommend two good books to master MDX
  181. What's the best SQL book for an intermediate level database programmer?
  182. sql server - not enough storage
  183. Dealing with a null parameter in SP
  184. SQL Server 7 Backup Problems
  185. Error Authentication User Informations
  186. 2-table join where only need one row of second table.
  187. creating a view with columns not in another table
  188. query help: need to return 2nd from top record
  189. Beta testers wanted
  190. Qualified table names
  191. Mysql on different servers
  192. Linking Lookup Tables
  193. Help! Top N in SQL Server?
  194. MS sql server on workgroup not domain.
  195. SQL Server Analysis Services
  196. HowTo Update Date Field
  197. help with showcontig
  198. Alter table weird bug?
  199. Restore Database
  200. Query "hightest value" contents of each "folder"?
  201. Variable Table Name in a Stored Procedure
  202. creating a matching program
  203. Multiple Update with multiple condition
  204. Function to remove accent in string
  205. I found this great little site
  206. Domain vs Local
  207. Urgent; Incorrect Syntax Near Go Help
  208. collation problem
  209. Insert Into..Select Problem
  210. Dual Xeon or Dual P4 for SQL Server?
  211. Passing parameters to action stored procedures using ADO, in Access Project
  212. What is the value of this error?
  213. Transaction Log Auditing
  214. Sql 7
  215. logins
  216. Batch insert 10000 rows at a time and commit
  217. Appropriate Use of READ UNCOMMITTED?
  218. select row values to be column name
  219. SQL6.5 restore
  220. Lost deadlocks
  221. Basic Question on Join
  222. Data Access Pages and SQL-Server
  223. How do I Merge two databases?
  224. Dynamic sql - how to use 'if exists' with variable tables..?
  225. Moving SQL server from one domain to antoher
  226. unique constraint vs unique index in MS SQL 2000
  227. Moving from Accesss97 to SQL Server 2000
  228. Help with SELECT query
  229. Trigger to populate another table.
  230. Selecting current time stamp
  231. add leading zero to date column??
  232. Computed column
  233. SQL Query Help
  234. SQL Server runs out of resources or is it my client application. Handle count = 96k
  235. Errori SQL
  236. Calculating Row Size including blobs
  237. Select from a date range
  238. Adding Order by on clustered index
  239. Use SQL 2000 for this???
  240. Checking for transposed numbers
  241. Query Help: JOIN ON CONTAINS with FORMSOF
  242. Load SQL 7 database and transaction log backups to SQL 2000
  243. Cannot empty a data file to another using DBCC SHRINKFILE EMPTYFILE
  244. consolidate multiple records
  245. Transaction log error
  246. Creating Reports based on hierarchical XML file
  247. Access .adp :How to INSERT all but KEY violations
  248. SQL statement for a report...
  249. removing constraints without knowing the constraint name
  250. SQL Server 2000 - preventing multiple update
  251. sql server -- identity problem
  252. Default retrieval from table loaded by DTS
  253. 32643 Mining the Web: eigenVectors, Kriging, Inverse DistanceWeighting Searches 32643
  254. Compare Schema's...XSD
  255. RADiest client for SQL Server?
  256. SQL 2000 padding char with spaces for a type 4 JDBC driver
  257. Calculate Weekending date.
  258. inserting ole-object
  259. strange backup transaction log
  260. Database questions
  261. can I export tables so that existing tables in destination database will be modified?
  262. System tables fragmentation
  263. Using Parameter (@value) for "IN" function list
  264. Error message "String or Binary data would be trunicated", " The statement has been terminated"
  265. Insert Query on table with identity column
  266. How can you optimize duplicated work in views?
  267. Query Cache?
  268. stored procedures with parameters (in .adp)
  269. Lost 'in' SQL - need help with IN function
  270. Horizontal Partitioning question
  271. Problem:MS-Access.adp with MSDE link to csv file
  272. Recover Lost data files?
  273. sp_changedbowner gives error 15110
  274. Tip - speed up "Database Properties" in Enterprise Manager
  275. Insert a jpeg into a column sql server 2000 - desperately seeking help
  276. Performance degrading placing join in WHERE instead of FROM block (using =, =*, *=)
  277. Help joining tables properly.
  278. reboot notification
  279. Accessing Novell EDirectory from SQL Server Linked Server
  280. Error message using "Copy Database Wizard"
  281. OLAP (SUM)
  282. SQL SERVER 2005
  283. How to update if exists else Insert in one SQL statement
  284. SQLMail woes !
  285. SQL corruption
  286. Extract parameters from SQL statement
  287. Expose SQL Meta Data via ASP
  288. How to email completion messages from RESTORE commands?
  289. SQL : ORDER BY question
  290. import of multiple CSV files in one MS SQL table
  291. permissions on a column
  292. Import XML file to database (MS Server 2000) using procedure (transact sql) ???
  293. Can't install 2000 developer
  294. Please help speed up my query!
  295. Conditional SELECT
  296. Is there any guideline to reach the 5NF or above in database designing?
  297. Synchronizing stored procedures
  298. Seems Unavoidable multiple cascade paths. How to avoid?
  299. Cannot shrink the transaction log
  300. Windows Authentication problems after upgrading from 7.0 to SQL 2000
  301. Junction table design options
  302. Ordinal position
  303. dts : call 2 procs within one 'execute sql task'
  304. Parent-Child-Dimension in SQL Srv 2005 Analysis Services
  305. SQL Syntax for distinct select
  306. >> Can Google web search index the data in my database?
  307. Precomputed tables
  308. Stored Proc To Copy Unnormalized to Normalized Table
  309. Removing out of hours time
  310. Insert failed & set option error
  311. Problem - Using Visual Studio to connect to remote SQL server
  312. Help With a query
  313. converting a text field to number
  314. How to update the production database?
  315. Perfomance Enhancement through proper database designing
  316. ntext Question
  317. Help on multiple date range on sql statement
  318. Non Database Owner call to sp_addrolemember or sp_droprolemember
  319. ActiveX info
  320. time based performance decay
  321. time based performance decay
  322. Records newer than 90 minutes (smalldatetime)
  323. Full Backup
  324. SQL calculations different than on calculator?
  325. Connection Error
  326. CREATING TABLE USING SQL BASED ON SEQUENTIAL DATES
  327. Tricky Query Help
  328. Test
  329. Date Calculations...
  330. Connection Failed
  331. Splitting a field into two
  332. Info on data replication on sql server 2000.
  333. Syntax to Add 2 constraints using Alter Table?
  334. Indexing in SQL 2000
  335. Indexing in SQL 2000
  336. Indexing in SQL 2000
  337. Indexing in SQL 2000
  338. problem exectuing storded procedure
  339. Upsizing a db to SQL db
  340. Importing CSV data to MSSQL using PHP
  341. doubt
  342. Benefit of moving Master & TempDB to diff HD
  343. Help: Complex Select Statement
  344. Can 6.5, 7.0 and 2000 all co-exist on same machine ?
  345. Log restores fail after database backup
  346. Are transactional settings used only during updates?
  347. SQL - filter out duplicates but keeping all columns
  348. Help with Triggers
  349. Enterprise Mgr
  350. SQL Server 2000
  351. Optimize my stored procedure
  352. file import to SQL Server 2000
  353. Joining and grouping using SQL
  354. BCP command with arguments having special chars
  355. Wierd Problem with Enterprise Manager
  356. Returns TABLE based on a condition
  357. mysql installation problem in Xp
  358. ISNULL Function and String Concatenation
  359. merge replication without rowguid
  360. mdf file become smaller and smaller after shrinking db
  361. NEED SQL HELP PLEASE
  362. importing txt file to multiple table in sql 2000
  363. replication problems with structure/trigger/identity
  364. Summing
  365. Adding times together
  366. SQL Server in single user mode??
  367. Changing column size in existing databese?
  368. Connection without MDAC2.6
  369. problem with comparing 2 text columns in 2 tables
  370. Automation of running queries
  371. problem in installing mysqlserver n client on same machie
  372. probelm in installing mysql on win xp m/c
  373. removing spaces from an nvarchar column
  374. Help INSERT INTO query
  375. MS Scorecard writeback
  376. Table Description
  377. Pass to SQL Connections conference
  378. Upgrading from 6.5 to 7 or 2000 with 6.5 software
  379. sql statement help
  380. third edition of SQL FOR SMARTIES
  381. Installing, creating database, updating schema?
  382. Linked Server (Oracle 9i)
  383. Default Instance Files and Named Instance File Paths
  384. pb with a trigger
  385. Stored procedures with some IFs, performance issues
  386. First Post
  387. (Corrected) Opinion of Filegroup Backups
  388. Opinion of Filegroup Backups?
  389. read windows event log from sql server
  390. How to convert to regular text, data stored in Image data type field ????
  391. Query sort question
  392. how to improve performance in this query?
  393. Getting Memory Status through SQL Scripting
  394. Terminology question - set of related records in multiple tables
  395. Report Services Examples.. please.. VS.NET
  396. How to upload a table as sql?
  397. How to upload table to sql?
  398. How to find out workstation name from net_address
  399. Selecting All Parents in a Path Enumerated Tree
  400. Users, Roles, Permissions management
  401. View stored procedure permissions
  402. checkpoint command and backup log
  403. Still Trying to Figure Out Identification of SQL Server Stored Proc. Permissions via VB
  404. SQLserver programming using MFC CDatabase & Crecordset.
  405. Problems with MSDE
  406. Replication component not installed problem
  407. filegroup backup restore question
  408. Alternative to this clumsy effort?
  409. Partitioned view broken after moving table to new filegroup
  410. encrypt(string) Question!!
  411. DTS - help
  412. Transaction log file too early to apply
  413. Blocking MS Access linked tables...
  414. help needed converting C float value to DBNUMERIC ...
  415. SET options have incorrect settings: 'ARITHABORT'
  416. odbc index problem
  417. location coordinates query
  418. Any MS SQL server driver for JDBC for window NT ?
  419. Problems with enabling subscription.
  420. Character Field Formats
  421. query help
  422. Not applying the initial snapshot when setting up Tran Repl.
  423. Updating from a Text File?
  424. Extended Stored Procedure problem (srv_describe function)...
  425. inserting data into a database alphabetically
  426. JDBC for MS SQL server
  427. Stored Procedure Source Control
  428. SQL buffer size
  429. String Manipulation SQL
  430. Connection problems
  431. Are you looking for a Job?
  432. SQL 2000: Users, Roles, Permissions management
  433. sql server transaction logs
  434. behavior of SQL on joined queries
  435. VLDB Replication or Dev Copy
  436. Checking the type of a variable in SQL
  437. datetime JDBC date conversion
  438. Output Parameters versus Recordsets in Stored Procedures
  439. Cannot generate SSPI context
  440. WriteFileEx system function executed on file "db_.BAK' only wrote 112128 bytes
  441. Moving a database between two SQL Server with different patch levels
  442. please help
  443. rating system
  444. SQL Query Help
  445. variable scoping problem
  446. Execute without Insert
  447. Indexed Views - Group By Redundancy
  448. records won't delete
  449. Storing Documents and Images - In the database or as a link?
  450. Northwest Arkansas - Sharp T-SQL People needed.
  451. Updating text fields
  452. Convert MySQL script to SQL Server script
  453. Restore from SQL 7 to MSDE
  454. Same DTS Package giving different results on SQL 2k vs. SQL 7.0
  455. SQL Server to Oracle
  456. Hugo Kornelis - thanks
  457. help with celko's tree model
  458. Everyone can see the Master database?
  459. String or binary data would be truncated error
  460. Multi Value Values in Varchar field, to show each value separately in a view
  461. Cluster + SQL Agent
  462. SQL Agent + Cluster
  463. Cluster SQL Agent problem
  464. Looking for tools to monitor sql and applications
  465. "Show Execution Plan" and misleading query costs...
  466. Bulk insert stops half way through.
  467. Conversion of Oracle Version 0-1 from DEC Machine
  468. New IBM Laptop running SQL server cannot connect to another sql server on network
  469. MSDE version
  470. too many admins
  471. MS SQL 2000 and TCP protocol
  472. SQL 2000 Caculation
  473. SQL Server administration tools
  474. urgent deliverable
  475. reduce databse size
  476. Local Temporary Tables
  477. Best way of importing Excel to SQL Server
  478. Select * into removes defaults
  479. Point inTime restore
  480. Difference between Access and SQL Server
  481. BCP column insert question
  482. Feed stored procedure with SELECT resultset
  483. Lock:Timeout + urgent
  484. Function to create comma separated list from any given column/table.
  485. Copy Objects From a Linked Server
  486. Error - trying to get only latest
  487. where should I post questions on sql?
  488. MHT File Connectivity with SQL Server
  489. Database Schema Conversion
  490. Toad & SQL Server
  491. Transact-SQL Help - CASE statement and Group By
  492. SQL Server Connection Timeout
  493. nth subset of data from current table
  494. Restoring a database to a point in time
  495. sp_OA* ActiveX problem: reading property works not
  496. CR-V timing belt
  497. Enterprise Manager crashing after Jet sp8 install
  498. BCP question
  499. Help with delete
  500. Execute Big Dynamic SQL in Stored Procedure to Create View
  501. does sql server collect stats on full table scans?
  502. Restore SQL Server 6.5 database in SQL Server 2000
  503. Query Optimization
  504. Puzzled by Query Plan
  505. How to determine how much RAM my SQL server is actually using???
  506. SQL Server ODBC Read-Only Connection Problem
  507. Need help with a query
  508. ASP sp execution returning closed recordset
  509. Separating one field into two fields based on a character in the field
  510. dts, dtsrun and scheduled tasks
  511. Index Tuning Wiz recommends negative performance improvements?
  512. Stored Procedure Runs Slow In Query Analyzer
  513. HELP: Point in time restore : HOW ?
  514. stored proc runs with error after reboot.
  515. Automatic Creation and Modification log
  516. MSDE Question
  517. sql2k with windows 2003 SBS
  518. Strange processing times
  519. Dynamic sets? (i.e. where x in (@set))
  520. return val of stored procedure in query analyzer
  521. Insert query with nested select and parameter
  522. Difference between running MS SQL Server 2000 on a desktop PC and a Server
  523. Auditing
  524. Sql6.5 ODBC
  525. Dealing with large amounts of data
  526. Default value through ADO-SQLOLEDB
  527. Error when installing SQL Server 2000 - cannot configure server
  528. ntext
  529. New to SqlServer
  530. Installing Reporting Services for SQL Server 2000
  531. Return Primary Key on INSERT statement
  532. Hi Dan Guzman
  533. sql-problem
  534. problem in inserting date in sql server 7 through insert query
  535. Don't use clustered indexes?
  536. Google DB Engine ?
  537. logs getting full
  538. I'm dense on Density
  539. Performance question - Restarting the SQL server resolved my timeout problem
  540. executing sql code from text field or from multiple varchar(8000) rows in a table
  541. Data Transformation - hanging
  542. UNABLE TO CONNECT TO SERVER
  543. whats a "memory page faults"
  544. Advanced Transact-SQL Reference book - Need recommendations!
  545. A problem with bcp tool
  546. 'declare' syntax in a UDF
  547. OpenXML Query
  548. Lost Update Problem?
  549. can I return output from stored procedure into an HTA to display in browser?
  550. BitArray to binary