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

I would also recommend getting some dvd training it is very good. Maybe by learning tree or someone like that.

Depends on how much space you need, I would probably Install everything on one disk and raid the other two keeping your databases on the raid, it is always cheap...

Who are you using for your smtp connection? Maybe they are blocking this, do you have a microsoft or unix server in office that can access the net if so...