Wanted to follow up on this in case anyone else runs into it.

We were re-using connections using connection pooling, but setting and un-setting the application role before each transaction....

For critical production systems, I insist that the SAN administrator create dedicated RAID groups / LUNs for each of the purposes you describe (except maybe backups...). Not only does it...

Thanks for your reply. I agree that groups are preferable. Unfortunately our primary application precludes their use for a variety of reasons. I figure I could write something that uses...

Some good advice here. Thanks to all. Either approach should work (inserting 'USE...' statements in the executed batches or marking the proc as a system and executing form the target...

bump...

Does anyone know if I should be concerned here? I'm assuming not since the message does say 'no user action required' but it still makes me nervous.

Thanks in advance

-k

We have a similar need, but chose a completely different approach. The batch processor is a C#.NET app running as a service on separate machines (actually a set of 5...

These appear to be generated and reported by the SQL Server DBSPI for HP OpenView. We also get odd messages like this from HPOV on occasion. If they recur frequently,...

Here's one I've used for a while. Don't remember where I got it.

' Objective: To delete old files from a given folder and all subfolders below

' Created by: MAK

' Created...

No one replied, but in case anyone read this and was wondering how it was going...

Well, we rebooted the system over the weekend, so SQL is now using both processors....

This just came up here today. We were having some trouble with replication. We wound up using:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=596

Though we had to make some changes to it since our DB...

In my experience, it means different things to different people. In a contracting situation, if you're being asked to create one, you should be able to ask for clarification of...

Thanks. That was it!

The problem is with the SET statement. Since your @server variable is within the quotes, it does not treat it as as variable, but rather as text. Try...

Sorry I didn't get back to this right away, I was called off on another assignment and didn't have time. Thanks for your responses, though.

Unfortunately, since we're writing...