Chris,

Thanks, I will give Delaney volumes a look up on Goggle.

Andrew

I would check and see if they have tightened the hatches on mdtc as on xp and wk2003, search for xp sp2 mdtc on google thats where I found articles...

you could also use smtp mail using the sp and dll available at  http://www.sqldev.net/xp/xpsmtp.htm

The file needs to be empty before it can be dropped, use this code and change the relevant object details:

DBCC SHRINKFILE ([YourTransactionLog] , EMPTYFILE)

USE master

GO

ALTER DATABASE YourDatabase

REMOVE FILE [YourTransactionLog]                                                                                                            ...

use order by NEWID ( )

I would check and see that the file is not set to read only

cant you use this syntax

insert

into beta.work.dbo.Table_backup

select * from _all_props

You could use string functions to seperate the string, but from experience this is a pain when you have ambiguous addresses ie: the larks 25 something street.

A better solution is...

I don't believe you can script this via a wizard the way you can right click replication and choose to script creation. However, the whole setup is done through stored...

Why is it the discussion a dba has with a developer always seems to end in someone in management deciding that the dev guy is right. If a DBA was...

I am assumimng that you are in a high transaction enviroment and presumably large transaction logs when backed up. Why not back up the logs on a more frequent basis,...

I am thinking that by droping and recreating the sp you are effectivley recompiling it. The execution plan it is using is probably out of date, using old stats etc....

Why not create a dummy table and create stats and then rename, that should give you what you need to know

have a look at this article:

http://www.databasejournal.com/features/mssql/article.php/3492046

Hopefully it should help

are you using an odbc connection, is that connection present on the server?