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. Is it possible to avoid a loop?
  2. selecting max and min year
  3. selecting records based on date
  4. Importing text file fails
  5. Cannot find sql express trigger in object explorer
  6. Importing a notepad txt file into SQL 2000 Server
  7. Set a value for identity key
  8. restaurant database
  9. Sql server 2005 Remoting Configuration
  10. sql server 2005 enterprise - Max CPUs
  11. SQL server and MSDE
  12. user defined type as a primary key
  13. Error while saving Maintainance Plan
  14. Dts Problem!
  15. Exam:070-229-An Excellent Resource
  16. Not able to read data from some columns of an excel sheet while using sql server DTS
  17. Case sensitivity in SQL -- ignore
  18. Query help needed
  19. How to spool output in MS SQL?
  20. SQL Server 2000 Install:
  21. How spool the output on MS SQL?
  22. How to increase the default row size in sql server 2000 only
  23. problem while declaring a a cursor
  24. 'Like' withing CASE statement ???
  25. language problem of ms sql 2005
  26. SQL Query help
  27. Wishful thinking: SourceSafe integration with SQL Server
  28. SQL 2005 Backup Problems
  29. SQL 2005 Backup File
  30. SELECT statement returns duplicate rows when a single row is desired
  31. MS Sql 2005 Master DB sysprocess with ASP
  32. Return error with Automated sp date Variable
  33. A Search for SQLFiles
  34. How to show roles with permissions to objects
  35. Configuring SQL Reporting Services for SSL
  36. Restoring a SQL Server 2005 database in SQL Server 2000
  37. How To write a query to get all Names without starting with an alphabet
  38. download pdf
  39. Sql Server - Jobs
  40. Can i write T-SQL statements to skip other job steps
  41. default filegroup for creating indexes
  42. move indexes via ALTER INDEX
  43. how to select 200 first records from table?
  44. displaying something else in results instead of value in DB
  45. Remotely accessing SQL database
  46. Conerting MS Access query to SQL
  47. Scripted CREATE INDEX
  48. Create indexes - own File Group
  49. Increasing field sizes in Microsoft SQL
  50. Trying to add a NON-DISTINCT field to a DISTINCT record set in a query.
  51. SQL field character limit change
  52. pulling ntext values sql server 2005
  53. Identity reused problem
  54. How to Join
  55. Performance of Partition Merge in 2005
  56. CREATE VIEW - script to automate column names?
  57. Sub query as multiline column
  58. connecting problem in ms-sql
  59. SQL Server and Oracle on the same server?
  60. update a field drom another table
  61. Finding the earliest datetime entry, and then updating the database on these reults
  62. Stored procedure limits??
  63. MSSQL 2005 SP2 install error 2259 - what gives?
  64. Possible to run MSDE (2000) and 2005 Express at the same time
  65. Transaction Logs
  66. What is SQL Server?
  67. Incorrect syntax near the keyword 'WHERE'.
  68. A belated thanks to all who have helped in the past!
  69. index fragmentation LogicalFragmentation -how bad is bad - silly question alter
  70. Merge two tables with conditions
  71. How do i connect and operate with data
  72. SQL 2000 renaming columns in tables
  73. Select question
  74. SQUirrel installation
  75. Europe to Test 1000s Chemicals on Millions of Animals
  76. Time based event
  77. Parse fields
  78. Change Tracking in SQLserver
  79. Removing the duplicate rows from a database
  80. how does SQL 2005 store Non-ASCII values and how it will be displayed in VB 6?
  81. Best approach to sending field names dynamically
  82. SQL to combine columns
  83. Incorrect syntax
  84. need emercency help DoCmd.RunSQL Sql error
  85. Partition Merge Performance - Sql Server 2005
  86. SQL Server 2005 Transactional Replication problem
  87. Sql Help
  88. Creating "Cross Tab tables in SQL?
  89. I am trying to convert a MS Access Query to a SQL query and I need help?
  90. Backup of a MS SQL 2000 DB
  91. Trying to get the right registry key through sql script to change listen port
  92. restore differential backup *
  93. Long query rollback - can I rename the table?
  94. restore differential backups
  95. How to increase the default row size in sql server
  96. Shift or Copy Data from Sqlserver to MS Access using Stored procedure
  97. connection Failure - -3709
  98. how to fetch all databases from server
  99. BETWEEN now() - 6days???? AND now()
  100. 2000 to 2005 query processng difference?
  101. How to delete records from 2 tables
  102. Transaction Register
  103. Retrieving an integer value from a database function via PHP
  104. textcopy.exe failure
  105. Simple SQL Help
  106. get value of last item in column?
  107. problem executing dts package using xp_cmdshell in querry analyzer
  108. MS SQL - Copying data from one table to another in two different databases
  109. Updating one table when Insert in other table
  110. Using raiseerror
  111. Urgent Help needed in Sybase query
  112. Query to find Number of Working days in a month.
  113. Triggers 101 - Invalid Column Name
  114. query
  115. Update query from Select
  116. system tables in MS SQL server 5
  117. Most recent meter reading in a database
  118. Problem with trigger
  119. how to recompile / refresh UDFs ?
  120. CXPACKET and contention within TempDb
  121. Help with SQL Server 2005 Publication
  122. insert into linked server problem
  123. Table copy from 1 db to another
  124. Retrieving Day, month and Year separately from the date
  125. Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.
  126. dbcc shrinkfile
  127. Problems with transactional Replication in sql 2005
  128. SELECT DISTINCT Problem
  129. Delete and update
  130. Recommended:How to get control of you life and time
  131. Real to datetime - how to...?
  132. Unique constraint in sybase
  133. Collation Conflict
  134. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  135. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  136. Viewing events as they happen?
  137. Difference between the querries.
  138. Merge Replication Error: 'Failure to connect to SQL Server with provided connection
  139. Need Help migrating VBA to TSQL
  140. SQL Server 2005 DTS problem: "Error 21776: General Error"
  141. Replication on W2KP
  142. Debugging a stored procedure
  143. Problem modifying out-of-the-box TFS Report
  144. SQL2000 New Index for replication
  145. SQL7 Add new fields for replication
  146. SSIS 64bit to Oracle 10G
  147. How to normalize these relationships?
  148. Grouping numbers
  149. Year, Month, Count on an Invoices Table
  150. Arrays and lists in SQL 2005
  151. cannot exit from if else block
  152. SQL 2005 Database to take to other pc
  153. Something I'm missing with condition?
  154. MS SQL BACKUP problem
  155. Heap table: why 454 rows of two INT columns use 2 data pages?
  156. Recursive CTE Question
  157. Reporting services - SQL server 2005
  158. SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..."
  159. Write Data to two databases using SOAP/XML
  160. test
  161. how to change the first record go to last & 2nd record have to come to first??
  162. change rowset position at runtime
  163. How to Print Data directly to Text File using Stored Procedures
  164. CASE statement in Store Procedures
  165. Parallel Operation
  166. can any experts pl help me out in insert query..
  167. If statments in MSSQL
  168. Updating SQL 2000 server using VB6
  169. hi , query for displaying data
  170. bp server and e-mailing server lowest price Waiting for u
  171. Access and SQL Server Speed Comparison
  172. Access and SQL Server Speed Comparison
  173. SQL Query - distinct with 2 values
  174. Transaction Log File Compression
  175. SQL 2000 SP4 and SQL 2005 Express Co-Exist?
  176. Incorrect syntax near the keyword 'FROM'
  177. Excel DSN Query
  178. Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!
  179. How to find last record in sql server 2000?
  180. Transfer logins using Dts package - sql server 2000 standard edition
  181. Row_Number Function
  182. SQL Serwer 2005 + HP LTO Ultrium
  183. SQL Server Upgrade Wizard
  184. Client-Server App vs MS Access Data Project
  185. Script to ammend column data
  186. Joining tables
  187. SQL Help with purging old data
  188. Parameters
  189. Stored procedure to create a new database with tables
  190. Does anyone use SSIS for database schema maintenance?
  191. Need help with CONVERT function
  192. How to view all triggers
  193. Accessing which data caused a trigger to fire
  194. How to restore sql server 7 backup to sql server 2000?
  195. table columns
  196. SQL database name Alias
  197. Query regarding Tiggers.
  198. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn
  199. Reading a directory
  200. Help required!
  201. Last Table Access
  202. Stored procedures
  203. millions records archiving and delete
  204. help with a query
  205. SQL mail work around
  206. Problems with SQLXML bulk load
  207. Convert integer to datetime
  208. return duplicate records
  209. sum from two tables with two columns
  210. MS SQL SERVER via C programming
  211. Advantages and disadvantages
  212. How to get values from 2 tables
  213. export/import
  214. Create Table Script Incorrect syntax near 'Collate'
  215. Hexadecimal format .mdf file
  216. Importing DTS package to SSIS under x64 More options
  217. Visual Basic 6.0 + Crystal Reports XI + SQL Server
  218. newbe question: need a way to read in large query with .net
  219. SQL Server 2005
  220. How .BAK files are restored in SQL Server 2005
  221. which driver to use to make a linked server connection between MSSQL 2005 and Access 2007
  222. nvarchar & varchar
  223. maintaining a database?
  224. Is there an issue running SQL 2000 on a 2003 R2 64 bit operating system?
  225. Scheduling an Import in MS SQL 2005
  226. Which implementation will give faster result (Table design to Joins)
  227. faster count(*) or alternative
  228. Sql Query
  229. file share
  230. how many tables a dataset can store at a time?
  231. faster count(*) or alternative
  232. SQL Challenge - how to return a record set starting at a particular record?
  233. Copying .MDF & .LDF files for new server
  234. New database from backup
  235. INNER JOIN between a CLR-TVF and a table returns no rows
  236. unable to specify UNC path for restore through GUI??
  237. Help, did SP1 install work?? SQL Server 2005
  238. Splitting Date/Time Records
  239. Complicated count w/ subquery
  240. constraints across normalized tables
  241. SQL Help
  242. Non integer counting
  243. CASE in a Select Problem
  244. connect to ms sql from C# code
  245. CREATE TABLE and CONSTRAINTS
  246. Remove a character from a string
  247. Hi
  248. calling a php webservice in mssql server
  249. SQL 2005 compatability mode
  250. Current Database Context?
  251. ASP cannot run stored proc until the web user has run the proc in Query Analyzer
  252. SQL error
  253. Query for the first and latest wish
  254. How to run replace on all columns
  255. Methodology
  256. test
  257. test
  258. Return Columns along with MAX Value
  259. Format money value as padded string
  260. SQL statement - INSERT INTO and SELECT
  261. error for sending(saving) data to database
  262. error for sending(saving) data to database
  263. Insert Date as Formatted String
  264. SSIS declare output
  265. Getting an Error while attaching the database using System Architect Enterprise manag
  266. Struggling with date in query
  267. Move clustered indexes to new filegroup
  268. problem with date range
  269. parameterized view in SQL SERVER 2000
  270. How to Union dynamic tables
  271. T-SQL for the following?
  272. Somewhat complex report
  273. Output results to text with formatting
  274. timeout or re-trys.
  275. Replication and Reports
  276. Invalid column name using BCP
  277. Just a quickie..
  278. Restoring the .bak in MSSQL
  279. Iif MDX Strings
  280. Use RTRIM function on TEXTBLOB (text) field
  281. Error for saving data
  282. storage format of image in SQL server
  283. Microsoft Releases SQL Server 2005 Service Pack 2 (PR Newswire via Yahoo! Finance)
  284. Unicode characters (Japanese)
  285. How to run profiler from cmd
  286. What is the best availability and backup solution?
  287. Storing variable values whilst using cursors
  288. Subquery and display help
  289. Is there a Query Analyzer
  290. Help w/ installing SW on SQL server (2005).
  291. Partition Scheme using a function
  292. Stored Procedure, error when executing (
  293. Restore SQL DB with correct logical file names
  294. resetting Identity Seed on change of primary key
  295. Select Statement Issue - Date Formating/Selecting
  296. SQL Deployment tool
  297. Ho Do I Implement Ms Access Dsum() Function Within Ms Sql
  298. My Sql
  299. creating a database link between DB2 and SQL server
  300. Function to return "remaining" of field after it finds a character in the field.
  301. Simple function for returning a character based on search criteria..
  302. SHAPED SQL: Need help!
  303. Int / Int does not give decimal value
  304. Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table
  305. how to take backup through network in MS SQL 2000
  306. Support for Spanish and English language
  307. Stored procedure
  308. SELECT *
  309. SQL 2005 AND SQLXMLBulkLoad
  310. a substitute for UNION?
  311. Returning an existing column OR the scope_identity
  312. SP2 for SQL Server 2005 is out
  313. How can we insert data through triggers
  314. adding the vc express bundled sql server to odbc
  315. Installing Ms-SQL 2000 with Win XP Pro on Stand alone computer
  316. Performance of SPROC changed by dbo. prefix
  317. Best method for inventory insertion
  318. Improving performance
  319. Fresh SQL Server 2005 giving problem in accessing access 97 file through Jet Ole DB Provider
  320. sql server 2000 robo copy
  321. Inner Join on Partitioned View
  322. how to parse a string in mssql
  323. MSSQL and Unicode data
  324. SQL how to view the list of tables in DB, the columns in the table, stored procedure
  325. Ms Sql Server Giving Timeout Expired
  326. SQL Server Link Server
  327. SQL Server Runtime?
  328. query
  329. Question About a Check Constraint
  330. Violation of primay key
  331. Writing SQL Help
  332. sum a table within a table
  333. How to Access MS Access File in Stored Procedure ?
  334. count records in several months
  335. Question on deploying .SQL files
  336. A trick query.
  337. SQL 2005 AND SQLXMLBulkLoad
  338. ms sql server
  339. Connecting Sql Server 2005 on Windows 2003 using ASP local
  340. Full bakup of Data
  341. Change Object Ownership
  342. A list of autoexec stored procedures
  343. T-SQL Gathering fields from a table
  344. T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?
  345. Possibilities to restore an old database
  346. Sqlserver
  347. Sql Local Server
  348. SqlServer
  349. tempdb is full error in sqlserver2000
  350. Package 'Microsoft SQL Management Studio Package' failed to load
  351. trying to group by two diff criteria
  352. Invalid object name '#temp'
  353. Auto gen record id as alphanumeric values
  354. Encrypting mdf files
  355. Restoring from transaction logs to running database
  356. Where the database is in SQL Server 2005 ????????
  357. Syntax, please :-((((((((((((((
  358. show number of values as % of total records..?
  359. Blobs in SQL Server
  360. Kill connection
  361. Updating Multiple Records Based On Records Returned By A Select Statement
  362. Performance
  363. Whats wrong here?
  364. Sql server process memory question
  365. Put 3 tables with same fields into one
  366. ORA-04091: table is mutating, trigger/function may not see it
  367. cursor in Stored Procedures
  368. Merging contents of one db to another huge db.
  369. Imprting to a parent and child tables from two csv files using dts package
  370. Backup and restore database hourly: how to implement it?
  371. Replace Multiple Spaces with One Space?
  372. export database structure
  373. restoring to a point in time
  374. MS-SQL question about GROUP BY
  375. Delta compression of query results
  376. .BAK extension file ??
  377. SQL Server losing sql code in stored procs...HELP!
  378. need help and advise with database
  379. delete records from one table that occur in another
  380. Urgent Help
  381. cannot write logfile Error 1059 : Circular service dependency
  382. in query, how can I compare string?
  383. Trying To Change Identity On Field W/Data In SQL Manager
  384. string matching in T-sql
  385. Basic Questions
  386. Project Planning
  387. Can't Connect to SQL db
  388. Can't Connect to SQL db
  389. Running access 2000 ap on sql 2005 express edition
  390. How do I use a variable to modify this sproc?
  391. Counting Orders for the Day
  392. specific records returned from 3 views using sql
  393. Getting a best selling brands list
  394. PIVOT query - access to mssql - help wanted!
  395. Order by - testing on true/false
  396. Memory Config (2005 Standard + x64 Win2k3 Enterprise)
  397. scripting data
  398. updating a stored procedure
  399. Link Tables
  400. Java DatabaseMetaData and MS SQL 2005
  401. returning one single record rather than multiples
  402. Callable statements, SQLServer and JRun
  403. Callable statements, SQLServer and JRun
  404. Trigger does not affect the code written in the loop... pls help its urgent
  405. SQL Format Function "0000"
  406. Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite)
  407. SQL Scripts
  408. Migrating to 2005, need advice
  409. Problem with SQL server 2000
  410. SQL Data concatenation
  411. which one is faster...
  412. Replication to a Custom OLE DB Provider
  413. Problems loading SQL server 2000
  414. vb with sql server
  415. databases
  416. Text Functions in SQL ...
  417. [SQL server]Could not find the index entry RID
  418. SSIS Import
  419. sql 2005 upgrade problems
  420. Log File is Full error: How to prevent this happening?
  421. Can't connect to SQL Server(SQL Express) in VS 2005
  422. Large number of INSERT statements - not all are executed
  423. Hanging Query
  424. Learning SQL Server with Win XP Home
  425. get record with earliest datetime value
  426. DTS Package Execution (From Job)
  427. Where is my dts?
  428. How to move table data in one server to another server
  429. Convert Access to SQL Server
  430. Inserting wav data
  431. Creating maintenance plan wizard problem
  432. Importing DbaseIII data to sql 2005 using asp Coding
  433. CentOS2.6/apache2.0/MsSqlServer2005xpress/CFMX7
  434. sql data value unrecognized
  435. Optimizing a big query
  436. Backup fails using SMO with big databases
  437. Full date value not being written via JDBC - any ideas?
  438. create table
  439. Stored procedure returning wrong value because of ANSI_WARNINGS
  440. Effective permission for a group
  441. how to normalize
  442. compare in database
  443. Need advice on system performance
  444. xp_cmdshell sql server 2000
  445. Column update structure change
  446. Need help running query on data/time field
  447. odd stored procedure behavior
  448. RE: Combining multiple databases into one
  449. Can this deadlock issue
  450. Locate rows in table where column value missing (I think!)
  451. Why optimizer is not smart? Is dynamic SQL my only option...
  452. Date function
  453. Wifi Barcode scanning -- need middle ware help
  454. Dynamic SQL does not work!
  455. Sql Server Enterprise manager and stored procedures
  456. SQL Server 2005: Unable to add SQL2000 subscriptor using non-standard port!
  457. web service in MSSQL
  458. APIs for monitoring MS-SQL
  459. Connecting SQL 2000 using SQL 2005
  460. how to check sql port
  461. Exporting sql server database
  462. Monitoring memory usage
  463. Using parameter on Query condition not working
  464. Link Two tables
  465. Stored Procedure querying another database
  466. Query RowVersion in SQL Server 2005
  467. Increase speed when retrieving data from a Hosted SQL SERVER into VBA
  468. looking for a consultant
  469. "insert on existing update" in MS SQL Server?
  470. Users Can see all the Database
  471. NULLS and ''
  472. SQL job error
  473. @@Error not catching error.
  474. Migrating SQL logins with password
  475. sql server 2000 in window service
  476. Uargent Oracle-DBA professionals required
  477. T-Sql for changing the Owner of the table objects in a database
  478. Exporting data from SQL table to Excel File - How to delete rows before inserting new
  479. great tool to compare data from two different queries
  480. Stored procedure and SQL Job Agent Task
  481. MS SQL using TSQL via JAVA jdbc
  482. use of union in indexed views
  483. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  484. "ODBC--call failed" Error
  485. Need help writing T-SQL statements?
  486. Problem: Performance difference between MSDE and SQL Express 2005
  487. Using DTS to migrate Access ot SQL Server
  488. Print data through Store Procedure
  489. Using LIKE in a CASE statement
  490. I don't understand this "server timeout"
  491. Doubt about SQL Server
  492. creating backup of MS SQL database
  493. VB Code to BackUp Data from SQL to Access
  494. SQL Server does not exist or access denied
  495. replacing join operation in XML
  496. Bulk Insert
  497. Noise words issue in full text seach Sql server 2000
  498. How to remove rows where only part of the row is duplicated
  499. SQL Slow from MSDE 2000 to SQL Express
  500. SQL a range in the all dataset
  501. any way to debug stored procedures without buying visual studio?
  502. Ansi SQL92 question
  503. SQL Collation Problem
  504. Why transaction gets promoted to Distributed transaction
  505. monitoring applications querys
  506. How may cause Record disappearing from table ???
  507. MS SQL 2005: Where clause and optimizer
  508. Software Developers/Programmers
  509. How do I determine the backup date of a restored Database..?
  510. filtering data correctly?
  511. Trouble with getting this query
  512. SQL Server 2005 order by date does not sort properly
  513. Getting a count from multiple columns
  514. why i can't post message here? tried twice.....
  515. bcp and trigger: missing data in bcp out file
  516. bcp & trigger: got missiing data in bcp out files
  517. Querying towards a responsive UI
  518. Arcserver 7 Backup With SQL 2005
  519. SQL Query - Newbie help with summaries
  520. Need help with error 17137
  521. I need SQL Query Help
  522. extract data from SQL .mdf file?
  523. How to Execute a Query Stored in a variable in Stored Procedure
  524. Failing to launch
  525. Database security
  526. urgent requirement for project leader/apm required
  527. BCP error - missing data
  528. BCP error - missing data
  529. Help With complex SELECT
  530. SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases
  531. Update Statement
  532. Varchar to Integer Typecast
  533. HELP! Synchronize db and maintain foreign key relations?
  534. T-SQL, Cursors, Best Practices of pulling from multiple tables
  535. DTS and SOAP Web Service
  536. 10080 sql server 2005 configuration caused error?
  537. DTs and Buisness Intellegence
  538. filter data by row number
  539. Create DTS package validation
  540. SQL Server CE
  541. Updating online SQL 2005 database from local database
  542. how to compare value of two fileds and based on that insert value into third fileds
  543. select a data from sybase table to sqlserver 2005(its urgent)
  544. how to use rowcount to delete rows?
  545. 1st Image Control Shows Wrong Image
  546. Bulk insert rollback
  547. How to auto-generate age field when DateOfBirth is given in SQL Server.
  548. JOIN columns question???
  549. intermittent OLE DB error
  550. sending email from SQL Server 2000