Download the developer free version and start using it, in addition to the previous suggestions.

Hi Scott,

like I mentioned earlier, the WHERE clause is added afterwards in my application (so the user can choose to see archived corporations only, active corporations only or both)....

• This reply was modified 3 years, 11 months ago by homebrew01.

Edit...

• This reply was modified 3 years, 11 months ago by homebrew01.

Is this some kind of guessing game contest ?

I have never encountered that. Is it possible some step is running after the restore that changes the recovery model ?

I don't think your group by should include

s.OH,

o.SOQ,

" ...There's also nothing that will prevent the user from changing databases after they login and, they usually do have to.  Most people end up being taken to the "Default Database"...

• This reply was modified 3 years, 11 months ago by homebrew01.

How about

INSERT INTO DataMap.dbo.Audit_Logins
SELECT ORIGINAL_LOGIN(), GETDATE()
where db_name() = 'DataMap'

• This reply was modified 3 years, 11 months ago by homebrew01.

--Create a symmetric key, to be used for column encryption
CREATE SYMMETRIC KEY BeersKey
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE Beers;

'qwerty123' is more complex. I never encrypt my beer,...

• This reply was modified 3 years, 11 months ago by homebrew01.
• This reply was modified 3 years, 11 months ago by homebrew01.
• This reply was modified 3 years, 11 months ago by homebrew01.

Now that you're on paid SQL 2014, have you configured compression in your backups, since you mentioned storage is a consideration ?

Using a SQL Scheduled job to run backups has...

• This reply was modified 3 years, 11 months ago by homebrew01.

SQL Trace, or newer tool, Extended Events.

What happens when you try to attach the MDF ?

Could you create a new database with the original name, create a filetable for it, detach the new database, then attach...

"...I eventually went to a paid version, and now am on 2014, ..."

You could take the opportunity to set up a simpler backup strategy using native SQL. Some people don't...

• This reply was modified 3 years, 11 months ago by homebrew01.

Did you check the table exists ? Does the DROP have a WHERE EXISTS clause ?

Maybe there was an error at some point after the table got dropped, and never...

I did not get an error on a 2008 SQL Server, but...