Hi Greg,

Thank you for your reply. Is it safe to detach the current system databases then reattach older .mdf and .ldf system files?

Thanks,

Melanie

Hello,

Stopping/Restarting the SQL agent solved this problem and provided me with other Step Type options. Thank you very much.

Melanie

Hello,

Yes, the login that is used for the SQL Server Agent is a member of the system administrators group of the server.

We may just end up reinstalling SQL Server.

Thanks for...

Hello,

Has anyone installed this patch yet on your servers? We will probably install the patch on our development server first, before tackling the cluster. But I'm trying to...

Hello,

The login running the agent is a member of the sysadmin role.

The installation might be a bad one, since when I open maintenance packages, I am immediately asked if I...

Hi Steve,

Thank you for your reply. We're running SQL Server 2000 with SP2. I'll confirm the Agent's login permissions. And see if it's anything at that level.

Thanks!

Melanie

...

Hello,

I apologize for this double post. I inadverently hit the Back button.

Thank you.

Hello,

I apologize for my ambiguous request. I am actually trying to find out the kinds of information that would be stored in the master database's transaction log.

Reason I ask...

Hello,

The stored procedure is not named sp_XXX. Rather, it is named spXXX. Also, I am running the code with the same parameters each time.

I ran the two tests...

Hi Brian,

I apologize... You are not confused. I was the confused one, as I failed to see that we are still in an NT domain and NOT 2000 (as...

Hi Brian,

We are not an NT domain. So would this mean that the initial thought of Security Account Delegation is correct? I need this in order to perform...

Hello,

I am running Query Analyzer from my workstation, which is not the test server. I did, however, log into the test server (via Terminal Services) and run the same...

Hello,

Just thought I'd fill you in on how I was able to work around the sysadmin issue. I copied the procedure and modified the section where it's checking to...

Hello,

Thank you for your response. I'll test this further to see if the noted permissions will work in our environment.

Melanie

Hi Dan,

Thank you for your response. I actually thought I had scheduled a full backup. I manually ran a full backup and it went successfully. Then the...