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. New trigger stops scope_identity / @@identity from working
  2. SQL2005 Rebuild Index Not Working
  3. i want ot convert xml data format into the general data format
  4. Backup log - will it truncate?
  5. peraphs thi spost go here...
  6. Times in SQL Server
  7. composite index and column order
  8. Help with 2 datetime fields-1 stores date, the other time
  9. exporting data into tables from excel file
  10. SQLXML
  11. Store program EXE in table?
  12. Disabling the AUTOCOMMIT option in MSSQLServer
  13. Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue
  14. noob sql learn! web interface and sql express!
  15. Dump of databasse
  16. Scripting Databases
  17. need information for "Before Select" Trigger
  18. Cannot Alter Table being Published for Replication
  19. SQL Server + Oracle Data linked in one query
  20. Format a datetime columns output?
  21. update
  22. Help with large text fields please
  23. Get results from VB SQLCRL Stored Procedure
  24. SQL Server 2005 stored procedures decryptor
  25. Create project/stored procedure for SQLCRL
  26. Calling Stored Procedure from an ActiveX task
  27. Challenge: Can you optimize this?
  28. Transactional Replication - Adding New Articles
  29. Record size more than 8060B
  30. SQLServer 2000 SP4 Enterprise Manager crashes immediately...
  31. SQL Union Problems When Trying to Retrieve Random Records
  32. McAfee Recruits Database Engineers
  33. Line 1: Incorrect syntax near
  34. How to Insert date in sql server database
  35. Parameterized SP in WHERE Clause of Another SP
  36. Question about returning a smalldatetime from a Function
  37. Dummy Question
  38. SERVER BUSY
  39. Automated email
  40. My article on Dynamic Search Conditions
  41. deadlock problem
  42. Reporting Services Report Viewer versus Report Server Problem
  43. Referential Integrity problem
  44. Trigger to populate table or database
  45. SQL_Latin1_General_CP1_CS_AS
  46. register hasn't been updated
  47. Finding prepared statement sql
  48. HAVING prob !
  49. Interface for SQL Server database
  50. this sql command make me sick
  51. Question about using AND in WHERE...
  52. money data type
  53. listing all SQL SErver and fill a sheet
  54. default value on quantity and price field
  55. XML issue.
  56. Complex Query
  57. Linked Server Time Difference
  58. Backing up Logins and Permissions for SQL Servers
  59. Very chalanging question - Explanation
  60. View SQL transaction log details
  61. batch file to send email
  62. Insert from parameters and select statement
  63. VERY chalanging question
  64. sql client in sql server 2005
  65. 2005: SIMPLE QUESTION: error log
  66. need help in SSIS ETL development
  67. Help Needed
  68. Storing SQL Server Agent logs in a relational store
  69. SQL syntax question
  70. port specification
  71. port specification
  72. DBA Interview Questions
  73. Can't view Locks / Process ID
  74. sp_helprotect COLUMN has NULL value
  75. T-SQL CLOSE Connection to DB
  76. How can I conserve the initial zero when convert numeric to string using STR()
  77. sufficient user permissions for install error
  78. Moving Log Shipping Monitor
  79. Oracle Server Quick Reference Guide
  80. Insert a record in a particular place
  81. Trying To find a Match in computed columns
  82. error: Cursor not returned from query
  83. SQL Server 2005: CLR functions vs SQL functions
  84. AS 2005 Cube/Perspective/Measure Group AutoDoc...
  85. script
  86. Limiting Rows in a Report
  87. Output stored procedure
  88. SQL Server 2005 blindingly fast
  89. Interested in SQL server 2000?
  90. Log shipping failover
  91. using lookup and display only field as control field
  92. field is part of an index
  93. How to import Dbase file
  94. Hanging during READ_COMMITTED_SNAPSHOT ON
  95. Substring and Charindex Script Not Working
  96. How to make a correct select
  97. Duplicating a Database using RMAN
  98. IIS issue
  99. Concatenation getting truncated
  100. What's wrong in this query ?
  101. Web Application Testing
  102. Creating dates from table columns
  103. Book contrasting Oracle and MS SQLServer?
  104. Question on Transaction Log Backups
  105. converting integer zipcodes to a 5 character char
  106. What permissions do I need to manage users?
  107. Need Tech Review of MSSQL Backup Chapter for O'Reilly Book
  108. My boss beats me
  109. Returning multiple rows from a stored procedure
  110. MySQL -> ms-sqlserver
  111. Probem in executing a long Dynamic MDX from SQL server
  112. eternal lock?
  113. Effects of a Database restoration.
  114. how to insert data into to image datatype
  115. Problem While Connecting a folder containing sql files in Execute SQL Task in Execute Sql statements in loop example
  116. SQL 2000 -> SQL 2005 conversion sql authentication problem
  117. sys.tables starting with #
  118. to read backup file
  119. rowcount help
  120. Use ANSI Join or Old Style Join?
  121. HW Requirement for SQL Server 2005
  122. SQL Query Help
  123. Upgrading HA Applications with Replication
  124. Numbering in SQL
  125. comparision of sql server & mysql
  126. SQL IN Query
  127. Insert into a table recursively
  128. SQL Script Debugging - Just being curious
  129. Conditions on latest record
  130. Help to optimize query
  131. Parsing a varchar(79) column
  132. ADO.NET Timeout Exception - I have tried everything
  133. Copy a table from one DB to antoher in SQL Server 2005
  134. Copy a table from one DB to antoher in SQL Server 2005
  135. Customize Prompt Message for Stored Procedure from Access Form
  136. sp_fkeys stored procedue is very slow
  137. New server setup and RAID recommendation
  138. SQL Server 2000 running out of space.
  139. Copying files between servers
  140. how to improve performance of 'LEFT JOIN'
  141. JDBC connectivity with SQL Server
  142. Your Professional Advice Please - Design
  143. How do I start sql listener on a port?
  144. deadlocks
  145. loading sql files from a master file Oracle equivalent
  146. Retrieve good records from a bad record table
  147. Convert Access Query to SQL Server View
  148. SQL server thrashing?
  149. FILEGROUP BACKUP/RESTORE
  150. Using BLOB
  151. alter table nocheck constraint still some dependencies
  152. Compare databases between 2 SQL servers
  153. MS SQL Script Optimisation
  154. the datatype
  155. purpose of OUTPUT keyword in sql server
  156. Problem with Delete On Linked Server
  157. db upgrade code
  158. Putting attribute on root node using FOR XML PATH
  159. How to debug in SQL Server 2005
  160. detect connectable db servers
  161. Create Status Table
  162. Indexing strategies
  163. create table with recursive relationship
  164. Formatting database content
  165. Problems with remote conexion
  166. high cpu, low speed
  167. udf
  168. deploy Report
  169. View from a merge of two tables
  170. Adding new lines into results in the
  171. Truncate Table On Linked Server?
  172. Logging Into Linked Server
  173. Transferring Data Between Servers
  174. MORE THAN A THOUSAND POSITIONS NATIONWIDE
  175. NovelSpace Media, LLC announces the launch of their new online bookstore and web portal devoted to developers and programmers.
  176. Qouted String
  177. CAL Licensing and user limitations?
  178. Import spreadsheet using TransferSpreadsheet
  179. LogReader Agent Lacks Required Privilege
  180. update SQL field with stripped data from other field
  181. Create view from cursor
  182. MS SQL: how to fill down values from row above when column meets specific criterea
  183. 64 bit SQL 2005 Memory
  184. DBTool (another database toolbox for MATLAB ) new release 2.4
  185. Tool/Best Practices for installing BI Project
  186. SPs from SQL 2000 to SQL 2005
  187. Create Peer-to-Peer Topology Error Message
  188. 'MSDAORA' was unable to begin a distributed transaction - why?! (SQL <-> Oracle)
  189. SQL2005 collation vs Oracle
  190. Need OLAP Dev in Colorado
  191. Exotic SQL Question
  192. Clustered Index considerations
  193. Transactional Replication and Failover Cluster
  194. Access 2000 project
  195. bug: data file autogrowth set to 12800%
  196. how to create a real (not virtual) table from view1 & view2 ni sql server?
  197. Select several values into a single variable
  198. Monitoring Production Instances.
  199. How to import several excel files using one dts package
  200. Copy 60GB table?
  201. Can't start the SQLAGENT
  202. Looping through several Excel data sources in SSIS
  203. Tempdb grows rapidly and fills up disk space
  204. T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name
  205. Setting up a Settings Table
  206. SQL Server 2000 and 2005 co-existence problems
  207. JDBC - varchar or nvarchar fields?
  208. Running SQL and Oracle on the same server
  209. Multicolumn correlated subquery?
  210. Need Emergency Advice
  211. Urgently Required a System Support Engineer
  212. Merge replication issue - one column not replicating
  213. Update statement performance problem
  214. C# / Sql Server question
  215. TRANSACTIONS in a WHILE LOOP. Flow Question
  216. Using ADO AddNew and my simple trigger won't execute
  217. WinXP, SQL Server 2000, Queries
  218. locating set of points close to one another (within a threshold)
  219. Backup SQL Files
  220. Problem moving msdb
  221. Help with update trigger
  222. Wild cards in query designer
  223. Updating recordsets in MS SQL 2005 not working
  224. return into one string
  225. Using trigger to export xml file
  226. DTSRUN privileges?
  227. Table Joins on more than one field
  228. how to find conditions across rows (attendance)
  229. help for query
  230. All Interview Questions And Answers
  231. Gather Format and Store - Right or Wrong
  232. Attach a read-only restored database
  233. Join multiple records into one field
  234. Partition function - Unknow range column
  235. Problems with view
  236. Use variable for datasource in Opendatasource
  237. Date creation in SQL
  238. Tuning on Oracle 10g and SQL Server 2005
  239. How to do an equivelent First() operation
  240. Selecting MAX (Date) - Performance Question
  241. SQL Counting number of non-distinct rows?
  242. Problem with using BETWEEN for date range...
  243. Updating SQL Server Table Using Excel
  244. how to store XML Document in MS SQL using JAVA
  245. Transactional Replication over the Internet
  246. An odd quandry.
  247. Raising errors in a catch block in SQL2005
  248. How do I use pass data to/from stored procedure
  249. How do I use pass data to/from stored procedure
  250. Load XML souce file to a SP parameter
  251. select statement and Distinct and or Group By
  252. String matching precedence
  253. How can I insert # in a character field
  254. ANSI Nulls
  255. HELP is needed for MsSQL
  256. Stuck execution plan?
  257. return values from DTS wizard
  258. Script to find last time Cubes get processed
  259. Transactional Replication - Modifying Target Tables
  260. Remote connections error SQL Server 2005
  261. Converting Int value to datetime
  262. Syntax Help!
  263. Database name not found in the Edit job step in SQL Server Enterprise Manager
  264. Getting a unique ID in SQL Server - other than a GUID
  265. RAID 5 beats RAID 10
  266. sql server - "use database" not found
  267. DTC
  268. Sql 7
  269. Trigger to encrypt field before write
  270. Problem deleting publication
  271. Update Statement
  272. Update statement
  273. SQL Function
  274. Conditional Query
  275. VB (5or6) does something wierd with image data while saving to sql2000
  276. the Best way to build a 5 million entry database?
  277. MySQL Cluster
  278. Declare dynamic Cursor from String
  279. Limits on rows in a table
  280. sql query help
  281. SQL 2005 Encryption questions
  282. Please help quick statement check
  283. Compound Primary Key - order not as expected
  284. Log Shipping to two Databases on One Secondary Server
  285. SQL in Access Report
  286. Simple JOIN, INTERSECT query
  287. How to performance case-insensitive search on XML data type in SQLServer 2005?
  288. Correlated Query Summing Question.
  289. How to page SQL query result returned from FOR XML statement?
  290. query hheeelp
  291. Cannot insert explicit value for identity...
  292. Removing embedded SQL from database application
  293. No distinct in a select into stement ?
  294. SELECT and regular expression
  295. Sorting the result
  296. Access PErmissions issue
  297. Articles on Dynamic SQL and certificates/impersonation
  298. SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_v alue" ?
  299. backup failure
  300. SQL Server 2005 Import/Export not copying stored procedures
  301. instance of sql server
  302. Search Between Times
  303. Exporting sql data to specific cells
  304. Performance Question: Cursor-based vs Set-based
  305. Strange issue with SQL Table read only in Access
  306. Trigger Question
  307. security for row level but not based on Database user's login
  308. Any functions to replace NZ in SQL Server?
  309. SQL and Terminal on 2 different PC's
  310. Undo last statement
  311. SQL and Terminal server on 2 different PC's
  312. Selecting rows from one table that are not in the other
  313. Date (not datetime) datatype in 2005?
  314. Basic, perhaps silly SQLServer 2005 question
  315. Restoring Master on another machine...
  316. Efficient SQL Backup?
  317. Using IF inside SELECT ?
  318. Get all records from Last Two Days?
  319. SQL Server Backup File Format
  320. Timeout errors
  321. How to Get the 2nd the 2nd Record AND DISPLAY IN SINGLE ROW ?
  322. How to check werther sqlexpress is present on system while installation
  323. Time Over 24 Hours
  324. delete sql syntax for linked notes table
  325. wrong result set
  326. select * in views
  327. SQL 2005 Express vs SQL 2000
  328. MS-SQL Standard Memory Cap
  329. SQL 7.0 Stored Procedure Execute Privileges Only?
  330. Sum Accumulating Data
  331. Advice on middleware products for TRUE Scaling out of SQL Server
  332. selecting a set for min value
  333. How Do I Restore A Warm Backup If My Primary Server Fails?
  334. fmtonly problem (bug ??)
  335. Different query plans
  336. Left Joins and record insert problems
  337. SQL Server 2000 and 2005
  338. Count all records in all tables
  339. Linked Server To Lotus Notes
  340. SQL Query Question
  341. failover cluster using 64 bit windows 2k3 on single HBAs and DS400 with dual controller
  342. insert into temp table based on if condition
  343. Smalldatetime comparisons with non-clustered index
  344. Are sub-subqueries possible?
  345. Literal value with "IN" clause
  346. "group by" by excluding prefix
  347. Killing the process automatically
  348. find matching sets of rows
  349. SQL user and group audit report
  350. Time to shrink a database
  351. Inconsistent SQL results
  352. Looking for MSSQL table structure
  353. HELP with MS-SQL
  354. Some basic questions
  355. ## How to acquire the SQL Server 2000 Performance data? ##
  356. HELP with sql query
  357. Retrieving autonum / IDENTIFIER value from SQL table using DAO.
  358. UMS Scheduler Hang
  359. Remove Duplicate Rows
  360. Configuring Peer-to_Peer Merge Replication
  361. Need some practice
  362. What is a full-text index?
  363. Changing Domain for SQL Server
  364. Saving .mdf database
  365. Difference between multiple primary and secondary files..
  366. Re-display result set without re-running query in Query Analyzer?
  367. Disk or network error
  368. SQL-DMO and C#: retrieve the list of User-Defined Functions
  369. SQL Svr 2005 Express Does NOT Support DTS
  370. creation of table that type of format........
  371. Trigger Question
  372. Full-text Search applied on a View
  373. scripting objects in sql server 2005
  374. The database name component of the object qualifier must be the name of the current database
  375. Maximum number of records per second that can be inserted into SQLServer 2000.
  376. Help: 900 byte limit on stored procedure parameter?
  377. problem with count, group by and ntext
  378. check diskspace UNC via T-SQL
  379. Exporting From SQL SERVER
  380. SQL Server needs help from MS Access (or something)
  381. Auto Number
  382. MS buys Proclarity
  383. temp db
  384. SQL: how to display top 5 then sum the rest
  385. Incorrect Syntax using IF statement
  386. Getting all nodes and node details from xml using xquery
  387. SQL server express 2005 local accounts problem. please help!
  388. SQL 2005 Management Studio Bugs
  389. SQL Server 2005 vs Oracle
  390. datetime diff query syntax
  391. Calculate time lapse
  392. New to MS-SQL
  393. Installing database while setup
  394. Problem concatenating column values into string...
  395. XQuery vs OpenRowset
  396. programmatically restore a database
  397. Reversing string concatenation
  398. Transport Level Error has occured
  399. Scheduling DTS Package using a stored procedure problem
  400. rights issues with linked server
  401. How to make correct join
  402. Download image datatype to Jpegs or GIF's
  403. String Comparison using "Score Method"
  404. Dose MS sell SQlSerever with student rate?
  405. Row sequence number
  406. Row sequence number
  407. Testing Query Performance - clear out cache
  408. float numbers
  409. Passing a file path to a SP
  410. IF funcionality in SQL server views
  411. Are embedded views (Views within views...) evil and if so why?
  412. Complex query
  413. alter table column, which is part of foreign key
  414. Math functions
  415. JDBC Driver NOT throwing Exception
  416. error when trying to do datamining
  417. The transaction has exceeded the allotted time
  418. Illegal Immigration, the Non-Issue of the Week??????????????
  419. ERROR_STATE() Always = 0?
  420. Need a So-Called SSN Encryption
  421. Update SQL 2000 Query (converting an Old Access 2k query to SQL)
  422. SQL Server 2005 Client Tools
  423. Timeout Expired
  424. Bind Variable in CURSOR
  425. Timeout fixed by recompile
  426. Automatic statistics update
  427. Full text indexing with Japanese characters problem
  428. I'm sure this is an easy one...Error trap to skip over a "bad" object.
  429. Sqlserver Login and user
  430. Transpose Rows to Columns ?
  431. Hiding NULL
  432. Optimizing SQL - Union
  433. speeding up inserts
  434. Down and dirty database infrastructure
  435. 2005:how to find installed assemblies
  436. database design for fast client updates
  437. Stored procedure with unknown numer of paramters, how?
  438. Problem with a join due to multiple Nulls
  439. how to setup the permission of share fold in log shipping ?
  440. Stripping input mask from phone numbers
  441. SQL Consultant Required
  442. Cursor looping versus set-based queries
  443. Odd query plan for view
  444. Updating Linked Records Across DB's
  445. Select first n rows of table
  446. Sql server report
  447. Update Table
  448. Database poster
  449. Management Studio Express
  450. SQL Server 2005: Migrate DTS to Where?
  451. column name change
  452. How to fire a trigger without changing table data
  453. Row Numbers for a View
  454. ranged datetime predicates & cardinality estimates
  455. Order by in a INSERT INTO..SELECT
  456. Assigning group numbers for millions of data
  457. Where to write XQuery statements?
  458. I need help, please
  459. SQL Server 2005: Collation Conflict Error when selecting Database Properties
  460. LDAP authentication for Yellowfin on SQLserver
  461. Multiple Foreign Keys on Same Table
  462. Multiple Foreign Keys on Same Table
  463. Multiple Foreign Keys on Same Table
  464. Query/View: The 2 newest periods for each indicator
  465. Copying encrypted stored procedures.
  466. French characters are not imported properly with bcp
  467. Accessing Oracle Tables From Within SQL Server 2000
  468. Licensing Question
  469. SQL Server 2005 install - no Management Server
  470. generation of sql for an alter column etc
  471. Grant Win Acct Permission
  472. Help selecting an alias
  473. help with group by statement
  474. bug - insert miliseconds
  475. Website navigation hierarchy with SQL Server 2005
  476. connecting in a script to another db
  477. Optimising queries
  478. Help selecting the proper child record
  479. slow insert, logical fragmentation
  480. Performance Enhancements with Service Pack 4?
  481. Select 'Current LSN' and 'Transaction ID' from ::fn_dblog
  482. Connecting to another SQL Server
  483. Join returns more than one row, Post code regular expressions
  484. Update the salary of each manager to be double the average salary of the employees he/she manages
  485. SQL Server 2005: TRIGGER AFTER INSERT
  486. Maximum number of databases used for each query in 2005?
  487. Update n rows
  488. Monitoring SQL Server transactions
  489. Transactional replication without synchronizing snapshot initially.
  490. open MDF file without MSDE
  491. How do I change the default collation string of an installation
  492. SQL Server License Control and Management
  493. trigger to parse a string from insert statement
  494. Many to one Select
  495. Unwanted Sort
  496. Using OSQL and DTSRUN
  497. can you launch a crystal report from a sql trigger
  498. IDENT_CURRENT problem
  499. sql commands dont work in mssql????
  500. charindex question
  501. Joing tables using more than one field
  502. SQL script for changing all identical columns
  503. Resource for developing your own accounting software using MS technologies
  504. Job succeeds manually but fails if scheduled
  505. SQL--- GROUP BY Clause
  506. T-SQL Problem
  507. MS SQL server 7.0 restore/create
  508. Reporting a table with two columns from another table
  509. Help with a substring query
  510. Check constraint does not work (compare with null)
  511. Ink
  512. Possible to disable welll-formedness checking when inserting XML data.
  513. Row to Column
  514. add a column specified location in Table..
  515. Ink
  516. Design problem
  517. Query Problem
  518. bigpubs2000
  519. mysterious corruption of stored procedures
  520. SQL Server Maintenance Routines/Procedures
  521. Dell Raid 0+1
  522. Stored Procedure Help
  523. outer join column
  524. waittype=WRITELOG
  525. Delete Many Rows
  526. Help with INSERT TRIGGER - fails with error.
  527. Deploy .MDF to a web host
  528. To retrive a table from one database to and another database(same table)
  529. Alternative to OpenXML
  530. Memory allocation in MS-SQL 2000 instances
  531. SQL query - duplicate records - different dates - how to get only latest information?
  532. bcp right truncation: how to ignore
  533. 2000 vs 2005 -- AnsiNullsStatus
  534. Sql Server Performance
  535. Full text index on a view
  536. Performance
  537. query...
  538. query...
  539. change of value at the time of insertion
  540. Querying a column with brackets in its name
  541. Compare given period in current year / previous year
  542. Data Warehouse Nulls
  543. Selecting records by date - need a little help
  544. Getting previous values of a field
  545. Not grasping outer joins for ms-sqlserver :: 3 tables to join
  546. Finding the natural key
  547. Browser Time Out: when executing a DTS package
  548. Error in Query
  549. Communication betwee two tables
  550. DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )