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. Error in Query
  2. Communication betwee two tables
  3. DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  4. Communication betwee two tables
  5. connection ms sql server client to winserver2003 with limited id
  6. One of two subscribers not in sync - Replication
  7. Trouble connecting to remote db using the .NET data provider for Sql Server
  8. views dependent on other views
  9. Cascade update
  10. Plz Help!!
  11. Greatest value
  12. SQL Server 2005 vs Ascential
  13. General Question about doing calculations in SQL
  14. Identifying "filler"
  15. Timeout expired
  16. 2005 Database Mirroring & Witness
  17. convert a datatype
  18. Error (8626) while inserting record into table with text field and which is the base for indexed view
  19. Integrated Services
  20. Values of two columns in two different tables--presentation using select
  21. Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000
  22. Naming syntax in 2005
  23. looking to collect distinct date part out of datetime field
  24. Identifying Duplicates in a table
  25. Pipe delimiter problem
  26. Syntax of updating table variables?
  27. User-defined function and temporary tables
  28. Linked Server via ODBC and stored procedure
  29. SQL Server Scanning Tables
  30. Too Many SET Options
  31. freeTDS ODBC
  32. Transactional Replication with Immediate updation DBNETLIB problem.
  33. dbcc shrinkfile - SQL Server 2000 - invalidate log?
  34. powerfull Oracle specifications PC
  35. Oracle Application and laptops
  36. can i increment the column (c1+2) ---by creating the trigger
  37. Different query plans for view and view definition statement
  38. how to install 64-bit version?
  39. Help optmizing a stored proc
  40. Memory limitations, 2005 Standard
  41. SQLInjection with OpenXML
  42. Problem connecting AS400/DB2 with SSIS
  43. sql query in vb
  44. Execution Plan Hinting
  45. Getting list of recently added IDENTITY items
  46. Possibly simple query but I'm not good enough to fathom it!
  47. Query assistance
  48. Speed up Bulk Update
  49. bcp with format file
  50. need help to take the variables associated with the 1st occurrence of a date variable
  51. Query Brain Teaser - Revenue Projections
  52. Can't fit results of tsql query in excel
  53. Cursor????
  54. Divide by Zero
  55. PK
  56. Unable to access perfmon counters remotely
  57. Sybase tool to manage database
  58. how to write one stored procedure for a (same column )present in 20 tables
  59. MSDE 2000 changing disablenetworkprotocols after installation
  60. Appending tables
  61. Convert VARCHAR into Money Value
  62. Changing Machine Names MSDE
  63. sum with increment
  64. Can a stored procedure parameter be optional
  65. Changing subnets help?
  66. beginner: "Login failed for user 'sa'."
  67. How can I do amalgamate 3 select queries and then get unique entries from the result
  68. Stored Procedure
  69. inserted the image in a column----how can i view the image
  70. Special characters in MSSQL.
  71. How does databse driver manager know the application is "Unicode aware" ?
  72. slecting multiple distinct columns..
  73. itzik ben-gan
  74. troubleshooting data updates
  75. Does anyone know what the "Option value changed" error message is?
  76. Fast look up of long (n)varchar
  77. Out of range datetime value error when inserting using select...union
  78. How to check if DB Constraints are enabled in a database?
  79. Problem with database filegroup restructuring in SQL Server?
  80. Help with Query
  81. SQL Server: beginner: "Login failed for user 'sa'."
  82. Space Available Within A Filegroup
  83. Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  84. Query Memory?
  85. Referential Integrity - linking multiple tables to transaction table
  86. How can I remove duplicate entries in a sql query?
  87. Preventing SQL Injection attacks
  88. MSSQL Query Memory when using long fields
  89. Problem with variable of type money?
  90. Replicate between to MSSQL 2000 Servers
  91. Logshipping Corruption Problem
  92. how to import image jpeg file to table in oracle
  93. Select row with only ONE occurence
  94. Convert Sting to Date
  95. comma deliminited coloumn
  96. Can I do this in SQL Analyzer or with a dts package?
  97. How does one set read-uncommitted on the entire DB?
  98. Use MS SQL Server 2005 Developer version to open MDF file?
  99. more date problems...
  100. http://sqlserver.startpagina.nl/
  101. Executing a Views from a Trigger
  102. Cannot connect to a new installed SQL Server 2000
  103. SQL cache so GREEDY?
  104. Insert first n columns from select
  105. getting the matching columns from two tables
  106. Stored procedure returns no value
  107. Difference Between NULL and Blank in SQL
  108. Checking for existing column
  109. Optimizing a JOIN
  110. How to have strings automatically truncated?
  111. Reasonable to assemble FullName W/ A UDF
  112. restore sql 7db to sql2000
  113. Group By Query Help
  114. Converting Traceid issue
  115. How to avoid cursors
  116. Create New Table advice
  117. page life expectancy=0
  118. Urgent opening for dwh informatica
  119. sql server efficient
  120. LDAP interface to SQL Server 2000
  121. Installer differences - SQL2K under W2K versys W2K3
  122. Error using UPDATE statement
  123. sqlservr.exe memory usage
  124. Script SQL 2005 database to individual files?
  125. Send 2 SQL statements using Integrated services
  126. Automating record selection parameters
  127. Query Analyzer and Profiler won't start from EM Tools menu
  128. Simple SQL Distinct...!?
  129. Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connection.
  130. workgroup information file does not exist
  131. workgroup information file does not exist
  132. tools for analysis relations
  133. Announcing Yellowfin BI reporting Version 2.4 release now available.
  134. International Settings for SQL 2000
  135. advice
  136. MS SQL export / import data
  137. DELETE FROM - Somethings not right
  138. unknown column 'state' in field list
  139. Detroit SQL Server User Group.
  140. Question about Joining 2 tables??
  141. Fields in my tables are disappearing!
  142. Subquery -> slowness
  143. <ANNOUNCE>Building XML Workflow Applications
  144. log/log10 functions truncate my resultset
  145. median query without using function
  146. scheduled dts suspends...
  147. Webserver request invalid query
  148. Linked Server SQL to SQL
  149. linked data bases
  150. long SQL lines for osql
  151. copy a table
  152. How to create SELECT?
  153. Script needed to edit open objects in Sybase
  154. SQL command needed to edit table data
  155. Joing Multiple Columns
  156. Virtual Servers cannot connect to host PC Database
  157. Tricky SQL question
  158. Setting a value for a boolean
  159. export SQLServer2000 DB to Access
  160. UPDATE Statement Involving Tables in Different Databases
  161. select statement returns null in stored proc
  162. Backup users
  163. how to call a stored procedure in an insert command
  164. Merge Replication
  165. How to Determine the unique IDs of duplicated records
  166. Order By
  167. normalization
  168. Lock database to update
  169. DTS Rounding problem
  170. ms sql server
  171. Script to reverse engineering schema
  172. [SQL2000] permissions to use view based on tables from many databases
  173. How to tell how many times an SQL executed in v7 or v2000?
  174. How to tell how many times an SQL executed in v7 or v2000?
  175. Synchronize data between 2 instances of SQL Server Express?
  176. Table spool/Lazy spool question
  177. Query analyzer error message - Cannot generate SSPI context
  178. full text search on doc files
  179. Trigger problem no rowlevel support, please help!
  180. Connecting to SQL server
  181. DB shrinks without request
  182. Loop / Cursor help
  183. Getting closest matching values
  184. Returning Values from a Dynamic SQL
  185. truncating
  186. sql server and membership provider
  187. Embedded Queries?
  188. Store Procedure Query
  189. Tough Sql Query
  190. Can SQL Server work with a Paradox table?
  191. Formula problem
  192. Stored procedures, linked servers, and cursors
  193. Business-to-Business Data Integration in a SOA World
  194. sql query help join
  195. with nolock problem
  196. what are cursors in sql???
  197. SQL query help
  198. SQL Server 2000 conferences
  199. How to correctly update a table which values can be either inserted/updated/deleted on update?
  200. IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
  201. Splitting directory and file name
  202. Torn page problem
  203. Recovery model problem; db properities
  204. torn page detection and auto shrink: performance?
  205. Relational Database
  206. Last Year Month to Date Function
  207. Transaction isolation levels
  208. SQL Server float data type
  209. Query Help with Update statement, thanks!
  210. Record Counter
  211. limit resources per user
  212. very slow query (select count(*) from table)
  213. More efficient than LEFT JOIN
  214. Client Web Browser & Remote SQL Script Error?
  215. installing apache, php5 and mysql 4
  216. About Join OR Where
  217. Query Help!
  218. concatenate two fields in a view?
  219. Importing Access database into Sql Server Express
  220. Capturing Mysterious Truncation/deletion of a table
  221. Need Senior SQL DBA
  222. Administration tool web for SQLserver database
  223. IsNull and aggregate functions
  224. Slightly off-topic topic
  225. Select command with multiple tables
  226. select another column where max
  227. fetching unique pins...
  228. Indexing issue, inconsistent performance
  229. sp_executesql question
  230. Java method invocation support
  231. Job Executes Only First Step
  232. Dynamic query help SQL 2005
  233. Design Tool
  234. Errors on DBCC SHRINKFILE(2)
  235. Resolving duplicates entries in table among 10 databases
  236. Why the log file is growing too much upon running nested stored procedures (MS SQL 2K)
  237. Non-English Characters
  238. SQL Server 2005 - Save tran save point name case sensitive?
  239. SQL Sever 2005 - Full Text FormsOf Inflectional
  240. BACKUP LOG cannot be performed because there is no current database backup
  241. Can't reference a Group Field in Footer SUM expression!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  242. How to configure a JBOD disk array (PowerVault) for Performance
  243. Transaction reading from Linked Server without DTC? (Isolation Level?)
  244. Show Server Trace Missing in SQL Management Studio?
  245. SQL Server 2K Linked Access 97 Server not working
  246. Tuning sql in SQL Sever 2005 using the dta utility
  247. 100% CPU Usage (Part 2)
  248. Removing Duplicates rows from Inner Join
  249. Removing Duplicates rows from Inner Join
  250. Testing UDFs with TSQLUnit
  251. How do I NTH Select in SQL????
  252. Interview Questions Feb 09, 2006
  253. Design idea Help for Database
  254. Rollback transaction after connection lost
  255. Performance Problem
  256. Deadlock within select?
  257. interdatabase trigger possible??
  258. Ms Sql Blob ??
  259. SQL question
  260. Help with tricky T-SQL
  261. Class does not support aggregation
  262. REPLACE function doesn't work with null-bytes
  263. Why does SQL2005 automatically insert TOP 100 PERCENT in views?
  264. one for the SQL experts - dare I say TRICKY SQL!
  265. Great Job Board
  266. Full Recovery Model - log doesn't grow?
  267. Best Job Search Site...
  268. Searching/Estracting numerical data
  269. Any T-SQL advice?
  270. how do i replace a substring in sqlserver ?
  271. how do we tune a large sql query
  272. (Hopefully) Easy SQL 6.5 Question - Getting Table Structure
  273. How to go around the SQL Server 2005 User Instance problem when using Remote Desktop
  274. SQL Server DB installation
  275. ms sql equivalent of this oracle
  276. I can't find sql server on my computer
  277. can you tell me why this causes a deadlock?
  278. Developers needed for Healthcare software
  279. MS SQL 2000 SP Query Plan
  280. MS SQL 2000 SP Query Plan
  281. sql server and access
  282. Interview Questions Feb 03 2006
  283. Trigger not firing on update
  284. Read, modify table (locking) question
  285. Database views hierarchy
  286. Performance and data structure question
  287. perf
  288. Deleteing large bulks of data
  289. Int to char conversion
  290. T-sql
  291. Table variables
  292. Interview Questions Feb 01 2006
  293. Monthly date range substitution
  294. Getting the database name in Server-Side trace event
  295. SQL Server 2005: setup problem
  296. Replace chars in any field of a table
  297. Session
  298. do I need a DBA for SQL Server?
  299. Invalid Data for 'Numeric' when EXEC returns empty row
  300. update statement not to fire trigger
  301. help
  302. Set SP parameter
  303. how to restrict data insertion upto 50 MB in a table
  304. URGENT : Help -1
  305. Get Data From CSV to MS SQL DB
  306. Msg 107, Level 16, State 2, Line 1
  307. front end options for entering data into an oracle database
  308. Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005
  309. Workstation date
  310. timezones in select statement
  311. Connection to sql server 2000
  312. Interview Questions Feb 01 2006
  313. getting rid of trailing zeroes from a decimal output
  314. Database normalization
  315. moving tables
  316. date + 1 ???
  317. UPDATE on a column with a set default
  318. T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
  319. Rqst for Inventory Database Best Practices
  320. SQL Server Interview Questions Jan 30 2006
  321. IT tests. SQL, C, C++, XML, HTML, .NET...
  322. Example of binary data type in SQL Server
  323. SQL Server client tools
  324. How to find first not null value in column
  325. What is the right datatype to store Hours up to the minute precision?
  326. Data Connections for SQL Server Express in Visual Studio Express
  327. MS Access Frontend for remote sql server
  328. SQL Server 2000 Audit for login
  329. Database instance
  330. Views vs Stored Procedures, whats the difference?
  331. New bie
  332. New bie
  333. Formula Parsing
  334. Query out an xml element from a field containing xml data
  335. Problem Building Script with Int
  336. select cast help needed
  337. Truncate table if exists
  338. Scalability questions for extended stored procedure
  339. Insert/Update with dynamic database name
  340. ASC Result Set with Nulls at the bottom
  341. Can i debug/watch on the trigger's INSERTED and DELETED records/values?
  342. Conditional execution of DTS package task
  343. Help creating a SELECT statement for "today"
  344. SQL Server does not exist or access denied
  345. SQL Server does not exist or access denied
  346. Difficult SQL Statment
  347. Question on SQL Server 2000 - 2005
  348. export sqlserver database to ms-access by sql script
  349. configuration/load balancing
  350. Importing from Oracle 10g
  351. Ignore Some Errors
  352. Trigger?
  353. Outer Join problem
  354. ORDER BY in VIEW not working
  355. Commit Transaction Gets Deleted - Unable to save SP
  356. Joining tables in different databases
  357. SQL Server could not configure 'Server\Instance' as a Distributor.
  358. Web based sql server connection
  359. 6.5 to 2000 upgrade problems
  360. Default value: ISNULL()
  361. SQL2K5 Database Engine Tuning Advisor
  362. Linked Server to SQL-Server Question
  363. Connections to SQL server are slow on one machine
  364. ODBC Connection to a linked database
  365. Urgent rek
  366. Want to be able to create or view database diagrams
  367. Conditional Column Name On Insert
  368. Linked Server setup - SQL 2005 RTM
  369. Reporting Services
  370. Question about converting bigint field to int field
  371. Link to DB2
  372. remote permissions
  373. Need Junior SQL Server DBA in McLean, VA ASAP
  374. Odd connection problem (proxy + internal)
  375. How can I update several (not all) fields in table A from table B for replication?
  376. Server Feedback
  377. need help
  378. Failed KB909544 installation
  379. This query must be easy but need help
  380. Advanced Data Shaping - Multiple Relate clause
  381. Querying joined tables with 0 results
  382. Help wanted msaccess PIVOT-query --> MS-SQL view/sp
  383. Can I use stored procedures with PHP via ODBC bridge?
  384. Problem ith DTS and delimited file with empty last column
  385. how to get tables involved in constraint
  386. splitting a comma seperated column into multiple rows
  387. DTS Failed To Run
  388. Audit Logon / Audit Logoff problem with SQL 2K
  389. To Create Unique table names and access them in code...
  390. ODBC in Stored Procedure
  391. Variabe Error
  392. system information about indexes
  393. Facing Problem
  394. database migration
  395. osql batch processing without -i
  396. Truncated Decimals
  397. Unable to Update Table Even After Dropping Constraint
  398. question on inserting a record on sql server with identity column as key
  399. Does SQL Server save any metadata in registry or home folder?
  400. Is it a complex sql query?
  401. problem with filtering data
  402. isql / osql / Windows XP / disable "Automatic ANSI to OEM conversion"
  403. Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
  404. Deadlocks, why?
  405. Baffled! Can't figure out how to do this query. Is it even possible?
  406. Full-text search across multiple tables
  407. SQL QUERY HELP
  408. Why would adding dbo. cause my function to run forever?
  409. SQL Query
  410. Advanced Sql-Shape Query - Help
  411. NEW @ DTS
  412. Searching a datetime field by time
  413. Searching for a partial match in a varchar field
  414. mesage in Sql Server 2000 log
  415. selecting only numeric data from a string
  416. Convert Text to Int
  417. Store procedures
  418. Record count in all tables
  419. show stored procedure
  420. show stored procedure
  421. Simple SQL query question
  422. SqlCE Synchronization Issue: Native Error 29006, The process could not deliver the snapshot to the Subscriber
  423. change home and data directories
  424. Can LOG PI or Log Explorer recover deleted records BEFORE
  425. Requirement for peoplesoft CRM at SFO,CA
  426. bcp into view with derived column
  427. View Permision sql 2000
  428. Preventing the message 'Duplicate key was ignored'
  429. standard sql: update multiple rows.
  430. Adding column via sp_repladdcolumn...
  431. Unicode Conversion
  432. Testing (Please Ignore this message)
  433. vs MySQL
  434. Browser as Front-End
  435. Experts Profiels
  436. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
  437. How to omit Schema name when referrring to Tables?
  438. How to mit the Schema name when referrring to Tables?
  439. nested joins - joining one table to another multiple times
  440. Combining 3 SQL statements
  441. Combining 3 SQL statements
  442. Cursor loop is broken
  443. Cursor loop is broken
  444. Cursor loop is broken
  445. Environment and Application Domain between ASP.NET & SQL Server
  446. Help
  447. Default Template for User Defined Function
  448. Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
  449. QUESTION: Exporting data into SQL statements
  450. Problems upgrading to 2005 Trial from 2000 Standard Edition
  451. SQL Server 2000 License Query
  452. *Very Urgent Rek - SQL Server DBA from Direct Client: Full time* @ New Jersey
  453. How to get code of stored procedures ?
  454. "owner name" cannot be omitted in sql 2005 querries?
  455. SQL Distinct Value and Order by some Field......
  456. Configuration file
  457. SQL Server and Workgroup networks, how?
  458. managing users
  459. Connection to Oracle sometimes hangs
  460. Stuck - Cant figure out a Query for this situation
  461. SQL Query question
  462. SQL Query Question - JOIN or not to JOIN
  463. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  464. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  465. No ending Rebuild master
  466. XML Data Processing
  467. Simple SQl question
  468. How to know the User who disabled a Job??
  469. XML data feed
  470. Deadlock on Update using temp table
  471. Ms Sql Query
  472. (Can't get) Media for SQL Server 2005
  473. Index for username/password
  474. Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
  475. dateformat is ignored
  476. Backup failed: Operating system error 112(error not found).
  477. Moving SQL Server to a new drive
  478. Need help with a join
  479. Is "name" a keyword?
  480. Oracle/MS SQL Interface
  481. Best way to interface with Oracle
  482. How many CALs for a web page?
  483. view with auto_increment field
  484. Visual Query Builder with unions and sub-queries
  485. Createa table like a existing table?
  486. SQL Server 2000 Installation error
  487. Synchronising/replicating access with sql server
  488. Synchronising with remote server
  489. C++ and SQL Server programming
  490. Temp Table Faster?
  491. SQL Server Std vs Small Business Server 2003
  492. Stored Procedure only works in when app uses trusted security
  493. How to execute a "batch file" using SQL Server 2005?
  494. Stuck with sorting columns
  495. Export SPs?
  496. Export SPs?
  497. Referential Integrity
  498. Business Analyst with i2
  499. intead of update/insert trigger on view question
  500. MS OLE DB for ODBC with Oracle ODBC source headaches
  501. Index on two columns doesn't allow NULL in both - HELP!
  502. How to schedule a stored procedure
  503. Breaking apart Column into rows
  504. Making a view that shows the results of several different queries.
  505. Where the !@?!@ is my Stored Procedure?
  506. Calculating 'time difference' between two records....
  507. LDIFDE csv import to SQL - looking for Ideas
  508. OLE DB Provider for ODBC and Oracle
  509. How to Restore an Archived Filegroup on Another Server
  510. operand type clash
  511. How do I use SELECT on a column with datatype TEXT?
  512. one transaction log per filegroup?
  513. TransferText dropping fractions
  514. SQL/ASP - Timout Problem w/ Particular Statement
  515. Update Web Form
  516. time format error
  517. arbitrarily delete transaction log
  518. Size of data-set passed back by a select
  519. Store Multi-Select values in an image data type?
  520. Lost Data
  521. Periodic run of stored procedure
  522. changing collations
  523. SQL 2005 Management Studio: Line Numbers in Query Window.
  524. Can't edit Linked Server General Properties after saving
  525. NetSearch the Business Intelligence Search Engine
  526. RESTORE an Old Filegroup into an UpTodate Database
  527. sqlagent.out
  528. Connection pooling
  529. trigger help
  530. database maintenace Plan location
  531. Maximum UNION statements in a query
  532. How to pass table names to a Stored procedure
  533. Concurrent users
  534. Reacting to DB events
  535. MS-DTC / SQL Server 2000
  536. Cannot resolve collation conflict for equal to operation.
  537. Multiple Apps on System DSN on Server from One PC
  538. Regarding table Order
  539. SQL Best Practices Analyzer Rule: Use of Schema Qualified Tables/Views
  540. Can't connect to Oracle Dbase with SQL Server 2005 Express
  541. SQL Server Express Edition vs MSDE
  542. Converting INT datatype to BIGINT datatype
  543. Grouping Dates
  544. Stored Procedure to change default
  545. links for fields
  546. Temp tables vs table variables
  547. Access to SQL Server
  548. Indexing a View
  549. Log shipping and DTS pakages
  550. Fuego, Tomcat, JDBC & SQL Server 2000