I wouldn't advise you to do this, for the following reasons:

(1) SQL Injection, as already mentioned by Gail.

(2) Permissions. If all your access to the tables is via stored...

Nobody's going to help you if you won't help yourself. Try writing the code, and post back if there is anything you're struggling with. Having said that, if...

SQLCoder77 (10/4/2010)

---

Here is the approach I am thinking, Get the NextRun DateAndTime and minus the time between Runs to get the last Run and verify a record exists in sysjobactivity....

Yes, because you didn't include the WHERE clause. But even if it says 1000 rows affected, it will still only have actually made any changes to the ones where...

Don't know why it didn't work when I tried to post this script directly, but I've managed to post it as an attachment now. It's the script I use...

I think the REPLACE function should be what you're looking for. Try using that, and post again if you're struggling with it.

John

With the limited information you've provided, then, I would suggest you have a look at what the triggers are doing.

John

What other activity was occurring on the database at the same time? What is the transaction isolation level? Are there any triggers on the table?

John

Sasidhar

Have a play with the File System Task - that should be able to do what you require. You can use variables and expressions to build the names of...

steve block (9/16/2010)

---

One thing I found out is that taking the group NT AUTHORITY\SYSTEM out of the SysAdmin group made it so I could not start a service (Agent or...

Did you follow the link I posted? If so, what don't you understand?

You might also consider using the EXCEPT keyword to keep your code neater and more concise. I don't know whether there are any performance differences between that and Chris's...

Are you saying it works when you execute a RESTORE statement, but not if you use the GUI? Have you tried running a Profiler trace so that you can...

My advice is to plan properly and then only install what you need. Anything that is installed for no particular reason and then configured as an afterthought is likely...

Sree

Please will you post your query so that we can see whether there is any better way of doing this. I don't think your SELECT INTO syntax is correct.

Thanks

John