wont work because @EmployeeNo is int and so is @AccessLevelID.

Server: Msg 245, Level 16, State 1, Line 17

Syntax error converting the varchar value 'SELECT ' to a column of data...

ok.. I was trying diff options and here is what I found out... when iam querying using single table then no matter how many times I change transformation and create...

Yes I will be charge of reports and wanted to make sure I dont have to install anything on prodn db.

Thanks for the reply... Thats what I was looking...

Well, I want to know the dependent objects like procedures,functions which use this column.... Will this INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view help me get that apart from the column constraints??

Thanks.. anyone else has...

Thank you everyone for the replies. I have set the margins as 0 and it worked for me. I tried by making margins very small 0.25 but still didnt work....

Success atlast... Well what I did was rather trial and error and it solved my problem. I tried what Jessica said but it didnt work for me but helped me...

I am using client tools to connect to sql server which is on remote server throught lan. I am able to connect to this remote sql server using enterprise manager...

 How are you "Connecting" the error indicates that

A) you do not have a valid SPID on the network.

I am not sure what SPID is. Can you tell...