xp_readerrorlog will display the last error log. Then you can feed it integer parameters to see the previous logs.

exec master.dbo.xp_readerrorlog 1

That will show the last log generated before...

sorry... sp_msforeachdb (got it right in the example).

Might want to look into using ms_foreachdb...

sp_msforeachdb 'sp_addrole ''role_name'' '

I'm reading your questions today and I'm finding that they're fairly general and as such it's hard to give you a definite answer. Unfortunately there's oftentimes a lot of...

I've used XPSMTP in the past with 2000. I liked it. I didn't want to have to set up all the things involved with SQLMail on my servers...

SELECT @to_date = SD_TO_DATE,

@from_date = SD_FROM_DATE,

@cyc_end = SD_CYCEND,

@amount = SD_BILL_AMOUNT

FROM table

WHERE ovi_sd_record = @input

That should...

There's not a huge difference between Windows 2000 and XP, so you should be fine. The instructions should work nearly the same.

It's hard to determine when to create a clustered and nonclustered index. There's rarely one sold rule for "this is the best possible way to do this".

A clustered index...

Well, a key is simply a means of identifying a row in a table. An index is a method for finding data quickly in that table. When you...

UPDATEtable1

SETfield1 = ISNULL(@param1, field1)

,field2 = ISNULL(@param2, field2)

...

where User_ID = @User_ID and Company_ID = @Company_ID

This updates the fields either way, just that if the value of the parameter is null then...

I proposed a framework for doing this in my article:

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp

You can probably modify it as needed for your uses.

I had something similar to this for a while.  I had to uninstall the print control and then reconnect to the 2005 server and re-install the print control to fix...

Woah there... you need all those varchar(max) fields?

Recently I came across a highly transactional DB with no FK's! The data integrity was managed by the front-end application.

Unfortunately this is not uncommon in database / application design. ...

In my experience only if you're going to be making use of some of the performance enhancing features of Enterprise edition. A couple of the higher-end index operations only...