c4ntaloop (7/11/2013)

---

Thanks Steve.

So that makes me think in what real scenario do we want to use contained database? We know that it can have contained users and solve collation issue,...

Even though SQL 2014 is by far not complete in CTP1 and more is to come, you should be ready for a new way of developing Datawarehouses - if In-Memory-OLTP...

Catch the stuff you want to log inside a Variable. After the rollback you can still insert from that variable - it does not get emptied.

 

very good.. I will try that myself anyway, it seemy like its worth an extra practice.

Sorry for hinting you in the wrong direction, but I think the encryption-topic is definetely...

Hi, I'm sorry

was just a good guessing, since I have no time to test it presently.

Next week I'll have a Class in Reporting-Services.....

and Re-encrypted the DATABASE-Master Key with the new Service Master Key?

ALTER KEY -- DB MAster Key

ADD Encryption  -- service master key or your password for testing

>>or you could just exec sp_rename...

 

which is not the point I was trying to make - I was trying to stress was the GUI (which USES sp_rename) actually DOES

Also check in the "Properties of the Server - Security Settings" from the Server in Enterprise manager whether mixed authentication is enabled - that user you are using in your...

I totally aggree on Jeff, except that the "rename" of the new well designed table won't be a "snap". Rename is just not possible with SQL. It might look like...

With SQL 2005 you can easily implement a DDL-Trigger in the database.

like

CREATE TRIGGER log_ddl_statements

ON Database

FOR ALL_DDL_STATEMENTS

AS

"Code for raiserror with log and log into table"

 

 

AW

I am not quite sure and cannot test it right now. Bute maybe it goes this direction:

The encryption key inside that Catalog database is secured by the Service master key...