I am just looking for a way where a regular user can execute sp_Lock system store procedure.

thanks.

that will script all server roles but how can i script logins associated to a user created DB role.

I tried that but still didnt work.

If am doing os for making it sys proc, can i delete it later, does it impact anything by delete.

I am trying to get users to run it from any DB in the instance to check the Lock Details.

Also how can i test that proc by running as a...

How can i script out all logins / DB's associated with SA login on my server.

can i refresh all the views in a database by using exec sp_refreshview

does shriking the data files or log files gets the server downtime as it ido when we run an alter cmd on sql server.

Instead of changing collation on existing DB how abt this..

1)create a new db with collation required and move data over to the new DB

Or

2) is there a way i can...

is there a way a developer without giving admin rights can run those store procs?

do i need to change anything to run in sql 2005

For changing collation just for 1 db i need to drop,create indexes and constraints. Through SSMS i can script create indexes at once but not drop. is there any script...

what is the impact if system databases and the user databases have different collations.

I found that all my system db's are differnt from many user db's, is it mandatory changing...

For changing collation, how about addinga new DB like dummy and set collation for that as needed and then import all the data from the source DB, how efficeint does...

Does this script queries all the databases in the server or just the db in which you run.

I just want to run only for 1 db which i need.

thanks

hoe cud i do tht, can you give me...