Glad I'm on this side of the pond 🙂

Most people I know don't really like VSS. SourceGear, SVN, PVCS, etc, are better systems.

If you need to use SourceSafe, I'd start here: http://msdn.microsoft.com/en-us/library/bb509342(VS.80).aspx

http://www.softsteel.co.uk/tutorials/vss/index.html

Read Books Online for information on this

http://m.podshow.com/media/15351/episodes/125321/sqlservercentral-125321-09-09-2008.mp4

If you restored without using the NORECOVERY option, there's nothing you can do. You brought the database out of standby and log shipping can't restart. I'd delete it and run...

yes, principals and mirrors are database level, not server level.

yep.

In SQL Server 2005, you can set a password policy for SQL accounts if you are on Windows 2003 or later.

If you are running SQL 2000, there isn't any way...

If you can't trace this procedure down, you probably need to get some basic training.

The procedure just simply runs through a set of IF THEN logic and executes statements. If...

You would want to do a GROUP BY and COUNT to aggregate up the rows.

select fieldA, fieldB, count(fieldb)

from table

group by fieldA, fieldB

I hesitate to give developers even DBO access for a simple reason. They don't necessarily keep track of things and they tend to make changes, try things, etc. without documenting...

Do you want to delete matching NULLs? Use an OR clause -OR (a is null and b is null)

A separate array helps, but only during backups. You don't have heads moving for two separate processes. Not sure how noticeable it would be.

However it's a bad idea. If the...

That's what I would think. Some process outside touching the files.

James,

Didn't realize that and good information to have. It's good to know since it might mean that you can your vacation back if you have to work.

I have turned my...

Not sure what you mean by "how it process". You can get the execution plan, which will tell you what work is being done. Queries can be processed different ways,...