i've a similar requirement. My server has a really messy security system. there are different domains with different trust level and users are granted access to the SQL server by...

Sorry guys.. for not replying with my updates.. I got busy with my new born baby.. IT'S A GIRL!!!

I got the dbs scripted out using the Publishing Wizard and...

Thanks for all your suggestion guys.

I will go for Brandie's second option. The first option is difficult especially because of the size of the dbs and it is difficult...

We had lot of trouble while migrating from 2k to 2k5. And our applciation is so big that it took us months to finaly come to 2005; but all the...

I don't know why in SQL 2005 they removed all the cool features that were there in SQL 2K.

In 2K, it was easy to generate scripts only for indexes on...

i too had the same troubles with the character limit of transact sql agent step..  and searched a lot for a work around. but in vein..

so what i do now...

Oh... i cant believe the solution is no simple....thanks buddy.. 

--shiji

when u give hte kill command again, does it show the expected rollback time.. is it any reasonable time?

i'm a developer grown dba,  but it has never occured to me that datatype of column names are more important than informationof hte table it belongs to.

i prefer to...

i'm a developer grown dba,  but it has never occured to me that datatype of column names are more important than informationof hte table it belongs to.

i prefer to...

I agree with ur suggestion.. let me tell you what we do in our project..

in dev environment we give dbo permission to all developers and in production, create permission...

thanks Steve, that solves my problem with less trouble...  --Shiji