Another possibility is using SSRS (Reporting Services) and setup a subscription that emails the Excel file on a daily schedule.

Can't remember if I've done this, but I think you can set up a linked server to the Excel spreadsheet and then setup a SQL Agent job to run that...

Chrissy,

Take a look at this link:

http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_thread/thread/a7fb460d6f83b826

You may need to access the server with an admin account and enable EXECUTE permission on the procedure in the master db for...

Also, does this work from your login?

declare @SmoRoot nvarchar(100)

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT

select @SmoRoot

It looks like that command returns the location of your SQL Server installation, no matter the particular version you are using. But why you are getting this error when you...

so one of the DBAs tried using EXEC master..sp_grantlogin 'mydomain\login' and this has fixed the problem.

I didn't setup the server or the logins, so I'm not sure exactly how it...

Jared, I'll have to give that a shot. But first, I need to make sure I won't cause more problems by deleting and re-adding that login!

Jared, the main dba in our group runs a script which re-maps any un-mapped logins to db users for all databases. I've seen a number of similar scripts here.

Jared, where would I look to check the domain permissions? That sounds promising, but the job is owned by the same user on production and is running ok. Thanks for...

Yup, everything's fine there, and same as on production box. Enabled property is set to true, but that's not the same as the HasAccess property, which is still false.

Maybe you should create an update procedure that takes a table-valued parameter. Then you could use a cursor or some other means to loop through the table values and create...

Well, I have a hunch it's related to the PGP whole disk encryption, but I haven't found much online about installing SQL Server on top of that. Maybe it's not...

Only thing I can think of is to script it out. I sometimes find that scripting is faster and less of a pain than using the GUI.. sometimes!

**Update**

I detached the questionable database, stopped the sql server, copied the mdf and ldf files, renamed the old files, and used the new copies to re-attach the db.

Now everything's...

Suresh,

DBCC CHECKDB WITH TABLOCK gives me this error:

Msg 5030, Level 16, State 12, Line 1

The database could not be exclusively locked to perform the operation.

Msg 7926, Level 16, State...