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