What's wrong with sysfiles?

This also will work in SQL 2000 (not in SQL 2005)

DECLARE @data_path NVARCHAR(260)

EXEC master.dbo.sp_MSget_setup_paths @SQL_path OUTPUT, @data_path OUTPUT

PRINT @data_Path

Across the LAN or across the WAN? Are these the same domains?

What is happening...

You can try to use Visio.

I had a similar "simple matter disappearing" issue. In my case it was SPN problem. The fact that your connectivity sometimes works and sometimes doesn't is saying that you probably...

Actually, this error

is pointing to the fact that your firewall is not configured properly. It is not a...

I am running 3 instances on a test machine.

2 named instances of SQL 2005 and 1 instance of SQL 2000.

2 instances of SQL 2005 are 64 bit, while Standard 2000...

Sure. If DB is over 2 GB combined size - you will get errors, since 2GB is maximum FAT32 allows.

BTW, MS does not recommend using FAT32 for SQL server.

Why...

General answer would be yes, since the backup file format irrelevant from the file system, but then it depends.

If the backup size is over 2GB (FAT32 limitation) - restore on...

Didn't quiet understand what is it that you are trying to achieve, but no, database can only have 1 primary data file.

Did you try this one?

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

Can you please clarify what config value for SSRS did you change? From what to what?

Also, AWE on x64 based OS with x64 based SQL server does not have any...

Excerpt from http://www.databasejournal.com/features/mssql/article.php/3372131

"Now not just anyone can run this extended stored procedure. If you want to execute this extended stored procedure, you will either need to be a...

In sys.objects?

1. Please, make up your mind. 🙂

2. In SQL 2005 there is no...

And what version of SQL server are you talking about? In SQL 2005 you can use C2 audit option, for example...

http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/