Browse by Tags

All Tags » security » server » SQL Server
  • SP_HELP_REVLOGIN for SQL Server 2005

    SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure and it is described in KB article 246133 . Though it talks about SQL Server 2000 version ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on September 4, 2007
  • SQL Server does not exist or access denied

    I hope you will get to see the above error message most often and I say a common question among forums & newsgroups. Few times you might be thinking why it is throwing error even though you are using right credentials to access that SQL Server instance. I have seen such as the basic assumption by those users getting this message believed that ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 13, 2007
  • /3GB /PAE and AWE blurb what is it you hear within your environment?

    You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that : The /3GB ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on July 26, 2007