With Windows 2003 Standard edition 32-bit you need to add the 3Gb switch to the boot.ini file, otherwise SQL Server (or any other application) can't use more than 2 Gb.

Standard or Enterprise Edition ??? 32 or 64-bit???

SQL 2000 doesn't have the xml datatype or xquery support. So you have to translate the data or store it as varchar or text.

Markus

This should work:

GRANT VIEW DEFINITION TO UserName

Markus

If I remember right you can only have one SQL Server instance for each cluster group. So you cannot add a 2005 instance on a existing cluster.

So eiher create...

Check the logfile for the maintenance plan. At least I hope you configured logging.

The logfile should give you more details about the problem. The default path is C:\Program Files\Microsoft SQL...

Which OS and SQL Server version are you using?

It all depends on what you're doing and which features you use.

See here for an overview of all the possibly breaking changes:

http://weblogs.sqlteam.com/mladenp/archive/2007/07/10/60252.aspx

I don't understand what's the problem with using DTS ? I know it's not perfect but it has been designed exactly for this kind of tasks.

Markus

Bob,

your problem is that while the users are stored inside the database and part of the backup, the logins are stored in the master database and thus not included...

About your fist question see here:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e465827e-a822-4c64-b04a-5fcfbcbcbf4f.mspx?mfr=true

About the encryption right-click the file or folder you're looking for, select properties and then click advanced.

Markus

Just As Gail already wrote you could first check on the fragmentation level using sys.dm_db_index_physical_stats but keep in mind that on very large tables this too can take a...

No, there no relationship I'm aware of between jobowners and the SQL Server Service account.

I think what you mean is the SQL Server Agent service account. If the jobowner is...

It depends on the how your index(es) are defined. If your clustered index is on an identity...

That's the Windows Servicepack level. Your SQL Server build 8.00.760 means that the SQL SP version is 3.

Markus