i never used FULL TEXT SEARCH, how does it work in the queries.

thanks

So.. Finally like 'column%' is better than like'%column%' but i think both of then scan the table instead seeking though i have index on column

As you guys said if like...

any suggestions?

1st step:

Here is the list of users i am dropping..

but how do i drop them all at once?

2nd...

THanks Jeff, QUOTENAME helped me.

Jeff

Incorrect syntax near 'QUOTENAME'.

I get error when executing the procedure not within the proc.

if i replace with print i get this error:

Msg 241, Level 16, State 1, Procedure ReportTrace, Line 19

Conversion failed when...

I am executing store proc and getting the error, its not included in the proc

Guys.. any suggestions, I am seriously looking to grouping my drives. really appreciate your input

thanks.

I am looking for this because i regular update data on a stage server and then move DB to production with name DB_new and then swap old and new then...

I think instead of doing that i can map manually, its the same but i am looking for something easy to use.

I know that but that just creates login not the mappings to different databases

No. I have a login in which i have so many dabase mappings out of which that login has different preveliages on different tables and now i have to create...

yes, your second statement is right. I want to group drives of each servers into one large drive.

that is what i am doing now, please read my concern again.

thanks