Thanks for the follow up. When you get the script going we'll have room for it in the script library!

Andy

Nope, mostly IP connections for me. Are you rebuilding indexes regularly? I've seen latch waits if the db was heavily fragmented a couple times.

Andy

Reset in SQL itself, or in the QA picklist?

Andy

You can share one SQL login by embedding it in the app (password too if you want). The alternative is to use NT security where access is based on their...

I dont have enough hardware or data to find out for sure - my philosphy so far is to use filegroups only when I can't get it all on one...

Pretty interesting. No ideas yet on a good fix, a workaround would be to grab the logic from the proc and just dump into a new one you create that...

Once you know a pub is out of sync, you just right click it and select reinitialize. Then you can generate a new snapshot. A snapshot consists of a bcp...

You can attach a model.mdf copied from another server.

Andy

Yes, you need to run validation. It offers several options to set the depth of the validity check. I run one weekly but so far have never had an issue.

Andy

Glad you found the articles helpful. You need to set the login object to an existing user. As it is your login object doesnt exist in the db. You need...

Your choices are to store the file in the file system and the name of the file in the db, or put the whole file into a blob. Do a...

Long term you'll be better off putting all that data in one table and just adding a additional column to indicate which bank. No limit, more efficient than adding a...

Possibly even a bad NIC. Cheap enough to just replace it if it continues.

Andy

You'll need a 3rd party product like LogExplorer by Lumigent.

Andy

I'd recommend that if you're going to use an array that you dim it once outside the loop. Preserve is a fairly expensive operation if your list is of any...