That's the complete sp. Accountdb is a database, accounts is a table.

When I try to run SQL 2008 R 2 Service Pack 2:

Msg 102, Level 15, State...

I would have 40,000 files in that one directory. It helps to keep things tidy.

Here it is for SQL 2005 using subdirectories for each database backup file:

/*************************************************************

Script made by : Lester A. Policarpio

Email Address : lpolicarpio2001@yahoo.com

Date Created : September 03, 2007

--=UPDATES=--

January 17, 2008

- Solved...

Again, each database backup...

All of my databases are in subdirectories so I changed

SET @pathension = 'dir /OD/S '+@Path+'*20110814*.'+@Extension

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device 'D:\sqlbackups\admin_backup_201108141900.bak'. Operating system error 2(The...

Thanks for the explanation.

That sort of explains a restart as we are not supposed to be "involved" on that server at the moment (go figure), but I was curious and...

I had tried both surface area config and run as administrator. The only thing I noticed was signing on one domain worked, while the other did not work. ...

I had same problem. Only solution seemed to be to install SSMS 2008.

http://www.sqlservercentral.com/Forums/Topic1120593-149-1.aspx

Weird when I open in Notepad++, I see just the lf, but with Ultraedit it shows the paragraph symbol, humph...

I have added msdb.dbo to various tables on the actual script that it creates...

--Reverse_Engineer_database_Mail_Settings.sql

USE msdb

GO

Declare @TheResults varchar(max),

@vbCrLf CHAR(2)

SET @vbCrLf = CHAR(13)...

I'm getting an error

use master

go

sp_configure 'show advanced options',1

go

reconfigure with override

go

sp_configure 'Database Mail XPs',1

--go

--sp_configure 'SQL Mail XPs',0

go

reconfigure

go

--#################################################################################################

-- BEGIN Mail Settings JoeJohns

--#################################################################################################

IF NOT EXISTS(SELECT * FROM msdb.dbo.sysmail_profile WHERE name = 'JoeJohns')...

Excellent! Thank you very much.

Yes we do have a dev database server and will be getting one for SQL 2008. We will be testing there.

I did run the upgrade advisor and it found...

They haven't test for SQL 2005 yet.