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

This sounds like a joke that ''How many DBAs you need to change a light bulb?''. I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by a DBA or how many DBAs you need to manage a 400+ SQL Servers within their environment. I believe ...

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server application too. So now the question is will there be any limit on the number of databases to ...

How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the event of a disaster. You may not be able to predict the exact details of a disaster, but you ...

Hot topic in the industry about the server consolidation and how you can take advantage by planning for SQL Server 2008 that is poised to release by next year. DOWNLOAD the document that consits the information on Server Consolidation DOWNLOAD the datasheet for Server Consolidation Finally WebCast on the Server Conslidation...(read more)

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is available to process this command. For the error text it looks like the system is unable to fine disk ...

The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft SQL Server Analysis Cubes for Microsoft Dynamics GP ...

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of the reason that memory has been a constraint on scaling-up server capacity. Once you consider ...

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

Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds of business logic that programmers can write with these languages. But think about performance ...