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