Dynamically shrink the transaction log with a stored procedure

One of the things I see often on SQL Server forums is newbies having trouble with ever-growing transaction files. They...

Here is the answer to your question

"Dynamically shrink the transaction log with a stored procedure"

http://codetempest.com/node/10

Also: I concur with the above. Unless you have some explicit need for the full-logged...

You might try Yul Wasserman's uspKillAllProcesses script first, right before you run the shrink.

April 5, 2002

Terminate All User Processes Script

http://www.databasejournal.com/scripts/article.php/1491381

Also see his other scripts:

April 12, 2002

Three Administrative...

Try this undocumented stored procedure. This will grant SELECT on each table for a given user.

exec sp_MSForEachTable 'GRANT SELECT ON ? TO MySQLUser'

Best to avoid cursors when you can use...

/* SQL Server Cursorless Cursor  */

/* http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=529 */

declare @rc int

declare @RowCnt int

declare @MaxRows int

declare @Email nvarchar(255)

select @RowCnt = 1

 ...

Your best bet is of course ***not to use cursors***. I have been a DBA for over 5 years and the number of cursors I have needed to used I...

No. It has alwasy been this way in SQL 2000 (and SQL Server 7, for that matter). Shrinking the Transaction Log dynamically (without, say, detaching the database, deleting the ldf,...

I got this off a MS site a while back and use it every week to force shring the transaction logs on all my large DBs. It's set up here...

Here's the script to create a job that shrinks both the data file and the log file on TempDB. You can adapt it to suit your database.

Note that it basically...

Here's a script I saw on SSWUG (apologies to the Author for not citing it but it her/his name may not have been in the comments):

***************************************

create PROCEDURE...

Check this out. It's about as close as you will get. Give you all logins and their encrypted pwds. Good for moving logins from one server to another.

Migrating Logins...

If you want to see an example of a script that generates some SERIOUS HTML (to make a nicely formatted data dictionary) check out http://www.sqlservercentral.com/scripts/contributions/1005.asp

Hi. Here's one I got off of eggheadcafe.com a while back and have used variations of it many times. Personally I avoid cursors as much as possible because SQL Server...

Access is a great "inside-the-LAN" front end for SQL Server. I used it for this for years.

There's no decent way to web-enable the whole thing, howerver.

You will need...

I use SET TRANSACTION ISOLATION LEVEL in all my reporting where the data does not have to be up to the minute (which is most reports most of the time,...