Forum Replies Created

Viewing 15 posts - 31 through 45 (of 173 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.

  • 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...

  • 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.

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • RE: SQL Agent Error

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

  • 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...

  • 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...

  • 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,...

  • 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...

  • 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...

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