Robin

Tom.Thomson (4/6/2010)

---

No Lynn, you can have it:-D. I don't have the patience. And I probably don't know enough abot SQLS...

mathomp3 (4/6/2010)

---

Sadly there are no other errors.

The generate script runs perfect no errors, creates the script clean. I take the file which is saved, push it up to the...

Really? Anyone want to take this one?

Post the results of the following:

select name as databasename, log_reuse_wait_desc from sys.databases

GSquared (4/6/2010)

---

If you pick Monthly on the schedule form in a job, you can pick last day of every 1 month as an option. Will that not do what...

Please post the exact and complete error message you are getting. Can't diagnose a problem based on what you have posted.

ritu.thatola (4/6/2010)

---

Sorry to say this, instead of helping me you guys are writing......

I am not a Database person.... Just trying to solve some problem and I hope that this forum...

This may or may not be what you are looking for, but I have no test data with which to test it.

SELECT

*

FROM

#tmpTicketInfo...

Pear

And I am seeing how nasty and complex it could get using dynamic sql as well. Although case statments may result in a long query, it may be the...

Two questions.

One, why does it have to be dynamic?

Two, why eliminate CASE statements when they may be appropriate?

I really see T-SQL as a core competency for both DBAs and Developers.

I agree that some people may never work in a replication, or log-shipping, or database mirroring, or clustered...

Here is the problem, you are only giving us PART of the problem. If you want better answers, give use the whole problem, plus the code you have already...

May I suggest that you provide the full requirements of what you are attempting to do as well as any code you have already tried writing to solve your problem?

With...