Yesterday there was an interesting question about SQL user MS_DataCollectorInternalUser.The question was something like – ” ms_datacollectorinternaluser is showing up as a login less user.  Where did this come from? Can I remove?…

Today I accidently came across the option called ‘Hide Instance’ flag for a SQL Instance. This property looked pretty useful for me in case I don’t want anyone to browse for my SQL Instances…

As we have a new version of Adventureworks database for SQL Server 2012 RC 0 I wanted to start my testing on the same.I downloaded the mdf file from the…

Yesterday in one of the SQL forums there was an issue which was reported by one of the user.The question was something like – ‘I accidentally deleted the only Login…

Recently I was asked this interesting question – I need to revoke all privileges from a single table in the database,how can I do that? Solution is simple – Using…

  You can easily find that using   SELECT LOGINPROPERTY(‘TestUser’, ‘IsLocked’)   You can unlock the login using   ALTER LOGIN [XYZ] WITH PASSWORD = ‘****’ UNLOCK ;   GO…

Today I came across an error Property Owner is not available for Database ‘[DBName]’. This property may not exist for this object, or may not be retrievable due to insufficient…

  Quote Adding BUILTIN\Administrators back to SQL Server Recently I had to add BUILTIN\Administrators back to the server and here is what I had to do for the same.  …