The links Mark posted will help you with moving the databases.  If you need to move the binaries as well, I don't know any other way than uninstalling and reinstalling.

Why do you need to do this in SSIS?  Just use a trigger.  In fact, why do you need to do it at all?  Having two versions of the truth...

Take your pick:

(1) SELECT @@VERSION
(2) SELECT SERVERPROPERTY('Edition')
(3) Right-click on the server name in Object Explorer and choose Properties

John

The plan will stay in the cache until it's recompiled, or until it gets chucked out because a newer plan needs the space.  Look at the plan's creation_time to make...

Yes, where it's triggers and stored procedures, it's easy - just look up the definition.  But where it's adhoc, you need to get it from the plan cache.  There are...

I say no, investigate now!  Start by fetching the execution plans (and the full query) for those statements.  You can also get aggregate execution stats such as numbers of reads...

DECLARE @Return int;
EXEC @Return = MyProc;
SELECT @Return; -- or try PRINT or RAISERROR

John

Jon

Use COUNT(*) with a PARTITION BY clause to show the number of rows per NUMBER.  If you want to return only those rows with NUMBER greater than 1,...

Start with sys.master_files.  It should be a simple matter to query that to find out where the log file is the largest file, or whether all the log files add...

Sorry, yes, that's the AuditTable table.  I tried to soften the object names and make them more generic sounding, but clearly I missed one line out!

John

Just set up a job that imports the data from the audit file every 15 minutes or whatever interval is suitable for you.  You can have this for free:

Neil

I've been to Iceland at that time of year, and it can be very cold - especially if she plans to stand outside in the middle of the...

SQL Audit?  You may need Enterprise Edition to do database-level auditing in 2012, though.

John