That's what i've done so...

sys.dm_tran_active_transactions will. I'm not aware of a way to get the statement from that but by looking at the sys.dm_tran_loks you'll be able to see what objects the tran...

I think i'd go down the SSIS route with some file system tasks...

Thanks,

Simon

Thanks, that's more what i was after. 🙂

It's ok.... cracked it.

-- Query to return the item nos.

SELECT

convert(int,convert(varchar(50),I.query('text()'))) AS Item

FROM

@tableToHoldXML...

Do you have any benchmark ping times over the WAN? It may be worth investigating the response time over the WAN to see how it compares to "normal operations". If...

Hi,

Thanks, sorry, i should have said the the job steps will need to be appropriately configured.

Simon

Hi,

Check this:

http://msdn.microsoft.com/en-us/library/ms186757.aspx

That'll probably do the trick for you.

Thanks,

Simon

Hi,

Use this:

ALTER DATABASE YourDB SET SINGLE_USER

Then drop it.

Thanks,

Simon

Hi,

You may want to investigate doing this using SSIS. I do something very similar but restore a copy of our latest DEV base database over my own local copy.

Essentially the...

Hi,

1) No, it can replicate all 3.

2) Yes if you set up replicate schema changes to TRUE.

Thanks,

Simon

Hi,

Whilst i didn't actually attend this course (a colleague of mine did) i did go through the course material. I found it very useful because at the time i was...

Hi,

If you mean intelli-sense then i'm afraid native support for this in SQL Server 2005 is not available.

There are a few 3rd party tools that will give you this...

Hi,

If I were you'd i'd start by looking at the error logs in the Log directory for your SQL instance. I'm sure there'll be some useful information in there.

Mine are...

Hi,

I would look into mirroring if I were you it sounds like it meets your requirements better. Also, if you're using a .NET application to connect to the DB you...