Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you
Read More...
Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites: After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample. You
Read More...
SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only defined via server event triggers, it has become more and more popular in same scenarios to prevent users with a certain machine environment accessing
Read More...
