How is the maintenace plan configured for cleaning up the directory with the trn files?

What are you using for your smtp relay, maybe its being blocked.

Bhuvnesh,

Are you saying that I should add the job owner to the table that is required for the TSQL statement? I'm trying to avoid unnecessary accounts being added to the...

Bhuvnesh,

The job I have has two steps.

Step 1 uses cmd to run the first step.

Step 2 uses TSQL.

I have created a Proxy to run step 1, however, since step 2...

I'm familiar with using a proxy, however I dont see how to setup for a tsql step. Do I need to change the TSQL step to an SSIS package that...

How is your notification setup. Is the mail profile assign to a particular user?

Ray,

I am very familiar with the DAC procedures. Which is the reason I gave up on Logon Triggers. I wanted to avoid running a profiler in the background to see...

Hi torpkev,

What kind of lab setup did you create? I'm trying to the same thing at home for my personal testing.

I'm currently using VMware workstation 7. I have a windows...

Interesting article, so from a DBA vantage point, how are our roles likely to change?

Regarding administration of an application, how database creation, modification handled?

Is there a central point of...

Brian

Thanks for all your help. Hopefully, I can test this out next week on a clean system since its not working on my testing environment. Is there any initialization process...

Brian,

Thanks for the quick response.

I am getting the following error for the two SPs

missing table 'Errors.dbo.usp_WriteError'

Is there anything I have to do to initiate the system?

Thanks

Hi Brian,

Just wondering if you ever posted an article to regarding your solution?

Thanks

Ryan

Jack/Steve,

Thanks for all your suggestions.

Jack

Question regarding the ADD_SERVER_ROLE_MEMBER.

"ADD_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. Do you have any suggestion where I can look to resolve this issue....

Jason,

Not really sure if this is what your looking for

http://www.mssqltips.com/tip.asp?tip=1252

Nice script to list out each user within a Window group and permissions.

Question regarding the [modify_date], I thought this would be similar to SQL 2000's xdate2. However it seems that it behaves like the last time the user access the SQL Server...