-

Hello,

May be take a look at the following article:-

http://milambda.blogspot.com/2006/10/exists-or-not-exists-that-is-question.html

Regards,

John Marsh

Hello,

Can you see any blocking occurring when the Query is run on the Live DB?

Also, when you say the DBs are the same, I assume you mean the schemas, but...

Hello,

According to the following thread, the Excel Connection Manager won’t work on a 64 bit machine:-

http://www.eggheadcafe.com/conversation.aspx?messageid=29627397&threadid=29627390

Regards,

John Marsh

Hello,

I think this code is just to prevent the Job from running while a (DBCC) Shrink-Database is in progress i.e.

1) Disable job

2) Shrink the database

3) Re-enable the job

When a job...

Hello again,

Now that the msysobjects table is visible in the Access GUI, you should be able to grant read permission to the table for the user-id that you are supplying...

Hello Ram,

Sorry for having to ask, but could you explain your question a bit more?

Regards,

John Marsh

Hello,

To quote Books Online (admittedly 2005): „Although any user with access to a database can create a diagram once it has been created, the only users who can see it...

Hello,

Does the following thread help:-

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f98cf41a-a1c7-4839-b27a-df0b13908415

Regards,

John Marsh

Hello,

Have you managed to get your reinstallation working? If not, did you see this article:-

http://www.mssqltips.com/tip.asp?tip=1186

Regards,

John Marsh

Hello,

Does this thread help?

http://www.dotnetspider.com/forum/202799-Records-s-cannot-be-read-no-read-permission-msysobjects.aspx

Regards,

John Marsh

Hello Mike,

What version of SSRS are you using?

If 2005 (or above) have you also tried deleting the Subscription via the (Report Server specific) Object Explorer? Pleas see BOL Topic “How...

Hello Reddy,

If I understand correctly, as you intend to...

Hello again,

Is that not what you want?

Normally I would have expected that if the Primary Key(s) already exist in the table,...

Hello,

Have you tried restarting IIS? Sometimes the issue can be cured by stopping the Report Server, Restarting IIS and then starting the Report Server again.

If that doesn’t work, do you...