I tried

grant execute any to username and it did not work?

will this command give execute permission to all SP on all databases or just one database?

I installed SP2,

now how can i clean up old transaction and backup files both using same maintenance cleap plann, I only have option to enter one extension?

I have...

This is my maintenance plann, do I need to change any thing to make it better

This is order in which I ran it Monthly

re-buildindex

update index

update statistic

check database integrity

logbackup

database backup

Daily at...

Hi sugesh,

    grant execute any to sqluser will grant execute permission on all sp for that particular user?

Thanks

Thanks everyone for your help. It was quick and very helpful.

if I give user datareader and datawriter role, will they be able to perform insert, update, delete, select and exec sp with out manually giving exec permission on each SP?

Thanks...

Hi deepak,

My data size is around 7GB and unused space is around 1gb in this case should I shrink it? This is not the size of the logs, this is...

My DBSize is around 7GB and unused space is around 1gb in this case should I shrink it?

sugesh,

"but remeber to keep a minimum space in the file for transactional operations."...

Thanks everyone for the reply

I am going to create new users name with new security model. I am not trafering any user from old server as security was not desing...

Thanks everyone,

   This will be very helpful. But key here would be to install sp2 to make use of Maint Plans.

I do a full backup of T.Log and full backup of database every night but for some reason my T.logs grows unless I manually free up the space.

If I install SP2 will anything go wrong? do I have to recreate maintenance plann?

I did start with a simple maintenance plann as follow!

For the biggest database here's the plann

Full Database Backup everyday ,

Full Transaction log backup everyday,

Re-indexing, update Statistic etc every month.

but for...

Hi cburleigh,

     How can I use MSForeachDB to get detail info on all databased like (size of data and logs files and...

Thanks everyone for all your help. That was really helpfull and pretty fast.