Best practices

BEGIN TRANSACTION

COMMIT TRANSACTION

ROLLBACK TRANSACTION

Hello

I have been going through the same process on my end. What I ended up doing is doing a nightly backup of my DB that overwrites itself everynight with the...

I'm assuming that your doing this in Query Analyzer. Try doing it in Enterprise Manager.

Right click your database>All Tasks>Shrink Database>click on Files button on bottom right>Select TLog in drop down...

Hello John,

Have you tried truncating the log first in query analyzer?

(i.e. -

BACKUP LOG DB_NAME WITH

 TRUNCATE_ONLY

)

I usually truncate then shrink.

I hope this helps you.

Thanks,

LL

http://www.w3schools.com/sql/default.asp

http://www.w3schools.com/sql/default.asp

http://www.powerasp.com/content/new/using-frontpage-to-set-up-a-database-connection.asp

Good example.

http://www.databasejournal.com/news/article.php/3494821

Appears your connection sting is missing "Provider=oledbconnection" before your "Server".

In Visual Studio for your code behind page you need to add Imports System.Data and Imports System.Data.OledbClient if your using this...

Angela,

Currently I have gave the developer access ( SELECT ) to sysjobs and sysjobsschedules tables in msdb database. His comments were "to create/schedule jobs, I need to be able...

Thanks for the help dbgeezer. I just gave him select to sysjobs and sysjobsschedules.

Lawrence

Thanks, If I just give him Select rights to sysjobs and sysjobsschedules tables that is still secure right?

The developer is a trusted source. He needs to create/schedule

jobs. If I gave him read only would that be secure enough?

Thanks,

Lawrence