I would go for the solution Perry Whittle provided.

Use the alter database methode because this will always have you db defined at your sqlinstance, it will also keep all security...

Very nice way to tackle the issue of hardware replacement !

Thank you for this valuable feedback !

Keep in mind trace flag 4621 is only available with SP3

and is only advised if the combination of trace flags 4618 and 4610...

Did you manage to get smtp to work on your 64-bit win2008 ?

indeed ... as Lynn stated, use the column 'name' to order the result set and you'll be fine.

For you query the ordinal column 1 is the variable value for the...

Did you try making an indexed view for the phone number part ?

I usually don't use indexed views, but if you insist on having a single query doing it all...

Best is to capture this content for a while (to have persistent data)

select db_name(database_id) as DbName

, case db_id() when database_id then object_name(object_id)

else cast(object_id...

This backup of your database has been created using multiple backup files !

You need all files of that backup(set) to restore the database.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

smtp & win2008 seem to have changes in setup compared to win2003.

Maybe this one helps ...

http://weblogs.asp.net/nannettethacker/archive/2008/11/17/mailsettings-smtp-network-windows-2008-web-server.aspx

did you enable dbmail xps

-- enable db-mail

exec sp_configure 'show advanced options', 1;

RECONFIGURE;

GO

exec sp_configure 'Database Mail XPs', 1; -- 0 to Disable and 1 to enable

...

- is your mail server accepting smtp from your cluster nodes and sql instances (may need grants at mail software level on the mail server)

- is sqlbrowser running ?

...

altering to varchar(8000) is only a catalog operation (and maybe an index op if the column is indexed) because it stays the same datatype, only the var length changes.

Changing...

Some samples (I'm not sure where I got them from) :

BEGIN TRY

-- Generate a divide-by-zero error.

SELECT 1/0;

END TRY

BEGIN CATCH

...

peleg k (7/28/2009)

---

BEGIN CATCH

SET @Err = @@ERROR

SELECT @ErrorMessage = ERROR_MESSAGE(),

@ErrorSeverity = ERROR_SEVERITY(),

@ErrorState = ERROR_STATE();

END CATCH

IF @Err...

As you suffered, any DRP should include your "day to day working environment" as well.

Don't you just love those 1TB usb disks 😎

Combined with a good Ghost software it...