Its not crosstab query, I am joining 4 tables. I have changed to 80 but still getting the same error.

Pei Zhu,

How did you solve the issue?

Thanks for your reply. Here is the info in summary.txt

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows 2000 Professional Service Pack 4...

Did you fix the problem?, I have the same issue please let me know if you have solution....

Greg,

It works but not showing server level permissions.

I have to do that using SQL Sever

SQL Server 2000.

Unfortunatly there is no other way, yes I have to go by order.

Thanks for your help.

Thanks Steve,

I haved added dt AS ST_Date, a.dt AS END_Date to your script (in SELECT Statement)

here is the result I got

custST_Date ...

Thanks for the reply.

Please see my answers for your assumtions

1. No it can be any where

2. Can be 2 out of services but need the latest one

Note: The max date...

Hi Justin

What is the rate?

I tried xp_fixeddrives but don't know how to find the total space .

Thanks Shane! Would you please explain what you did?

Hi, Thanks for your response. I tried from management studio didn't find a way to change.

alkrup, I created login and created user in test db with db_owner option. When I...

This is what I exactly did.

Loged into management studio using SA

created database test

created a table Table_1 in test database. When I look for owner (both object and database )...