Thanks for the suggestion, but even after adding a share as \\hostname\SQLBACKUP\database, I'm still getting this error:

Msg 3153, Level 16, State 2, Line 1

The database is already fully recovered.

Msg 3013,...

100% full access. I can access it from the server with the Windows Authentication account I am using

EDIT: I forgot to show the error message that I get when using...

Just a follow up, this is working great!

I used the script provided in the solution that George provided and modified so it would actually restore the database instead of...

George....just what I was looking for! My terminology was off...no wonder I couldn't find anything

Thanks!

This is absolute gold!

Thanks for helping out. I'm still 'New Jack' when it comes to SQL Server. I'm learning something new every day. Didn't realize SSRS could do this.

If you run into any issues and need some help, PM me. I'd be more than happy to help

I did all of the migrations and upgrades myself to save the...

Steve,

I figured this problem out a while ago. Our program we were running (Syspro) has some sort of authentication glitch it seemed. AD Group Authentication was working until we had...

Wow....that was way easier than I made it out to be. Still waiting for the coffee to kick in!

Thanks for the help! This will make everything cleaner in the report.

I meant changing the hyperlink in the text box. I am unfamiliar with expressions for HTML so I wanted to know if there was an easier way to do this...

I wasn't aware you could put the case statements into the GROUP BY clause...that's interesting! I need to be more daring in writing code 🙂

Unfortunately the query doesn't work because...

Eugene,

You hit the nail right on the head. The accountno isn't getting inserted into the ITEMSENT table and is NULL. There is no reference to the accountno in the CONTACT2...

Here's what I figured out...

Using SQL Server Profiler, I enabled SP:StmtStarting SP:StmtCompleted in the profiler options to see when the trigger is being run.

When the FedEx software inserts data...

Thanks for the insight everyone.

As someone who isn't a seasoned SQL Server vet, this is great information.

Both users have direct update and insert, that's why I cannot understand why the trigger will not fire for this one user.

The CRM users have a generic SQL User that...

The only roles the two users have are public, read, and write and they're both setup identical in the database.

I'm wondering if it's a case of 32bit vs. 64bit