But another SPID already has the only available connection to that database. Running the alter database command from master even logged in as a sysadmin would not work.

Msg 5064, Level...

Thanks for your reply Ray.

There are no complaints and the system is running well. But seeing numbers that high always get me worried as I have no baseline yet.

Thanks again,

Andy

How about these little gems:

INSERT INTO some_table

SELECT * FROM some_other_table

Or this method of calling procs that I have found in embedded far too many applications:

EXEC dbo.some_proc 'parameter1', 'parameter2', 0, NULL,...

Why not just store the file path/file name in the database and keep the images on a separate directory?

Profiler is great when tracking down problems with Service Broker.

Could it be a bad SP2 install? I have seen 'successful' SP2 installs that break database mail.

Jonathan,

That is an even better idea...do you RDP into production boxes for any and all work that needs to be done or just for the more risky tasks?

I agree that 99.9% of administrative duties can be safely used via a wireless connection, but I think if I have to run that script again (the other 0.1 %)...

They do not address the exact question by the OP but the do give a good head start into the fundamentals of Service Broker. With some practice the OP should...

You can also check out these two books:

The Rational Guide to SQL Server 2005 Service Broker (Roger Wolter)

and

Pro SQL Server 2005 Service Broker (Klaus Aschenbrenner)

Both books are excellent in both...

Definitely a coffee shop or hamburger joint...

Hi Prakash,

Thanks for the info. I think we are going to go with #1. Build a new cluster, migrate the logins, move the LUNs and the attach the dbs.

Thanks,

Andy

You definitely can have multiple virtual instances with the same port. We have a couple of clustered instances in our lab running in an active-active configuration. Right now they are...

I have not tested this but I think that in an Active/Active cluster scenario the instance in the cluster group that has the Integration Service would be fine. The instance...

Hi,

If you want to cluster SSIS then you can do the following:

1. Add Integration Services (must be installed on all nodes) as a Generic Service in the cluster group and...