You should firstly look a the locking on the table maybe this is not configured right. I would then do as the first person said comit the tran on each...

you must have alot of transactions, try monitoring then and asking people if they can change what they do of if they are processes try changing them to run at...

Congrats to you both , maybe I will be there oneday, 😉

Hi there you will need to do a select * from sysfiles, this will tell you what your log filename is you must have called it something diff.

t

The process for clearing this is as follows

1) dbcc opentran(dbname) - this will show the oldest open transaction

2) Kill this process command kill suid

3) backup log...

Maybe you should try bcp the file program itselft, are you sure the file is in the right format and you have the right headings for the columns.

Terry

Yes you can just input the group message

Exec master.dbo.xp_sendmail

@recipients = 'Group@Acme.com',

@message = 'have a nice day',

http://support.microsoft.com/kb/271509

This this is what you want, T

osql -E should log you in automatically, however, if you don't want to use that and use another user then type osql -U username -P password

I second that 2008

What is the error you are getting? There might be a problem with your shell. Have a look at microsoft books online.

Hi there this is a bug with service pack 4 look on microsofts website it tells you there what to do.

Regards,

Terry

go to jobs in the server management studio right click on the jobs script to create and to clipboard then click the connect button, select the server you wish this...

SQL Server 2005 T-SQL Recipes - A Problem-Solution Approach or the sql cookbook

Yep I would use logshipping probaly every 1hr depends on how fast your line is and the over head on these systems.

Regards,

Terry