oh great thanks

Ok right thats interesting.

I have checked and our instance is 9.00.3077.00 and the client tools is 9.00.3042.00. I think both of these are SP2 but with some additional fixes...

we are on SP2 atm

HI I have a follow up question to this. The sp_change_users proc does not work to find out windows level-principles that are orphaned. How can I find out...

ok great thanks

Hi again, I just wondered if anyone knew how to get round this? I have read this maybe a fixed in a SQL 2005 patch but not found which...

well was looking at user mapping, but I guess thats to allow mapping of users in a database and also restrict permissions.

What about that step in particular running as SQL...

Ok the job owner is an SA account which doesn't have any permissions mapped to MSDB. The step itself is set to run as SQL Service Agent account, which...

No errors, for that step in the history it just says package executed successfully. The step suceeded. But nothing happened. As I say if I run the...

Hi - I am just setting the step to use a Type of SSIS package, and then browse to the maintenance plan which is held in SQL Server.

That...

Hi Gila

My system is OLTP and uses 4 cores. Currently MAXDOP is set to 0 with threshold of...

In SSMS if you disconnect completely from the server and then put in all the connection details again do you get the same problem or do you get a different...

Hi this has worked a treat. I actually didn't need to create a new publication but by running:

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time...

There is still a used publication in place so dropping replication isn't an option, I will look at using your method Gila and let you know how I get on....

Ok just found out that a colleague setup transactional replication around the same time that we started to see an increase in the log. That publication does not...