could be Typo

or make sure you run the query in the AdventureWorks database, not in 'master' (usually the default DB after login)

SQLrecon should work

SQLRecon performs both active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise. Due to the...

the "SQL Server Service" account needs READ/WRITE access to the folder

I don't know if you can EXECUTE AS for the BACKUP DATABASE code..

Backup to LOCAL and copy over works too...

It's easier to do it in BCP or SQLCMD, without opening up xp_cmdshell for security reasons

And I find SSMS Result to Test good enough most of the time

This SSC article does ONLINE/OFFLINE re-index, and sends report in Email

http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/

SQL Server 2005 Upgrade Advisor?

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

Give it a try, I don't know if it'll work in your case, it should

Yes (you'll notice my Query came from the KB) and Yes, and many others...

I suppose

Standard ISO (IT Pro) is the 180-day Enterprise edition trial

Developer will lead you to MSDN, and probably the free Developer edition ISO (same feature as Enterprise, licensed for Development...

I guess I like the code, so I tweaked it a bit into a SELECT only, and added 'column' filters

so you can only search in SELECTED columns (if you know...

Interesting, my trial download of SQL 2008 Enterprise ISO worked fine (I can unzip it to a folder and install too, instead of mount the ISO)

http://www.microsoft.com/sqlserver/2008/en/us/try-it.aspx

Alternative is to buy the...

I use Remote Desktop quite often too, and in the back of my mind I have always feared 2 things

1. Hit Shutdown instead of Logoff (especially in Windows 2008, the...

I would skip the MSI installation, and find the scripts (along with lots of CSV's) to manually create the AdventureWorks 2005 DB

I don't know why MS makes it so difficult...

Kishore.P (12/2/2008)

---

Dean Jones (12/2/2008)

---

Hi All,

I was wondering whether there is a script/way out there in which one can monitor disk space on a network shared drive, I know once can...

Local System is pretty minimal, safe for a local SQL instance

If you need Network-features such as back up to UNC, talk to other servers etc... use a domain account if...

Not to my knowledge

Plus, the fact that it used to happen every 30~40 mins, and now 60-90 mins (after changing MIN/MAX memory settings) seem to be not network-copy related. Wouldn't...