By workaround do you mean any way to cause side effects from within a finction? If so, no. It is a hard-and-fast requirement. You cannot make any changes to the...

setlan1983 (12/8/2009)

---

Space in log is reused means the log size will no longer grow?

Example current log size is 10GB, if perform backup log regular, means the size will keep in...

Functions may not have side effects. They may not change the state of the database at all. That means no creating or dropping objects. No inserts, updates or deletes. You're...

They will. Shrink, with the default options can completely reverse an index, ie increase fragmentation up to almost 100%

See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

Shrinkfile...

Logins are in the master database. You should be backing that (and msdb and model) up on a regular basis.

Rod Harten (7/7/2008)

---

What is the role of the :: symbols in SQL? I usually see them prior to function calls but they optional, at least in that context. ...

No. Let it run to completion. Stopping it won't cause any problems, but you also won't get any results, essentially wasting the hours...

Nothing. From Books Online

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates...

It depends.

There's no one way that's always right, no one way that's always...

The proper way is to schedule regular log backups so that the space in the...

CirquedeSQLeil (12/7/2009)

---

GilaMonster (12/7/2009)

---

Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite...

Where are you running it from? Management studio?

DATEADD(dd,60,getdate())

Midsummer

Yup.

Well, it's listed on my profile, so not...