Text files are font-less. The font is a setting of the text editor that you are using to open the file, so you are barking up the wrong tree...

In my experience the log shipping monitor has been so unreliable that I rarely even look at it anymore. If you wee the log backups at the standby server,...

Use sp_revokelogin for NT authenticated logins, or sp_droplogin for SQL logins.

There are several reasons you might want to partition a table, most are concerned with the manageability of the physical data and with performance gains. Typically, the partitions are...

Its not clear from your post - was your full backup taken before or after the stopat time?

A full backup reflects the database at the time that the backup finishes....

Chances are you already noticed, but since you already dump your traces to a table, you can also do File, Open, Trace Table.

I wish I could see what you see, said the blind man. I have confirmed do not have that proc in any database on any of the three servers....

I'll take a stab at it, even though a) I've never had any trouble scripting pubs with subs, and b) I can't fing that proc in any database on the...

It seems to me that Outlook is wrong, or at least incomplete. Week 1 of 2006 starts on 31.12.2005. Week 53 of 2005 starts on the same date....

...where objectname = objectname. Your count(1) will be > 0 for every row if any row qualifies. Try this:

when (select count(1) -- clustered will be reindexed

from #fraglist sub

where...

or, build a calculation that doesn't use a conditional at all:

value = value + (code_field - 1)*(-200) + 100

I have an approach that might help, even if it doesn't quite get you all the way to your goal. I say might help, because it depends on a...

Cursors ARE evil, but as for why it ran so long - you need to use WHILE...BEGIN...FETCH...END. Your while loops on the IF...ELSE blocks and never gets to the...