Got to admit that I don't have an answer for you right away and I'm not completely sure what you're trying to accomplish. I don't believe "smashing two things together"...

Thanks for catching that, I should have been a little more careful with my summary. The exact words that Microsoft uses, as Grant lead on, says

A common table expression...

A Common Table Expression is a temp table with the scope of a single DML statement. There's all kinds of cool ways to use them but the basic syntax is...

A-Rod has appealed and Big Mo blows 3 saves in a row.

You guys see this? Hidden Ball Trick

Too funny, made me look up other occurrences of this trickery and I...

Boston and Tampa Bay are 1-1 in this current series of 4. We gotta win out!

Man, every time I post in here I think "where's Ray?"

Braun, what a disappointment. Everyone gave him the benefit of the doubt and here we are two years later looking...

xp_delete_file is an undocumented extended procedure. Google it for parameters and usage.

Please fully understand the risk involved when using undocumented procedures before implementing them in any environment.

Try putting the .bak in the data directory with all your other MDFs if possible.

and the service account has permissions to the file and folder?

1: make sure the path really does exist via windows explorer

2: make sure the service account has proper permissions to the folder/file

3: make sure YOU have proper permissions to run...

Perhaps some table definitions, test data, and expected output?

Your issue is probably file permissions. Try running a script to restore the database and see if it errors out, look for "Access Denied" or "Can't find the file path...

Back? As in, back on the DL? 🙂

Where the heck did the Rays come from? Holy cow! Last...

So confusing.

You've restored from a backup successfully.

You've attached the .mdf file successfully (what about the .ldf?)

Seems like it should all work but your application cannot connect.

Have you remapped the users...

nope