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