One thing to note is that no transactions are actually rolled back. What checkDB is doing is creating a hidden database snapshot to do the check on and the transactions...

Chris Morris (12/10/2008)

---

GilaMonster (12/10/2008)

---

I don't have any photos of what Steve's taking about. I was too busy getting pounded into the mat by Kalen.

I do have a couple of fairly...

Maybe wrap the datediff in a case, when 0 then 1 else datediff...

I don't have any photos of what Steve's taking about. I was too busy getting pounded into the mat by Kalen.

I do have a couple of fairly good photos from...

Nothing...

In that case, set the database to restricted users before starting the backup. That means that only members of db_owner, db_creator and sysadmin may access the DB.

If that's not...

Snapshots?

It was existing transactional replication that I set up a couple months back to test some stuff and never dropped.

I don't know why that's not working. I did exactly that (except I...

Why do you need to prevent users accessing the DB to do a backup?

What do you want to see in the following cases?

StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 18:00:00

StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 07:00:00

Nothing unusual there. SQL will take as much memory as it's allowed...

What info are you looking for?

Try this:

select * from sys.symmetric_keys

It's not a SQL menu. Window's administrative tools....

asrisl (12/10/2008)

---

Thank you. I found a switch like what you described under "Surface Area Configuration." I trust that is the one to which you were referring. It is set to...

Needs more quotes

CAST(S.xusertype AS INT) = CAST(C.[User_Type_Id] AS INT)

WHERE T.[Name] = ''' + @TableName + ''' AND

T.Schema_Id = 1' --@@@@ (1 = dbo.)

Square brackets denote identifiers, ie table or...