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