The move to have a centralised government database containing an individual's digital ID, biometric information, tax & benefits details, and criminal record is happening just about all over the developed...

The 'DOS'environment provided by xp_cmdshell is a subset of the command window environment.  In particular, it does not include some of the standard pipes available in the command window, including...

The biggest benefit of .Net 2.0 is that is gives all the performance of Java with none of the headaches of cross-platform poirtability.

Adding the WPF, etc stuff introduced by Vista to...

You need to add your role to db_datareader and db_datawriter.  This may not seem the right way to do things, but it works.

Congratulations and very best wishes to you all for the future!

I completely agree that Red Gate is just about the best organisation that you could have sold to.  Also, congratulations to...

If you are running 32-bit, everything is the same.  Just as in SQL2000, the only aspect of SQL2005 that can take advantage of AWE memory is the database buffer pool.

If...

You probably need a lot more than 1 GB of RAM.  Try going to 8GB and using AWE for your database buffer pools.  Also consider moving the RS workload to...

When you install SQL2005 a number of local groups are created.  These groups are intended to hold the service accounts that run the various SQL services, and are assigned the...

Are you seeing some underlying application issue that is now causing an actual problem.  Your new environment may be running more things in parallel, allowing an application fault to show...

Is your second instance using a different TCP/IP port to the default instance - see BOL on why this is important.  Have you allowed access to the new port through...

The 'fixed memory size' or 'lock working set' button is in SQL2000 only, not in SQL2005.  If you are managing a SQL2000 you can choose this option, but it is...

If the SPN is set up with the correct service account and SQL port, there is no need to de-register it.  SQL will try to create its SPN on startup,...

If you job title is 'SQL Server DBA' you are entitled to put that on your CV, even if you have never touched a computer.  All you are doing is...

Balmukund,

I am getting the message you describe, but SQL 2005 is very definitely running on the box.  I can see the service in the Windows Services applet, and can connect...

In order for the MCA qualification to be worth having it must have a good ROI.  This means that prospective clients or employers need to understand its value.  If the ROI is there,...