Hey Steve,

Thanks for the response...

I could try a DTS. Basically I am running a SP on the server in the US office.

I'll create it in a DTS and see...

Andy,

The LSN is not the TLog file name. LSN is the Log Sequence Number which is an internal sequential number within the TLog. When a transaction is written...

Not sure if anyone else has found a way, but I don't ever recall seeing that.

Personally, for me anyways, it defeats the object of Windows Authentication of you must enter...

Thanks for that Antares.

I did a bit of digging and found that Read Only turns of Auto Update Statistics, so I'll go with your idea on that one!

Cheers!

Clive Strong

clivestrong@btinternet.com

Sorry...Its one of those Monday mornings...

Don't use Performance Monitor...Use Profiler!!! My mistake!

Clive Strong

clivestrong@btinternet.com

Hey,

First off, I'd run Performance Monitor. Capture all transactions for that Database. You can filter using DBID (Look that up in Sysdatabases in the master db).

All off the...

Hi,

Is the log file backed up? If TLog's are not backed up, they will continue to grow until they eat up all of your disk space! So if...

Hey,

We produced a solution here that does what your asking. It's very simple...

Basically, we have a table that holds the name of a job and the start time.

At the...

Sorry...I missed the replication bit on the end!! Doh! Never tried that one!

Sorry!

Clive Strong

clivestrong@btinternet.com

Hi Christine,

Yes you can move DB's without recreating the DB itself. You can use the following commands...

EXEC sp_detatch_db 'pubs'

EXEC sp_attach_db 'pubs',

'e:\SQLData\pubs.mdf',

'l:\SQLLogs\pubs_log.ldf'

Obviously...

Silly, I know but when the View menu is not displayed, did you left click on the DB first? I found that if you don't click first with the...

I don't believe there is a way to pass return codes etc between steps in Scheduled Jobs. To be honest, I never thought of trying. Maybe you can...If...

You could call the SP as the next step. If it fails, it goes to the next step which is the Stored Procedure. If it passes, set the...

Hey,

Use....

EXEC master.dbo.xp_sendmail

and also use the full path when referencing your tables in the select query.

Clive

Clive Strong

clivestrong@btinternet.com

Hey,

Firstly you need to have the mail task configured within SQL Server and running. (green arrow will confirm it's running). Once that is done, create a new scheduled...