joannapea (9/22/2008)

---

Hi Gail,

Just wondering if you have any clever suggestions for preventing the login trigger from stopping logins altogether? I've written a trigger which logs all logon activity to a...

😀 Thanks.

Working from home means I can keep a better eye on the place. :hehe:

Jeff Moden (9/22/2008)

---

Considering that BETWEEN is reevaluated by the optimizer as an AND similar to the original query in this thread, I'm really surprised. I think it may be...

:hehe: I prefer paw-paws. So much easier to aim.

Pleasure.

colin Leversuch-Roberts (9/22/2008)

---

kalen Delaney wrote some of the best consise books on indexing prior to sql 2005. From sql2005 onwards you seem to need more and more books just to...

Precision is the total number of digits in the number (to the left and right of the decimal place). Scale is the number of digits to the right of the...

There's no such data type in SQL Server.

Can you get some clarification from the person who requested this as to what they mean?

Please run the following and post the results

SELECT @@Version

YSLGuru (9/22/2008)

---

The system uses Statistics to determine fragmentation and when you rebuild an index there is no need to rebuild the statistics as SQL Server handles that for you. ...

It fits into a numeric (15,1). Any numeric (or decimal, they're equivalent) with a precision of 15 or higher and a scale of 1 will work.

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic573869-1291-1.aspx

There's no option to split a DB as part of a restore.

You'll have to create two new files, place them into two new filegroups and then move tables over into...

There's no way to tell unless you've had some form of custom auditing logging when users log in.

Redgate's one works only for SQL 2000. From what I've heard there's no log reader yet that can understand all the entries that SQL 2008 can make.