• 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:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: Select the max(to_date) + 1 from a table in SQL Server. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • combo box in dbgrid

    I want to drop combo box in dbgrid. How to do it?

    Sysmatics25 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    I want to make the SQL connection with VB 6. How do I open the connection in SQL?

    Vishalngp15 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 pointsBadges:
  • If running two SQL Server DBs in two VMs, I should purchase two DB servers?

    If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

    ITKE350,795 pointsBadges:
  • How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

    ITKE350,795 pointsBadges:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Store and retrieve image using SQL database

    How can I store and retrieve images using a SQL database?

    RAJA12us285 pointsBadges:
  • Delphi and Oracle stored procedures

    I'm converting an application from Delphi3 to Delphi5. I have some doubts about Stored procedures. Delphi calling stored procedures in oracle.some parameters value are set as input and passed to oracle. stored procedure in oracle returns some value. in my delphicode when the application reaches the...

    VPL100 pointsBadges:
  • Can you force a user input in a SQL statement, then have the statement continue running

    Hi, can one in an SQL statement, when running in SQL, force a user input to be entered and when entered? The SQL continues to complete.

    Bugsy5 pointsBadges:
  • Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • How to setup for the SQL Database Mail to link with Exchange?

    How to setup for the SQL Database Mail to link with Exchange?

    Zur5 pointsBadges:
  • disk activity is running at 100%

    24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

    Salmonthefish5 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005

    What are the Basic difference between SQL 2000 and 2005? Thanks!

    Amin4rmOvexTechnology250 pointsBadges:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this interesting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Encryption Form SQL Server 2000

    I want to transfer data from one database to another database both the databases are on SQL Server 2000. I want to transfer the data in encryption form. How do I do it? Regards, Sahil

    Maruf245 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 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