http://www.red-gate.com/products/sql_backup/offers/exceptional_dba_awards.htm?utm_source=dba_awards&utm_medium=button&utm_content=being_exceptional&utm_campaign=sqlbackup

try this one.

We ran a fairly busy shop with 9 people and had no issues. I didn't mind VSS, but we kept things simple and it worked well for 2-3 medium sized...

Are you using the site search (google in the upper right), or the forum search above (next to My Posts and Home)?

I've heard other countries are starting to have more and more legal battles as we do in the US.

It's easy to say this is a gray area, but how do...

Yep, agree with Paul. A web app backed by SQL Server is an example of multiplexing.

Gail's series, GRant's book, Craig Freedman's blog. all good places to learn about this.

As Gail says, time and place for everything.

http://blogs.msdn.com/craigfr/

Likely you need a combination of datepart (turns date into numbers) and then possibly a CAST.

You are multiplexing here. This is the same as a web server talking to users and only talking to SQL. Still the users are using SQL Server indirectly through a...

Jack is correct. The diff stores changes SINCE the full. So it doesn't have a baseline on which to work. A diff is used to reduce the number of log...

It is what it said. You likely created the trigger with different SET settings than the table.

Change ANSI_PADDING, redo the trigger and then it should be OK.

My bet is a lot of what will come out of this is how to collect, manage, store, and anlalyze a tremendous amount of data.

You would use an UPDATE statement to change the data.

update tableB

set tableB.col = a.col

from tableA a

where TableB.othercol = a.othercol

The query syntax you have for SELECT would be...

There is no way you can get any level of code done that you're sure does this for US$395. Even at the cheapest rates you'd use way more than that...

Search for "cross tab" as well. That's what this is.

This looks like it will prevent deleting ONLY if there is a value of "1" in the Locked field. The row isn't necessarily locked.

also, this is an INSTEAD of trigger,...