Forum Replies Created

Viewing 15 posts - 31 through 45 (of 174 total)

  • RE: Does it help?

    I'll add my vote for two monitors. All my developers have two, as do I. I noticed an immediate productivity benefit to it.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: string operations..URGENT!!

    You'll be happier with the results if you use a date format that orders the date YYYY-MM-DD. The files will sort properly by date, even from one month or...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Running jobs in Parallel

    sp_start_job doesn't wait for the job to finish, does it? So if you have three in a row, the jobs will all start within milliseconds of each other.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: SQL 2000 Backup over NETWORK

    It is not a recommended practice to backup to a network share, though I did that for a couple of years without problems.

    The method I use now is to schedule...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: SQL Agent puzzle

    Are you using a local account rather than a network account?  Try using a domain account, and configuring the mail profile to use that.  (Logon to your server with that...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Getting data out of Active Directory

    Hopefully this will help. 

    Here's a sample I found on the net some time back:

    ' Get User Information gui.vbs

    ' Revision history

     

    ' Created 11-26-2001 by Ralph Montgomery - Firsthealth of the...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Getting data out of Active Directory

    Hopefully this will help. 

    Here's a sample I found on the net some time back:

    ' Get User Information gui.vbs

    ' Revision history

     

    ' Created 11-26-2001 by Ralph Montgomery - Firsthealth of the...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: SQL Agent puzzle

    Double check that the account that SQL Agent uses is correct.  Also, it looks like your MAPI program (Outlook?) may be the culprit.  Go into the Control Panel and reset...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Typical Day for a SQL Server DBA

    I agree with rudy.  None of my days are typical.  I tend to spend 75% of my time debugging vendor supplied stored procedures and writing ad-hoc queries to find/fix problems...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: SQL Agent Error

    Use either a domain account or a local user account for the Agent. 

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Port 1433 blocked

    Disabling the Windows Firewall is a bad idea if the laptop is ever out of your corporate environment, where you are protected by the firewall at the perimeter.  However, if it...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: problems after migrating to Active Directory

    Make sure the user ColdFusionUser has the correct permissions on the folder containing the file you are trying to import.  Server 2003 locks down permissions, so you have to specifically...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Maximum allowable table row size of 8060 bytes

    Would it make sense to have a sub-table with the values, so if null, there is no subtable column?

    declare table main (id int identity)

    declare table main_values(id int identity, main_id int,...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: setting up a job to truncate the log file

    I set transaction log backups to occur every hour, and in EM, set SQL to delete backups older than 3 days.  I have a Scheduled Task on the server which...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • RE: Database Removed

    Have you checked the windows event logs?  The security log will show you who connected to the server.  It would have to be a sys admin or administrator to drop...

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

Viewing 15 posts - 31 through 45 (of 174 total)