Hi Craig and thanks for the speedy response. The [ProbTicketDate] field is a DateTime field. An example of what's stored in the table - '1/4/2010 12:00:00 AM'. ...

OK, I guess this is what you meant by this part:

"Note: you might have to do some conversion for the date fields if required nad >= nad <= condtion if...

Thanks Only4! BTW, could you please explain to me this part:

SET @sql = ' SELECT * FROM PROBLEMTICKET WHERE 1=1 '

I'm not familiar with...

Thanks Craig!

Thanks Greg! Works great.

Thanks Andy!

Thanks to everyone for their help. Yes, installing SP4 solved the problem for me. But not until a painful day of a wild goose chase. Why? ...

Thanks for the reply Jeff. The script or code I used is for the parameter's default values. I had to use default values for my report so that...

Hi everyone - just wanted to pitch in. Trying to also set up my subscription to send out at the very last day of the month. I've got...

Thanks very much Perry! Actually, we were trying to restore the system databases from a clustered server to a NON-clustered server thus all the problems and the creation of...

Thanks Ed! Totally agree - when stuff hits the fan, the last thing you want is someone who isn't the DBA to be messing around with the system DBs...

Thanks Simon! Wow, this document will definately be a useful template for creating our own DR procedures. Looks great. Thanks again.

Thanks Ramji - our cluster does use a SAN so your tip is definately useful!

Hi and thanks so much for your help. Your suggestion sounds like the most feasible solution for our situation. We've also thought of perhaps setting up the DR...

HI and thanks so much for your reply. Yes, this is a very rough way to go about this and it's been a very unpleasant experience. I guess we...