The Sql logins are windows Auth but yes, when the stored proc runs it sees to run under the credentials of the Sql server agent which uses the NT account.

It gives you the value of a default constraint as if it were evaluated right now.  Best example to see this in action would be to create a date default...

that will a new query plan each time though?

Hi,  It was in PRS4 i think, north american server,

I was loading from a insert into select from external table.

I was loading 5 tables with about...

Cheers

I had a feeling that was the case thanks I just have never seen SQL not return the order correctly when it has a clustered index.

No one would...

Thanks 🙂

GilaMonster (1/30/2015)

---

rob.lewis 86087 (1/30/2015)

---

If you have a 20gb transaction log file in simple a recovery model

A full back up is run

A check point is made

The transaction log off the back...

GilaMonster (1/29/2015)

---

Full backups do not truncate the transaction log in any recovery model.

In full and bulk-logged recovery a log backup truncates the log.

In simple recovery a checkpoint truncates the log.

The...

Thanks for reply 🙂

If anyone has done this and can say what you get that would be great as we almost qualify and would be good to know if its...