Thanks, guys. I was really only interested in SQL Server permissions, so what Markus says sounds like what I need. Can anyone else confirm or deny it at...

Bear in mind also that the DMVs are cleared down not only when SQL Server restarts, but also when databases undergo certain changes of state, such as to or from...

That's another limitation of Andy's method from which mine doesn't suffer - you can't make updates directly to the system tables on SQL Server 2005.

John

Someguy (8/19/2008)

---

I do want to encourage you (and maybe a few others who wander through sites like this) to realize that your strongly held views are controversial; be careful of...

Steve Jones - Editor (8/18/2008)

---

The kids do get loud. Last summer, when we had them home part of the summer, it was hard to work. Ended up working at night...

mtassin (8/8/2008)

The Square Root of -1 is i, which is an imaginary/complex number. It cannot be returned as a float data type because it is out of the domain...

Good article, Ian. Ignore those ignorant enough to criticise without giving a reason. And to those who carp about bugs in the code, I say this: Debug it...

Charles

I didn't realise anybody even used FAT any more! MDF files have the potential for fragmentation, as you say, but in general the data in them doesn't grow and...

Nobody has yet mentioned another reason for not shrinking the log on truncate: physical file fragmentation. If, when the log grows, it can't find a contiguous area on the...

For enlightenment, read this article and then wade through the discussion:

http://www.sqlservercentral.com/articles/Miscellaneous/2748/

John

You can look in sys.indexes to find the name of the index. You can then either script the view through SSMS, or join to sys.objects to find out what...

majorbloodnock (6/2/2008)

---

For instance, I found out that, in the UK, when Christmas falls on a Saturday, the following Monday is the Boxing Day bank holiday and the bank holiday in...

Very interesting. But I think I'm happy enough just looking it up in a diary!

Actually, I think it failed for me because my default language is British English. ...

Perhaps they were thinking of the distribution database, which may be created when you configure replication.

John

Didn't work for me, I'm afraid. Tried to calculate this year's Easter date.

Msg 242, Level 16, State 3, Procedure fcn_FindEasterSunday, Line 39

The conversion of a char data type to...