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,...

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30043/

Uses PKZip, but you can modify to use the command line for WINRAR.

You can run frequent diffs, but they'll get larger and larger. For that matter, why not run a full every hour? You could do that and it would let you...

As mentioned above, a simple in the WHERE clause should do this.

This sounds like some test question or interview question. We are happy to help, but we want to...

Good points on your value and something I hadn't considered.

As an FYI, I actually have a balanced NCA where the I have to give xx notice and the company must...

RE-uploaded the file for the WMV. Hope that works.

localhost/mssqlserver is a named instance. (local) defaults to local (I think 127.0.0.1)

The /mssqlserver isn't necessary for a default instance. You'd just connect to the Windows machine name.

If you want to...