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