You cant make read only a SP, but you can control who can edit all stored procedures trow permission. if your users arent in the sysadmin role or db_owner and  dont...

Thanks for another option, i test with a no so big Log File and it works.  Very helpful information in Bol to understand better the shrink process.

Pancho

Very usefull SP, do you have more documentation about this Extended SP?.

Thanks !

Pancho

I'am totally agree with you, but some months ago i was in a situation, where i was trying so many ways to reduce the size of the log size and nothing works. That's...

I always use the next:

Backup LOG <Databasename> WITH NO_LOG

GO

DBCC SHRINKFILE (<Logfile>,<newsize MB>,TRUNCATEONLY)

GO

And it always works. If doesn't work you should think about detach and attach db with...

I always use the next:

Backup LOG <Databasename> WITH NO_LOG

GO

DBCC SHRINKFILE (<Logfile>,<newsize MB>,TRUNCATEONLY)

GO

And it always works. If doesn't work you should think about detach and attach db with...

I only wants to add , that if you make the .exe file of the Visual Basic Program who makes the call to DTS , IT Works only makes an...