• Backing up SQL Server with specific settings

    I have set up my SQL Server backup using the native backup and restore option, but I want to have the files append for 5 days and then have the original file overwritten for the next 5 days. Right now, it's set to append the entire time, and this fills the disks rather quickly. How can I achieve...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2008

    How to format crlf inside a field text

    2601515 pointsBadges:
  • SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

    I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?

    Ftornoe40 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • ABT database backup from SQL Server 2000

    hi please tell me that, if i am using vb as front end and sql server 2000 as backend then for giving the facility of implicit periodical data backup at project, how can i go......through vb coding...

    Nileshmahadik5 pointsBadges:
  • Database Oracle

    hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql

    Berouty3020 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • Strange Stored Procedure Behavior (Dev vs Prod)

    I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first place)....

    Noonway25 pointsBadges:
  • Deploying reports created in SQL Server Reporting Services

    We have SQL Server Reporting Services installed and I have created several reports. However, I cannot get the Report Manager website to work so I can deploy the reports. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • os on data base servers

    do you need an os on a data base server if you have sql loaded

    Carman5 pointsBadges:
  • SQL problem

    Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one help me in...

    Vemuseshu5 pointsBadges:
  • Linking sqlserver to oracle

    How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...

    Wgself65 pointsBadges:
  • Crystal Record selection

    I need to eliminate duplicate records by comparing two fields, if the data is the same, I only want it to appear once. "Select Distinct" report option compares the complete record. Please help

    Srustemeyer5 pointsBadges:
  • DTS

    Posted - 10/28/2008 : 18:52:31 -------------------------------------------------------------------------------- I am trying to schedule a DTS package . But its says nothing, no error displays and finally it does not execute and hence a job is not created . But when I execute it immediately it is...

    Metro1725 pointsBadges:
  • ORACLE DBMS vs. SQL sever DBMS

    What are some key differences between Oracle DBMS versus an SQL server DBMS? Also, What are factors that would make someone want to use an Oracle DBMS versus an SQL server DBMS?

    Ryzawack15 pointsBadges:
  • SQL Server 2005 vs SQL Server 2008

    When comparing SQL server 2005 to 2008, does 2008 hold more data, or is it just an upgrade on what you are able to do with the data?

    Ryzawack15 pointsBadges:
  • Problems from reindexing tables every day on a SQL Server

    We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrade SQL Server 2005 32-bit version to 64-bit Version

    Is it possible to upgrade SQL Server 2005 32-bit version to 64-bit Version?

    Reillyjj10 pointsBadges:
  • SQL server 2005 Expr Adv services – installing SP2

    Hi folks I have a 64-bit vista ultimate PC with all SP's applied. I have been attemting to upgrade the existing instance of SQL Server Expr to SP2, but it stops installing with an error dialog box saying: SQL BPA command line has stopped working Eventually I end up on a web page containing the...

    Rosspetersen5 pointsBadges:
  • Maintenance Plans SQL Server 2005

    I upgraded to SQL2005, and cannot get any Maintenance Plan to save, via Wizard, or regular creation.

    Ssutton910 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following