Yes, i am having problems in creating this in ssis package, if any one can send me their email, i can send the sample db bak file to you, and...

Very wonderful of all you guys, Wesley, Paul,John...

Actually i am creating a package, what the package needs to do is, whenever there is any change in the S1 table it...

Thanks Steve,

But is there any other way to restore this files to sql 2000 or 2005. or again thts the only way as u said.

As James said above will be the ideal solution for your issue, if not then instead of restoring directly from network, you can copy a backup file to test...

Lynn:

I was needing this output for a report, i am getting the output i wanted in both the report and in management studio,

but the issue is in my report i...

Thanks Lynn ..you are genious, it work the moment i just clicked..

thanks a lot

Thanks Luke,

i guess this will do for only one entry of such URL, i have multiple URLs in the table, how should i do that for each such.

I dont know what was the problem, but i solved it by creating a database script from the database setup tab and then created the databases reportserver and reportservertempb from...

Anyone had this issue before? I dont know what to do now.

Anyone had this issue before? I dont know what to do now,

Thanks Krishna,

well before enabling the trace flag, i just want to know is there any impact of it to the sql server, if not i will enable it.

FYI

one thing is...

How do i enable the trace flag 1222?

Thanks

can anyone help me in this issue,

Roy: Nice that you use Litespeed, i have do this sql native backups my manager wants to save money in this recession period, I think you wont be needing any...

how much time does it take for you to restore the database from the Network location?

do you use any 3rd party software for backup/restore?

and how do you take the backups,...