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. asdb - what is it? Shold I back it up?
  2. Need to convert cursor
  3. Database Migration from MS SQL Server 2000 to DB2 on Z/OS
  4. Order By Start_Date
  5. Migrating MSSQL2000 to MSSQL2005
  6. Urgent....please respond
  7. Caculated Fields in a Query
  8. Northwind - execution plan bug? Why Index Seek and no Bookmark Lookup?
  9. Querying information between two values
  10. How can you track user actions in a table?
  11. How to calculate response time.
  12. Relationship between two members - HELP!
  13. PLS.... Help!!!
  14. calculation of subqueries HELP
  15. memory 64bit windows , 32 bit Sql
  16. Joining two tables keeping columns independently distinct
  17. set default precision on decimal type?
  18. Searching for SQL Servers in AD
  19. PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"
  20. PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"
  21. MSDE, SQL Server Replication & Local Admin Rights
  22. convert scientific notation to to decimal
  23. to store pictures
  24. Searching for Last DateTime
  25. How to copy database to another SQL server
  26. Snap-in failed to initialize
  27. union with Rank create duplicated records
  28. Asymmetric communication from ms-sql-m protocol from an SQL Cluster
  29. Problem with a stored procedure
  30. Server Properties
  31. Problem opening Access forms and macros from database residing on a Windows 2000 web server using IIS
  32. help me in retrieving the value
  33. Track the changes to normalised tables and update the denormalised tables depending on the changes to normalised tables
  34. 'Select top 10 * ...' returns data but 'Select * ..' does not
  35. Marketplace: Yellowfin reporting 3.1 with BIRT Integration
  36. Converting Columns into Rows without affecting the data in the table
  37. Column Alias Issue
  38. Authentication Issue with IIS
  39. SQL 2000 Bulk Insert attempt on FTP in progress
  40. Adding text to a column!
  41. sql 2005
  42. SQL 2000 Full Text Catalog problem.
  43. Median?
  44. Exec stored proc from select in another stored proc
  45. select count(table) problem
  46. Error handlig in Query Analyzer
  47. FOR XML PATH + file structure
  48. Any Inbuilt function like Oracle's ROWNUM to retrive the order of records
  49. CASE in WHERE clause?
  50. Views / Performance - 2 Rows to 2 Columns
  51. Import multiple .DBF files w/SSIS - OLE DB
  52. Identifying foreign characters in rows of data
  53. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
  54. Improving the Performance (Millions of Records!)
  55. CASE in FK
  56. connection of sql server via vba
  57. Error :ITransaction::Commit or ITransaction::Abort was called, and object is in a zom
  58. Working with Ints and Nulls
  59. Simple question about stored procedure
  60. Grouping into a Concatenated String
  61. I got "System.__ComObject", Where is my SQL record value?
  62. Dts and Dates
  63. Append to a field in a database
  64. How To use OLE Control like MS Access on SQL Server
  65. Date formats
  66. Table field merge
  67. How to purge errorlog?
  68. SQL server 2000 and PHP
  69. How i can see how many user using database?
  70. DTS Package issue
  71. Batch Jobs ..
  72. query sql server using xml dynamically
  73. MS SQL 2000 installation corrupt
  74. Connectivity Issues in SQL Server 2005
  75. MSSQL and UTF8
  76. Setting foreign key on insert
  77. LIMIT problems
  78. Need Help Getting the day shift after midnight
  79. SqlServer2005: Transfer Sql Server Objects
  80. To Retrieve date stored in type INT
  81. sql data recovery?
  82. Table Partitioning on a RAID 5 Server
  83. Sql 2000
  84. Update - can I do better statement?
  85. connectivity between sql and vb
  86. 10 Random records, 1 from each category
  87. Enterprise Manager reporting wrong server version
  88. Select Distinct Error ??
  89. Windows authentication
  90. PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
  91. Help on UPDATE with EXIST
  92. Create SQL database with C#
  93. Stored Procedure looks at sysobjects and process info in each table
  94. Oracle Sequence/Link 2 MS SQL SERVER 2005
  95. Find 2nd Working Day
  96. to get the structure of the table
  97. Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
  98. SELECT UNTIL ?
  99. Update Deadlocks on Primary Key index
  100. Need Emergency Help with SQL Query (difficulty: moderate)
  101. How to import from external SQL database to local SQL database
  102. "cannot find the path specified" when setting up replication
  103. Aggregate functions and locking
  104. using variable as WHERE clause
  105. Syntax for reading in a txt file
  106. Replication - Multiple Distributors, one Subscriber
  107. Insert a field from a table to another.
  108. Find records that comply with either or criteria
  109. wild characters in stored procedures with parameters?
  110. Design Solution Required
  111. Dts . .
  112. Please I need help with table partitioning in SQL 2005
  113. adding up column values (asp & access 2000)
  114. How do I recover data from SQL Server's log files?
  115. To access real time data from remote server to local DB
  116. Inserting Multiple Rows into one table (with calculated fields)
  117. Fiscal year search
  118. SQL 2000 Replication via Internet
  119. SQL Server 2005 objects question
  120. (Announce) Jonathan Robie Will Present at 2006 XML Conference
  121. Problems with Adding text
  122. Collation setup for SQLServer2000 Standard Edition
  123. UPDATE JOIN TOP 1
  124. Conditional Constraints on table columns
  125. SSL encryption for remote SQL server
  126. import and export data
  127. Continuously querying a datastream using SQL Server 2005
  128. How do I create an Insert trigger to copy a table
  129. left outer join ( =*)
  130. How to Save MS Word/Excel Files in Database?
  131. Truncating or shrinking a 65GB Log File with available 2.8GB harddisk space
  132. are wombats good?
  133. where are wombats?
  134. using vbs
  135. Equivalent to SQL Anywhere GET_IDENTITY?
  136. richie robles
  137. Update Query using XQuery
  138. Some XQuery/SQL Server 2005 help please
  139. Default "Auto Close" to no for entire server?
  140. Select statement
  141. How to export SQL Database properties
  142. Performing mathematical operations on Table columns
  143. DTS Data Driven Query vs. Query Analyzer
  144. Error With EXEC sp_attach_db
  145. Need Help to form the MDX-Statement
  146. Transposing repetitive serial fields into Table structure
  147. Replication
  148. How to get the total time of the records in a table
  149. mssql_connect problems
  150. Cross Tab query in SqlServer
  151. Maximum number of Tables - is 4^15 big a number?
  152. Triigers FOR in Merge-Replication
  153. Linked server and text file...
  154. New to SQl Server
  155. NEW to SQL
  156. DTS - Need to Set Destination Filename dynamically
  157. got an error
  158. help needed to fix an error
  159. Waarde uit tabel incompleet
  160. SQL Server 2005 Database mail Command not supported (502) SMTP error
  161. Which Replication Method To Use
  162. HDD still full after shrinking transaction log
  163. How to build a procedure that returns different numbers of columns as a result based on a parameter
  164. Error 0x80040E31
  165. MS SQL server and (missing) ANSI DATE-datatype
  166. help
  167. CONVERSION FROM CHAR(4) TO DATETIME
  168. Exclusive connection MSSQL2000
  169. Pls Help With JOIN query...
  170. sql question
  171. One Record from many tables
  172. XML Data type storage
  173. restore sql 2000 bak to 2005
  174. Variable in while loop not getting incremented
  175. Permission to create views
  176. Xquery Help SqlServer2005
  177. ODBC database slows down over time
  178. Update Trigger
  179. Insert Data into a table
  180. SQL Active Directory Query
  181. Updating 20 some servers
  182. record locking in MS SQL
  183. User unable to update database
  184. Shrinking database log used for mirroring
  185. Severe performance hit with NCHAR queries
  186. Sql Server Distict
  187. float vs decimal
  188. float vs decimal
  189. Link two tables using union
  190. how to find the unique key and foreign key reference given the table name in MS SQL
  191. Have two identical SQL Servers
  192. Any suggestions??
  193. Database updates (using SqlDataAdapter) during runtime but Database Table Does Not Update
  194. Database Updates During Runtime But New Data Does Not Appear in Data Tables
  195. Manual back of database error
  196. Conflict With Network Communications
  197. Sum hours from the date on this row thruout the rest of the database.
  198. SQL select question
  199. Database Cloning
  200. case insensitive
  201. UNIONs and Running Totals
  202. Export SQL05 data to Access
  203. Create Database using C#
  204. A new approach to storing ordered hierarchical data in RDBs.
  205. How to deploye SQL 2005 Express with my application
  206. login and privileges effect on optimizer's choice of plan
  207. How to Add New Line Character in Database in Ms - Sql
  208. dynamic query
  209. math error
  210. Extending or Linking to ASPNET.MDF?
  211. How is better to get SUM OF COUNTs
  212. SQL Server Installation Error
  213. Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
  214. appending two datetimes which were converted from strings
  215. Clearing up cache selectively
  216. Maximum Date in a group of records
  217. How to Identify an Array
  218. PRINT 1/(1+26)=0?
  219. Microsoft Open Licence Program - What is it?
  220. Getting Data from SS via HTTP
  221. Count Query Question
  222. Help with FOR XML - How do I return the results like this?
  223. SQL Server Upgrade
  224. Insertion Time problem with SQLAIW32.DLL and SQLAKW32.DLL
  225. noise words in my full-text search condition?
  226. Connecting to more Database
  227. HELP... ihow to mport .txt files into sql 2005!!
  228. SQL Server 2000 + 2005 working on same windows 2003 server as seperate instances
  229. how to swap the value of two colum in the same table
  230. SQL express-solving 4GB size limit by multiple database files?
  231. How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum
  232. Configuring SQL
  233. Configuring SQL
  234. Converting database to MS-SQLServer from PostGRESQL
  235. primary key
  236. different database
  237. top 5 rows without top keyword
  238. strings with sql
  239. In
  240. What am I doing wrong here?
  241. SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE
  242. how to script binary data
  243. Yellowfin leads the new players in taking business intelligence mainstream.
  244. Querying 5 tables: SQL using MS query
  245. Best practice for database migration
  246. Help with a complex UPDATE query
  247. Backup Strategy for MSSQL
  248. Optimize query
  249. Databases
  250. How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum]
  251. How to configure a PULL SUBSCRIPTION?
  252. Plz Help me out in this query
  253. import/export utility
  254. SQL Server 2000 Replication problem
  255. Very new to SQL
  256. OLE DB provider "MSDAORA" for linked server "infonet"
  257. How to pass parameters from Visual Basic to SQL Local Package
  258. connection strings problem solution
  259. round to nearest WHOLE number
  260. DTSRUN.exe install
  261. strange results when calling a sql stored proc from within an Access2000 project
  262. Sending a string from a mssql to another server, using the port number and the ip-adr
  263. How to join a table of a local database with a table of Remote database.
  264. Problema Server.-
  265. Problem with WHERE IN
  266. how to use cairage return chr(13)
  267. How to search % in a query
  268. 2005: SSPI library problem
  269. Problem Accepting Null values
  270. database connection with oledb provider for sql server
  271. foreign key to multiple primary keys
  272. SQL tables and relationships
  273. Simple Script to create DB, specify file location and set owner.
  274. Delineating Factors for Code Placement
  275. Grid vs Text output
  276. Select Query - can I use a Pivot table?
  277. Nested Inner Joins
  278. splitting SQL 2000 db into multiple file groups - how?
  279. snapshot agent failure on unknown table
  280. I want to revert back to original state of database before i performed restore database
  281. Reclaim Reseved Space(MSQL) to OS
  282. how to find unknown table name from databas
  283. Converting a file into multiple tables
  284. problem with trusted connection (asp.net)
  285. combine 2 database into one
  286. SQL to calculate surrounding suburbs
  287. Modifying sp_password
  288. Replication merge instance is not find in Performance Viewer
  289. ODBC Excel - SQL 2000 has but not 2005?
  290. Help needded in Sql2000-Triggers
  291. How do UPDATE
  292. Using temporary tables within the stored procedure
  293. Using a temporary tables within the stored procedure
  294. Conversion Of Sql Statement To Db2
  295. COUNT FUNCTION ON MULTIPLE COLUMNS
  296. General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
  297. SLOW performance on table with image fields (SQL 2000)
  298. Automatic Fields
  299. Len Trim
  300. default is NULL
  301. case sensitivity
  302. 200611 to string 'Nov 2006'
  303. T-SQL Question
  304. primary key
  305. UPDATE & INSERT speed improvement question
  306. MS SQL/ADP loses records
  307. Trigger on an Access database?
  308. Multiple col ina single col
  309. Help for Sql Query
  310. How do i find indexes of the columns in SQL server 2000???
  311. Rolling up spans without breaks between them
  312. Some Data from SS2000 to Oracle : Options ?
  313. xp_smtp_sendmail error disconnecting from mail server
  314. Subquery problem
  315. Non-patched version of MSDE
  316. Nested Tables
  317. How To Connect SQLServer Via a Remote Access Service (Dial Up)
  318. SQL Server: How to shirnk the Bakup file
  319. Instance Licencing
  320. FOR XML not working in a subquery
  321. Need help in retrieving distinct from duplicate column from related column list
  322. Using COUNT FUN and CAST
  323. Tuning Stored Procedures, sub-tree cost, cpu time, and reads
  324. SQL database Diagrams
  325. WHERE columnName = 'this' AND anotherColumnName IS NOT NULL
  326. How to loop through this sql table and display in ms access listbox
  327. First Posting
  328. select records between dates - query works in VS 2005 but it doesn't in asp 3
  329. Schema changes to SQL Server
  330. Transfer data from an excel sheet to table in sql data base
  331. Retrieve data using multiple select
  332. How to execute a DTS Via a stored procedure
  333. mysqladmin: connect to server at 'localhost' failed - MySQL
  334. Query Data using multiple select statement
  335. single quote
  336. Among Numeric and Float
  337. Adding a new Column after a particular column
  338. Survey...Please help and respond!!
  339. Actuarial sql statement Need Help.
  340. hii
  341. Please Help With Complex Update Statement Logic
  342. parameters
  343. sql server
  344. ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' '
  345. how to store photos in sql server and...
  346. Trim function
  347. how to remove leading tab from string
  348. prevent one single row from being updated
  349. regular expression issue
  350. Help with joining/selecting values to show
  351. Select Unique Distinct records for Column
  352. Select Unique Distinct records for Column
  353. Error on updating/adding record
  354. SELECT Problem
  355. SQL with greatest date
  356. help me in sql server codes
  357. Use of Model database
  358. Changing column values on table insert trigger
  359. Stored procedure issue!
  360. t-sql turn off a cpu
  361. Getting Error code from SqlServer to FrontEnd Application
  362. DTS Package Import
  363. MsAccess/ADP - record source doesn't exist
  364. Return dataset in one column
  365. data recovery, after overwritten many times mistakenly
  366. Please any one try to solve this. its Interesting.
  367. Basic Replication trouble.
  368. decimal problem... help please
  369. Get Data From an open Excel Sheet
  370. Remote SQL Server Backups over Internet
  371. How can i solve this problem?
  372. SQL 2005 & MSDE 2000
  373. Copy databases from SQL 2005 server to SQL Express
  374. help needed
  375. BETWEEN returns invalid data
  376. SQL Query Analyzer
  377. Getting back set order from the IN param
  378. Hot to inser row in a table
  379. sql server 2000 cluster issue.
  380. Connecting to an SQL Server using a workgroup
  381. Databases in SQL Server
  382. what does this (+) do?
  383. MSSQL Replace() for first occurance?
  384. creating a database in SQL 2005 - using windows 2003
  385. Problem with IN statement in Stored Procedure
  386. HELP - need a function like MID in access
  387. Embedding sp in to one transaction
  388. using trusted connection from unix
  389. LEFT and string function
  390. SQL query filtering date field by today's date?
  391. get 5 latest invoices (based on InvoiceDate) for each customer.
  392. Lock Problem and application is slowed down
  393. Datetime output diffrent in C# and MSSQL
  394. Connecting to 'localhost' Problems?
  395. importing blobs and other monstrosities from oracle 10g to sql server 2000
  396. looking for beta testers: new SQL comparison tool
  397. Publisher is empty under Replication Monitor - Publisher.! But replication is still running fine..
  398. MAX(DATE) - help
  399. convert / group by date
  400. SQL 2005 -- export table to a "fixed width" flat file -- Posting again
  401. where DTS in SQL 2005; Oracle to SQL2k5??
  402. Sql 2000 Replication
  403. Percentage returning 0 values
  404. Low process speed Large scale storage question...
  405. Tricky group by date problem
  406. query to find a sum of char values present in different rows
  407. Can't connect to SQL Server from Novell workstation
  408. Point in Time Restore
  409. Execute Extended Stored Procedure in user defined function
  410. .
  411. Stored Procedures and Functions
  412. Problem with executing DTS package !
  413. Runnable master awaiting command
  414. Create and then USE a dynamically-named database?
  415. FoxPro vs. SQL
  416. Trouble with Informix datatypes
  417. SQL 2005 & Login Triggers?
  418. Too Many Columns Found in current row
  419. How do i update I record in a table via a Trigger?
  420. Merge 2 queries
  421. SQL views
  422. Direct Client - Long term project for C#,SQLServer, ADO.NET in NY/NJ/PA, US
  423. CASE Help
  424. Database Migration
  425. Comparing Database Data
  426. setting up witness on SQL SERVER Express
  427. SQL 2005 - Export table to a fixed width file.
  428. Encryption keys for Reports Server
  429. Linked Server
  430. Importing text files - DTS help needed
  431. Query related to SQL ERROR
  432. URGENT Connection Ctring help!
  433. Need to declare multiple values
  434. Weird errors when trying to insert with IDENTITY_INSERT on!
  435. Precision Problem
  436. CASE: cannot test for empty string
  437. How to convert binary data to string?
  438. 3 / 2=1? Strange result in expression...HELP!
  439. ACCESS ADP TransferSpreadsheet
  440. Running a DTS with parameters
  441. Selecting TOP X child records for a parent record
  442. Help: Stored Procedure performance issue.
  443. How to Update 1 field with the value out of another row
  444. Indexing on UniqueIdentifier type column
  445. Urgent, Time out Expired/ need something to do from SP itself...
  446. index tunning
  447. SQL Server Client
  448. SQL Scrip help
  449. SQL Web Service Stored Procedure
  450. SQL 2005 CLR run out of memory.
  451. Filters on the data
  452. Filters on the data
  453. Trigger issue on Mass Insert/Update
  454. Import Specs
  455. SQL2005 - don't see my database when I use VPN-connection
  456. Sequential Number in an Update
  457. 2005 connecting 2000 ?
  458. view works, but the sql from the view does not
  459. use variables in WHERE doesn't work?
  460. remote desktop and db performance
  461. SQL 2005 express and linked tables
  462. How to load jpeg file in SqL2000 and how to retrieve from SQL2000.
  463. DBCC Memory Status and Query Plan
  464. move/upgrade MSDE to SQL 2000
  465. MIGRATING
  466. database analysis
  467. Duplicate rows in the Dataset!
  468. How Can I Ignore Accsents and diacritical marks in WHERE statement
  469. how to get the time a table was analyzed in sap db ?
  470. Copy Database Wizard across domains?
  471. SQL 2005: Unable to edit linked table records
  472. use IF in WHERE clause?
  473. TOP N Value per category
  474. Encryption of SQL Express database with password
  475. Error after upgrading from MSDE to SQL 2005
  476. Help with a query
  477. How to find query plan for a stored procedure using temporary tables
  478. Return subquery rows as one delimited column
  479. Migrating from JET to SQL Express database - Using Deltek and MSAccess softwares
  480. How to exit from script when find one DB does not exist?
  481. Question on scripting
  482. Data Execution Prevention (DEP) - SQL Server 2000/2005
  483. simple way to convert '1900-01-01 17:12:00.000' to 5:12pm?
  484. Scrambling sensitive data
  485. reference an outer column from a sub query
  486. DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTS
  487. using PK as Field Name?
  488. .NET 2.0 and .NET 1.1 co-existence?
  489. What am I doing wrong here?
  490. The best methodology to test load script
  491. this is very urgent,please help me
  492. Passing a parameter to views
  493. ExecuteScalar returns null
  494. Posting Guidelines
  495. two versions of sql on one server?
  496. Query autocomplete in SQL Server Management studio?
  497. Help with an update query
  498. Grouped rows inserted into columns
  499. Defining Database with Local Variable
  500. use INSERT INTO with a VALUE which a variable
  501. Duplicate Column
  502. how to load old datafile
  503. SQL Server Sizing - Hardware requirements for SQL Server 2005
  504. ComboBox items from a column in a database table!
  505. Installing SQL server 2000 on windows 2003
  506. Generate SQL Script
  507. Enterprise Manager takes 10+ min to open
  508. Restoring multiple transaction logs
  509. Order of GROUP BY - does it matter?
  510. If Staement
  511. Use array in SQL 2005?
  512. I have a basic question about SQL server
  513. Simple beginners question about stored procedures
  514. Testing load scripts
  515. Monitoring Inserted data and comparing against selected data
  516. Import Excel file into SQL Server
  517. Group By Query Casues TimeOut Error
  518. Query with Group By Causes TimeOut Error
  519. Group By Query causes TimeOut Error
  520. Possible Bug in SQL2005 query?
  521. triggers to transfer to other db
  522. Need your help to remove spaces in the column entries using SQL
  523. ASP SQL installation error problem
  524. Variable in a string problem
  525. Simple update query is making me lose my mind...
  526. SQL Script to find User Names in User Databases
  527. How to run a SQL script from within a VC# code?
  528. making JOINS
  529. Accessing specific records
  530. reindex
  531. SQL Reporting Services
  532. need help on store and compare time?
  533. Store procedure doesn't work for web application.
  534. How do you conditionally fire a trigger (mimic replication)
  535. No Local instance with SQLServer2005 Dev. Ed.
  536. communicating msde with sql ce for pocket pc
  537. Progress DB to MS SQL Server 2000 Sync (Copy) Delay Problem
  538. Need help in writing a VB Script in DTS to establish relation with WMI resources
  539. unable to run mysql server 5 on windows
  540. Making Connection to SQL
  541. Query Problem in Access
  542. retrieve data from 4 tables
  543. MSSQL insert into data conversion problem
  544. Coalesce / Comma Delimitted List
  545. How to combine 3 SQL statements into 1?
  546. SQL 2000 Text Field Problem
  547. JOIN / subselect problem
  548. Sql server Enterprise manager
  549. deleting a backup device
  550. Modeling