Adam,

I'm experiencing the same problem. I'm about fit to be tied. Mine's a DB role that I was stupid enough to give ownership to another role. That's all I did,...

Thank you Ronda! I finally ended up stripping out log shipping altogether to try and start again. Unfortunately, now I've got a known bug popping up and it won't let...

Thank you Ronda! That's exactly what I expected. Now I've stripped out the entire process and started from scratch, but everytime I try to initiate the maintenance plan, the gui...

Thank you David! I tried that solution on my own yesterdat, and it didn't give me the right results set, but when I cut and pasted your code in (with...

It's interesting that you say there is no effect on using either a Windows Account or a SQL Server login, as what I'm looking for is a white paper that...

You're welcome.

In SQL Server you don't re-org, you rebuild, reindex or defrag. In SQL 2000 Books online (BOL) type in DBCC REINDEX. You'll find a handy little explanation about reindexing...

Thanks for the try, but I stated in the original request that I had signed in as local Administrator and that BUILTIN Administrators group was still set up, so I...

Welcome. I knew a Tim White once.

As for standards. What you do on Oracle is fine for small databases. Some things you don't need to do no SQL unless you...

Thank you alzadba for answering. It's exactly the knowledge I needed.

I'm not saying that I know the answer, but something I would want to know is whether  either of the servers involved are set to a case sensitive collation? or are they both...

Can't say I've found any problems yet in SP1, although I probably have and don't know it. However, the bugs SP1 fixed so far made it a necessity. So far, we've...

John,

First thing I'd do is check out the O/S. Are you running 2000 or 2003? and I would start investigating the storage formatting differences between the new SAN and the...

Thanks for the replies! We want them to run in parallel rather than in serial because we are trying to reduce a load window and these three loads don't have...

You're welcome! So, I think I'm understanding just a bit more. What you're wanting is if a DBA disabled one of the four jobs, at that time, you want all...

I'm not quite understanding what you are asking. If you create a job that runs the logic, then that's the method for doing this. You would schedule the job to...