How to define database owner SQL server wide
What does it actually mean that the database doesn’t have a database owner?! It seems odd, but, it is possible.…
Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download
SQL server 2014 Community Technology Preview 1 (CTP1) is ready to download here: http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx Key Features Project code-named “Hekaton” One…
Drop tables from selected schemas database wide
In my previous post called “How to drop tables database wide using T-SQL” I’ve explained that how we could delete…
How to drop tables database wide using T-SQL
There are some cases that we need to drop all tables database wide. For example when we have a test…