Silly question, but did you check the C:\ on the computer you ran this from or on the server it is executing against?

Awesome, he'll be very happy on Monday 🙂

Great points by SQLRNNR. Also check the local administrators group on the server running SQL Server. Any user who is added to the local admin group, will be...

Sounds like homework 🙂

What have you been able to come up with so far? Can you please post your TSQL?

1. Have any "new" records been inserted into the RestoreHistory table since they database was restored?

2. Try dropping and re-creating the trigger

You can't alias the "*"

You need a comma after the star, like so: DECLARE @Employee TABLE (FullName varchar(10), Salary money)

INSERT INTO @Employee

SELECT 'John Doe', 85000 UNION ALL

SELECT 'Jane...

I believe you actually need to install the Report Builder functionality

Try this: http://technet.microsoft.com/en-us/library/dd207038.aspx

You can use this snippet of code I found online (I believe it came from mssqltips.com), this will give you the proper files to load since your last full backupDECLARE...

You could more easily do this via SSIS (whereby you could set the "destination" of the SQL Task to a file destination, setting all kinds of options), however in TSQL...

Yep, or you can add it to the base amount like so:

SELECT 58261.21, ROUND((58261.21 * .1), 2), ROUND((58261.21 * 1.1), 2)

Is the service account a member of the local admin group on the server its running on?

Hey everyone! It's ugly code Friday!!! :hehe:

Here's the ugliest way around the issue (as pointed out by SQLRNNR)D-ECLARE @String varchar(250)

SET @String = 'xxxdb_backup_2014_02_06_073328_1849272.trn'

SELECT LEFT(@String, CHARINDEX('_', @string, 7)) + REVERSE(SUBSTRING(REVERSE(@String), 5,...

Please post your execution plan (you can obtain this by pressing "Ctrl-M" before running your query. Also, obtain the STATISTICS IO and TIME for the query (for each one)...

Yes if/when you need to reinitialize the publication you will lose all the data in the STAGING server....not much you can do there. The only suggestion I could offer...

You can also use this script (there are many at this site by the way)

http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/