Heh. You know when I saw the title of this thread, I thought that it was another editorial about the Financial Crisis. 🙂

Grant and Deny are security settings. Enable and Disable are configuration and administration settings.

Enable/Disable control the state of the object that they are referring to: they turn it "ON"...

This sounds like the SET DATEFORMAT option is set incorrectly.

By the way,

Graham Macfarlane (10/20/2008)

---

... it gives me a char conversion error unless I use US format for the date...

baumrl (10/20/2008)

---

Are you really comparing the poster child for so many things that are wrong with the US to this violinst? Cuban may have more money than he knows...

Thomas (10/20/2008)

---

I think it's SQL Server 2005 Enterprise Edition (have to double check the server again). Sounds like I can only create offline index if I am not using...

Thanks!

Thanks, Gail.

OK, here's my attempt to actually add some value here: Here is a post (by crever) that explains a very simple way to do this with powershell, including an...

Ack! I spent so long looking for that article that you beat me to it Grant! :w00t:

Here is a link to a Simple-Talk article that explains how to do this for free with pwoershell in SQL Server 2008: http://www.simple-talk.com/sql/sql-tools/using-powershell-to-generate-table-creation-scripts/.

Nice, I like that one.

Is that the original name?

Andy Warren (10/20/2008)

---

No one going to pick on the violinist? Hard not to understand his point, but no points for gracefully accepting a little adulation.

Most of us worry about money...

There's only two good reasons to shrink a log file that I can think of:

1) Exceptional Growth: By exceptional I mean "large and unlikely to reoccur". It's OK...

This then indicates that your...

Gail: Is this true even if none of the "Snapshot" features are...