if u are connecting using sa login it will not give any error regarding access. If u are connecting using windows authentication, that login id should have permission on...

you can use order by at the end of the querry

u can use inner join in both table joins

check for relavant dbcc commants and add it to the scheduler

can u just put the querry or or some structure of the querry so that one can reply ur querry quicker

The main purpose of cross join is to give the all possible combinations of the join of the two tables

use the below querry,

select top 1 with ties teacher_id from

(select t.teacher_id, count(*) 'cnt' from teacher t

left join student s on t.teacher_id = s.teacher_id

group by t.teacher_id)

order by cnt...

u can try database_id

u can store the table which are storing files into seperate filegroup which should be placed on seperate disk. Then if will not effect the performance of ur application...

in case of view, u have to use it viewname.column name then it will b ok

just apply service pack2 for sql 2005 and you will feel good once u update the service pack

u can use

sp_executesql

try the below querry

select id, col1 from table

union all

select id, col2 as 'col1' from table

order by col1

what u are looking for is not clear?,

present your clear requirement.

use

convert(char(20),@radius)