Agree with Cowitz ... Its a simple and easy way to get what u want....or is it that u want it in a different way than this...

Cheers!

Arvind

Do u by any chance have a BACKUP??

Cheers!

Arvind

If you have more than one updates taking place at the same time on the table then u will get the error, so simply insert the values from the deleted...

I am in total agreement with Phil, If u dont wish to use a DTS then u may simply use jobs to take backup and restore and use a NT...

Sorry guys i thot this might be related...

the code below doesnt work for me...any ideas

 

declare @x varchar(20)

set @x = 'notepad'

exec xp_cmdshell @x

cheers!

Arvind

i am sure the jobs were running under the Built In/Admin users...but y wud u want to remove the permissions from built in/admins...

Cheers!

Arvind

TCP/IP is better than Named Pipes any day...owing to the performance and security.

Cheers!

Arvind

Hi SXG, one small question..

quote:

---

6. Had you been running in simple recovery mode, in a few moments, these log records on...

You could run a query get the list of databases from the server where u got the backups from ....and give the query the location of the backups on ur...

FYI also check

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

Arvind

On second thought you could also try running dbcc checkdb individually on your databases in query

analyzer and see if you get any error report.

Cheers!

Arvind

I agree with Ray...If you see the Job History with the Individual step details it will usually give you the exact step where the error occured with a some description.

Cheers!

Arvind

I dont think you will be able create a column level constraint that will use the values from another column. But I guess you can do this using a table...

I agree with alkanfer and ian ...U can use a simple query with case statements in case the data u r trying to fetch is limited to less number of...

Yes I totally agree with Matthias..U need to install Client Access ODBC Driver(s) on ur server with SQL Server.

Cheers!

Arvind

Arvind