Here is the script to get DB size and available DB space.

Declare @cmd1 varchar(500)

Set @cmd1 ='SELECT Name as DBName,Filename as Path ,(Size*8)/1024 as MB  FROM ' +'?'+'..sysfiles '

Exec sp_MSforeachdb @command1=@cmd1

For...

Check this 2 msdn link,

http://msdn2.microsoft.com/en-US/library/ms175441.aspx

http://msdn2.microsoft.com/en-US/library/ms176138.aspx

Hope this helps,

Chris,

I suggest you to make sure that SQL 2005 allow remote access  and also

set right userid and password for linked server.

If that is not the case then  look in Security...

First 50 spid are system spid, so remove spid < 51 from your temp table #SPID

before any other manipulations.

Here is the example that shows how to set up Linked Server from 2005

Open Object Browser...

Hi ,

Today I have send an email to you.

Ron,

I will look into it and will let you know.

Thanks,

Hi  Ron,

Just now I have send you an email at your gmail account.

Thanks,

Your reading

you want the Avg. Page Density to be a high percentage and Avg. Bytes free per page to be a low number.

is true in relative context, not in absolute...

Jim,

Thank You.

I will check with specification of exact dir.

One more thing I would like to add to this list is

Look at sql server 2005 server licenses and the fees

Yes, this is new product and as always we...

In my understanding what is happening here is

Node 1 is Mode : U

i.e. update lock, SQL Server intends to modify a row or page, and later promotes the update...

When you run 2000 and 2005 on same cluster and that too with analysis and reporting services

I will not suggest you to go for it as I see following...

There are few other options that you can try to figure out the problem.

1. Instead of using the same SP try simple t-sql using linked server from

both 2000 server, something...

Steve,

Congratulations.

It's definitely great source of knowledge for all sql server DBA's.

Last thursday Apr-6 , I have completed one year from my first visit to this place and can definitely say ,...