It sounds like your end result is just a dev instance and a standard instance, which is what you are starting with (unless I am misunderstanding).

Why don't you just move...

Use this link to reference edition upgrades.

You do realize that Developer Edition is only for a development environment, right? It's violating the licensing if you are putting it in...

Great information and summary, Grant.

I think what is so wonderful about databases and data as a profession is that we oftentimes are the JOIN (if you will) between the high-level software (applications, code, etc.)...

You need to actually pull the pk value from the PERSON table. You can do this a number of ways.

declare @pkPerson int

select

@pkPerson = person_id

from Person

where...

You want to monitor "user activity", but what kind of activity? That is a very broad statement that needs clarification before a more specific recommendation can be made.

Right, and I agree. But if the OP was to make the clustered index out of ID with NEWID() then it would be that issue. Likewise, I doubt...

In your current implementation neither of those are great alternatives. By using NEWID(), you are causing page splits (if that was the CI key column) due to the random...

The real fix is to not use the text data type. It is deprecated. Use (n)varchar instead.

A workaround to your immediate problem would be to CAST() your TEXT...

The most secure is to be the most explicit. Create a custom role and define the necessary permissions to that role. Then add your user(s) to that role.

Here's...

It's severity 10. Here's a great blog from Paul Randal why this could be worse than it sounds: http://www.sqlskills.com/BLOGS/PAUL/post/A-little-known-sign-of-impending-doom-error-825.aspx

I would also suggest creating alerts for all fatal errors so you can be notified immediately.

If the only functionality you are desiring from the SQL Server Agent service (and the lack thereof) is a scheduled backup, then there are a few third-party tools out there....

Couldn't you just use the STATS option when backing up and restoring?

So basically out of "dbo.filename.storedprocedure.sql" you want to remove everything but "filename"?