Viewing 15 posts - 616 through 630 (of 956 total)
How did you do the migration?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 8:38 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 8:32 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 8:27 pm
Please post the exact code that you ran, and the exact error message that you received back.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 8:20 pm
Vee (12/29/2008)
You can use
EXEC master..xp_servicecontrol 'QueryState', 'SQLServerAgent'
you can set a batch job for all your 100 servers and report the...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 9:30 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 29, 2008 at 9:20 am
Are you on SP4 for SQL 2000? What is the alert definition that is causing this to fire off?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 28, 2008 at 5:30 pm
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....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 28, 2008 at 5:28 pm
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,...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 28, 2008 at 5:21 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 28, 2008 at 8:05 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 24, 2008 at 2:07 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 24, 2008 at 8:50 am
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....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 24, 2008 at 8:40 am
Perry Whittle (12/24/2008)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 24, 2008 at 8:37 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 24, 2008 at 8:32 am
Viewing 15 posts - 616 through 630 (of 956 total)