I actually made the first post on the 300th page. Beat you all to it... :hehe:

We are going to hit triple hundred in number of pages... Yea...!!!

Time to break the champagne bottle and have some beer as well.. 😛

Also check for Open transactions, Especially on the articles that are being snapshot.

I do not think it is the issue with the Service not being started. If it is not started, it will not even give a Scheduler error. Scheduler is invoked...

State 16 is actually "User doesn't have permission to target database".

From what I read, you restored the DB. Then created Logins for the already existing USER in your user...

I know that when you generate snapshot, it can cause dead locks with the other operation. Maybe you should check your Log to see if there were Dead locks. That...

Thanks, Thats what I thought. So my answer was not completely wrong.. 😀

Hey Lynn, Will we be able to use the features of 2005 if the compatibility level is set as 80?

I am not sure I follow your question. If you are saying why we should convert the Db to 2005 and keep compatibility level at 2000, I would suggest against...

What service are you talking about? SQL Service?

I am sure Oracle too might have some tool that is equivalent to a profiler in SQL Server. You can use something like that and track what Queries or calls...

Looks like everything is back online... 🙂 Steve does not want the Gurus have a day off... :hehe:

Something is not right for sure. I think helping some posters is kind of out of the question. I guess this is Steves way of telling everyone that today is...

Do you have trace set up? If not it is very difficult to find what commands were executed.

Is this thread getting too big for the forum? I see triple postings... Something seems to have gone loose..:hehe:

Lynn sure has lots and lots of patience for sure.... I have...