Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: how to tell if a trace is running on a database

    SELECT *

    FROM ::fn_trace_getinfo(default)

    From Books on Line:

    Tables Returned

    If a trace_id is specified, fn_trace_getinfo returns a table with information about the specified trace. If no trace_id is specified, this function returns information...

  • RE: Need to load data onto a new drive

    Add a new datafile and logfile on the e: drive.

    This can be done through Enterprize Manager

    right click the database

    select properties

    Go to the Data files tab

    Type in a name for your...

  • RE: Reclaiming the Log space

    After you sucessfully reclaim the log space, back up your trans log regularly.  Otherwise your log will grown again.  Do not just do full backups- do trans log backups as well. 

     

    I always...

  • RE: SQL Login Security

      

  • RE: Storing Images

    We looked into it, and decided to store the file location in the db, and the image outside. Easier! But you can store the image in the database...

  • Viewing 5 posts - 1 through 5 (of 5 total)