How did you do the migration?

The syslogins view is the common view between them. Otherwise, you need to check the server version and have two distinct code blocks. I have different code blocks...

How did you do your migration? Someone had to have done something whether they realize it or not since Jobs don't just mysteriously decide to migrate themselves. Unfortunately...

Please post the exact code that you ran, and the exact error message that you received back.

Vee (12/29/2008)

---

But if you are not familiar with WMI or Powershell.

You can use

EXEC master..xp_servicecontrol 'QueryState', 'SQLServerAgent'

you can set a batch job for all your 100 servers and report the...

Why are you trying to create the assembly in the master database? Is this really what you intended to to do? I ask because master is owned by...

Are you on SP4 for SQL 2000? What is the alert definition that is causing this to fire off?

Generally I use sqlcmd from the command line to do it and I use a batch script to start the instance in single usermode and then immediately connect to it....

Since Powershell is Microsofts future for scripting, Jeffery's recommendation is actually a better one. It uses the same WMI namespaces that the vbscript in the link I provided would,...

No, but you can check for connections from it:

select * from sys.sysprocesses

where program_name like '%SqlAgent%'

However I wouldn't trust this kind of check for service status necessarily. I would use...

Start with a simple failover test and ensure that you can force failover the active node to a passive node. Then test the connectivity of each of the clustered...

As long as the plan is still loaded into the proc cache, you can somewhat use the DMV's for this. If it wasn't run since the last cache flush...

If you can fire an email off on port 2525 then the mail server is using a non-standard port for SMTP. This isn't normal, but it isn't abnormal either....

Perry Whittle (12/24/2008)

---

why act like a couple of little girls. The solution you provided is correct if the question were different. As far as i can see he wanted to...

One thing I would recommend is that you change the number of logs to be retained by the system. The default is only 6, so you will lose information...