I had issues in my old place in SQL Server 2000 in jobs that are run automatically when Agent starts. The best I can remember is sometime a auto...

You have a problem with SQL Mail. This is the resolution process I normally follow. Re-test after each stage - when the problem is fixed, don't do the...

If lots of people are logging on using the SA account, in SQL Server 2000 and below you can not stop them dropping databases.

You need to move to a new...

Tommy has given 1 way to do this. I can give another way that Microsoft does not object to.

The SQL Login that is the database owner (as shown in...

When you get to look at software, I recommend a TechNet Plus Direct subscription. MS in UK has a special offer for new subscribers until 18 March - GBP...

Here are some references about setting a maximum memory limit on SQL Server 2005

http://blogs.msdn.com/sqlprogrammability/archive/2007/04/30/will-64-bit-increase-the-performance-of-my-sql-server-application.aspx

http://support.microsoft.com/kb/918483

Dave,

A very good article! There is so little good information available on troubleshooting replication problems, so this is a valuable addition.

Hopefully you will haveseen this already, but in 64-bit you MUST set the upper memory limit for SQL Server. Otherwise it treats the pagefile space as part of the...

These are 2 statements that you should avoid if you want good performance and recoverability.

If you are running with Full or Bulk Lokkged...

I think Standard Edition ignores the 'lock pages' possibilities. In any case, Windows is more than happy to rob SQL of memory if something higher up the Windows food...

The problem of installing everything on the system drive is that W2003 behaves as though it owns everything on the drive. A Windows Admin person has told me there...

You need to plan this very carefully, as making any changes for a database of your size is time consuming.

One approach is to add additional files to the existing filegroup,...

A different server often just means a different SQL instance. You could put a named instance on your original server, and use the named instance to hold the archive...

The SQL Server install places a large amount of code into the Global Assembly Cache (GAC) on the system drive. It also always places the installer bootstrap files on...

Most people advise you keep products such as Bacukp Exec well away from SQL Server. They may produce a backup directly from SQL Server, but you may not get...