+1

I totally agree, I suppose they would say you can try it with the Express version

but I'd rather try the 180-day trial version

It could be that your company SMTP does not allow open relay to Hotmail

I see DISABLED on our SQL 2008 server too (installed from SQL 2008 Standard ISO with Key pre-filled)

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9...

BACKUP DATABASE dbname

TO DISK = '\\ServerName\ShareFolderName'

should work most of the time, IF SQL Server Service account has permission to the \\ServerName and \Folder

Otherwise, quickest way may be

1. Backup locally

2....

I agree

I skimmed through the XML chapter in 70-431 book quickly

Then I changed a job, then I had to learn and use XML functions and now I'm pretty good at...

Or live with 180-day evaluations

I don't have MSDN, debating on what to do for my home server

Windows 2008 Trial and SQL Server 2008 Trial? hee hee

Either remove all of them, then re-insert

The SET ROWCOUNT 1 is a neat idea I didn't think of

I was gonna suggest adding an ID identity field, that way you have...

http://www.ssmstoolspack.com/

I don't know if it supports 2000 though, it works for 2005/2008

One learns something new everyday, thanks Luke

It wasn't far from my assumption that it's a success if Database Mail delivers to SMTP, period

However, if there's SMTP errors (such as incorrect...

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1519113&SiteID=1

Besides the Backup-and-Restore, Detach-and-Attach should work too (detach DB's in 32-bit, attach them in 64-bit)

I can't say for certain about system databases though, you should test it to be sure

Unless...

My RC trial has 5 days remaining 🙂

I liked the product too, well enough to do a survey with Clair and David

The price tag did surprise me a bit, because...

I would think you're out of luck with Windows 2000

XP should be okay

Google returned these, looks like the SQL Server 2008 Express won't run on 2000

http://technet.microsoft.com/en-us/library/ms143506.aspx

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

As for Client Tools installer,...

CREATE TABLE #tblDistributor(

[DistributorID_PK] [int] NULL,

[DistributorCode_FK] [int] NULL,

...

Unless indexes are heavily fragmented, no need to REORGANIZE/REBUILD the indexes

occasional sp_updatestats won't hurt

but if everything runs smoothly and quickly, don't worry about it

This may help

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

Interesting, why did you post in SQL 7/2000 forum when this is SQL 2008 issue?