I've got a follow-up question about this. The ASP.NET application uses SSL, and the Reporting Services report is on a different server, behind our forewall. When I ran the report from home...

Hello Lisa,

OK, I've been experimenting and I am really not getting this.  It might be best if I work through an example.

Let's suppose my report is called ProviderData.  It has...

Ray,

So, what you're saying is taht all Reporting Services reports get published to http://servername/reportserver, so that they can be run from http://servername/reports, correct?

And if I may ask another...

Ninja's,

I got the error when I attempted to open (view) the job history.  I've no idea if it is in the history or not.

Oh, I see.  OK.  Because of the original error message, the name of the job should be "Backup_SystemDBs_Weekly".  I have no idea why the job name was missing the beginning...

Sorry I didn't reply earlier.  We were experiencing network connectivity problems last week Friday.

Anyway, why is it you believe that renaming the job will help?

What do I do?  Call them up and say something like, "I think I've found a bug in SSMS, can you verify this for me, please?" or something like that?

Ninja,

You wrote:

Select IDCol FROM dbo.MyTable WHERE ISNULL(Col1, '') <> ISNULL(CONVERT(VARCHAR(newsize)), '')

What I am not following is the condition in the WHERE clause:

ISNULL(Col1, '') <> ISNULL(CONVERT(VARCHAR(newsize)), '')

What are you accomplishing...

"Take another backup and go take a break..."  I love it!    Maybe I'll make the change and then go on a vacation...

You are correct, Wanderer, we did not attach any of the system databases, when we attached our databases.

I've noticed that none of our maintenance plans came over as well.  Are...

So, MG, is it the case that being able to view the DTS packages is not on by default?  I spend some time on Microsoft's SQL site to see if...

I've thought about this question, but more from the opposite end.  Who would I not want.  Unfortunately, I have more experience with that.

For example, two years ago we were very...

alzdba, the sp_change_users_login system stored procedure did the trick, thank you very much!!!

No, the DBA's uninstalled SQL 2000.

So, what do I do now?  Is the only way to fix this problem is by using SQL...

Thank you, Stax68 and Claudia.  I appreciate your help.