The status is shown as "This database has not been configured for mirroring"

Thanks for the reply.The endpoint is already in place.

No. It gives me the message "Unable to connect to the server.The specified URL might not be valid or there might be a problem with report server version or configuration."

I...

It does not have any entries for today.

Can you guide me how to look for Reporting services log?I am too new for reporitng services.

Hi,

Yes. I have configured it.I am using the URL which is displayed on web service URL tab.

Thanks for the reply.But none of the packages are using sa login for connection. The SQL Agent is set with sa login and the same is modified with the new...

One table (used as a temporary storage place) may contain rows from 100 to 10000 + depending on the amount of data we need to match with our master table.

The...

Thanks a lot Dave. That worked. The query which was executing within 45 minutes now gets executed in 1.45 minutes !!!

Thanks for your reply. Having a computed column looks a good option in terms of performance. But I was wondering why SS2K8 should take more time than SS2K?

I also tried...

Thank for the reply.

It is BROKER_TRANSMITTER which has maximum wait_time. Can this be optimised / disabled?

Regards,

Rohit

I did not change any collation related setting. Default collation is same as the current one.I suspect one thing that might have caused the problem.We were trying to migrate the...

I checked the collation of the instance (right click SQL Server registration->properties->General->Server Collation.

It is SQL_1xCompat_CP850_CI_AS which is same as database collation

Hi Lutz,

I was planning to create a table with all 150 elements and insert them when the XML file is received.

I think the second option, suggested by you, is better...

Hi Lutz,

Thanks a lot. This is what exactly I was looking for. Only thing is my tags which will appear in NTFRS will be dynamic,means,any tag can appear out of...