You can check the below link also.

http://www.sqlservercentral.com/Forums/Topic1148215-391-1.aspx

setiv (7/29/2011)

---

There is a possibility of a competing tOne.citID and tTwo.citID.

This is where the rack is pepper?

I see

Server: Msg 213, Level 16, State 7, Procedure pDataGet, Line 9

Column...

Ok Jannie, Thanks.

Hi Lowell,

Thanks. Is this same for both 2005 and 2008?

Ninja's_RGR'us (7/21/2011)

---

I knew I gave you something different from the original question (which had already been answered as far as I know).

My Code gives the row count and table size...

I did it suresh, It is working for me as per your 1st reply. My problem already solved by your solution.

But when I see Ninja's reply I just want...

Hi Ninja,

You code will give all table sizes from all databases. But I was looking for only database sizes. When we use sp_spaceused without any parameter it will give db...

Yes Suresh,

This is enough for me. I have replaced sp_spaceused with SELECT * FROM sys.database_files.

Thanks a lot.

I had faced something like same 3-4 years back. That day network guy came and did some changes in IP configuration. Most probably DNS Server. Sorry, Do not know actually....

Hi Lowell,

Thanks a lot.

Now only I got an Idea about the installation. Thanks.

Hi All,

I have attached services list of 2 different systems. Would you please check and help me to confirm which one is SQL Server and which one is SQL Client....

Thanks to you all for your solutions.

🙂 Welsh/OPC, I was just giving an example. 🙂 and looking for...

Welsh Corgi (7/15/2011)I'm sure that there are easier ways to identify this. If you do not have local Host registered or are unable to register your local machine then you...

Lowell,

Here I have 15 systems which have been already installed with SQL Server. But now I have to find out which all systems are installed as CLIENT and which all...

Can you replace those Nulls and Zeros to 1 before running the query?

Or you can use a CASE WHEN to replace it in the query, but using CASE WHEN...