Browse by Tags

Windows Server 2008 deploy within your environment securely!

Published 6 March 8 2:50 AM | SSQA.net

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day...

Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment

SP_HELP_REVLOGIN for SQL Server 2005

Published 4 September 7 8:54 AM | SSQA.net

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...

Filed under: sql server, security, server, login, self, copy, sp_help_revlogin

SQL Server does not exist or access denied

Published 13 August 7 5:10 AM | SSQA.net

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...

Filed under: sql server, security, server, mdac, client, access denied, exists, does not, network

/3GB /PAE and AWE blurb what is it you hear within your environment?

Published 25 July 7 9:6 AM | SSQA.net

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...

Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked

SQL Server 2005 Service pack 2 re-release & too many builds

Published 15 May 7 3:17 AM | SqlServer-QA.net (SSQA)

I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what...

Filed under: sql server, security, server, search, replication, sp2, i/o