Patrick Wright

Pat Wright's SQL Blog

<November 2008>
SuMoTuWeThFrSa
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456


Navigation

User Groups

Bloggers I read

Conference info

Subscriptions



2005 Presentation

So I did an overview 2005 presentation yesterday at the Salt lake city MS offices.  The slides will be posted to www.msutahevents.com.  It was fun and overall I had a good time seems like most people are really interested in 2005.  I was reading through the reviews and it looks like I didn’t do to bad.  J  I apologize to some of you who wanted more in depth on the migration and installation aspects.  We were going more for an overview so I didn’t go to far in depth on that topic.  Perhaps a follow up in the UG for SLC would be good. 

 

Oh one thing I did learn from yesterday is that you can Disable a DDL trigger instead of fulling dropping it.   Here’s an example from BOL

 

CREATE TRIGGER safety

ON DATABASE

FOR DROP_TABLE, ALTER_TABLE

AS

   PRINT 'You must disable Trigger "safety" to drop or alter tables!'

   ROLLBACK;

GO

DISABLE TRIGGER safety ON DATABASE

GO

 

 

On a side note if you want an interesting article on something not even released yet.  Check out Computerworld!

 

http://www.computerworld.com/softwaretopics/software/story/0,10801,109567,00.html

 

Thanks to Kent Tegels for finding this. 

 

 

Pat

posted on Thursday, March 16, 2006 12:40 PM by pwright77





Powered by Dot Net Junkies, by Telligent Systems