The functioanlity is mostly data processing and if im honest I dont know why it wasnt written in SQL to start with, so for example pass in a start and...

You need to restore the transaction log against a backup of the database. I'm not aware of any way of undoing the changes. I take it your running the database...

My understanding is you can only Rollback a transaction if the command was issued inside a transaction.

For example:

begin transaction

update whatever

rollback transcation

will allow you to roll...

Check out the Network Configuration properties of your MSDE. I think by default when you install MSDE the Network Configuration isn't configured.

Go to Enterprise Manager right click on the instance...

Thanks everyone.

Something like this should give you some ideas.

Dim oFso, oFolder, cNewName

 Set oFso = CreateObject("Scripting.FileSystemObject")

 Set oFolder = ofso.GetFolder("C:\Inetpub\wwwroot\Development\ppnet\")

 cNewName = Replace(CDate(Date),"/","") + Replace(Time,":","")

 oFolder.Name = cNewName

 oFolder = Null

 oFso = Null

 DTSGlobalVariables("Backup Folder").Value =...

Hi,

I'm not sure if this is the sort of thing your after?

select * from #sql s where date = (select max(date) from #sql where id = s.id and date !>...

Thanks I figured it out in the end.

I was using an ActiveX Task with WshShell.Run (strCommand, [intWindowStyle], [bWaitOnReturn]), I just switched on the WaitOnReturn and it works perfectly.

Thanks for your input.

Jon

Thanks all for your input, much appreciated.

Jon

I'm based in the U.K. and I think it would be very difficult to encourage people into IT as its such an insecure area right now. Rightly or wrongly (and...

Hi,

I'm not going to pretend to know the answer but I googeld and found these links, not sure if it helps;

http://dbforums.com/t931276.html

http://www.mcse.ms/message409767.html

Jon

Are you saying that they've never been able to update or just since you made the change?

Check out Updatable Subscriptions in BOL.

Still no luck.  I have been trying to do the restore through enterprise manager.  I did have the options tab checked for moving files.

On the options check out...

The destination location for the data and log file is different to where it orginated.

Does c:\data\sqldata\MSSQL\DATA\ exist on the stand by server?

If it doesnt you will have to MOVE...

Dont know if this helps but you can use SQL Profiler to trace\monitor the logins to a server. This will monitor all connections (which may or may not be what you...