Make sure the account that you are using for the SQL Server Services and Agent (if you are scheduling it as a job) has access to the UNC share.

Hope that...

At the time this release went to press, the link to our site may not have been activated.

If your readers are interested in our product, and would like to take...

Steve,  I bet you had no idea of the controversy the Reagan posting would cause.  Sure, it's a diversion from the usual content, but one I know you meant simply out...

Just by virtue of taking the time and space on your website, to make honorable mention of a truly inspiring leader and indeed, the "Great Communicator", President Ronald Reagan, is a credit...

Try this SQL script

set quoted_identifier off

declare @blocked int

select @blocked=count (*) from sysprocesses where status <> "background" and cmd not in

('signal handler', 'lock monitor', 'log writer', 'lazy writer', 'checkpoint...

Hey!  Anybody remember the Great Blackout of August 2003?  And, I have that T-shirt.  While we were sweatin our ac's off (pun intended), we were cranking diesel fuel into the...

You're welcome!  It may also be possible for you to script something out using xp_cmdshell, and netsvc.exe, and then schedule it, with an alert if the service shuts down (assuming...

You can also obtain netsvc.exe, from the Windows Resource Kit.

This handy utility can give you the status on any service locally or remotely.

Controls and displays the status of services.

NETSVC servicename...

Indeed.  You can check out Lumigent's ENTEGRA, that does exactly what you are looking for.  It doesn't have much overhead, and does not use triggers. It may be a bit...

Let me try to clarify based on my experience with multiple instances on a cluster.  First, I think you are confusing instances with virtual servers, in that any instance built...

Dave:

Please see my updated post, which I was in the middle of editing, when I reviewed what you're looking for. 

To record this information, you will either have to design something using triggers: see this article http://www.sqlservercentral.com/columnists/rmarda/auditingtriggers.asp

Use Profiler, which has overhead, and not meant to be used for an...

I may not be able to give you exactly how much memory should have.  Actually, SQL Server dynamic memory manager is best at determining how much memory it needs.  It also...

You can assign the static port number by using the Server Network Utility for each instance.

You need to simply add the login/user 'asdf' to the server/database and grant permissions to the tables.

I don't know if there are any restrictions and separation of responsibilities (i.e....