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