Found the problem, using the article SSCrazy suggested I ran SSP and discovered Reporting services missconfigured. Thanks again for all your help!

Ken

Thank you all for your help, I will give all this a try and let you know what happens....

Ken

ALZDBA,

Thanks for your reply and thanks for the tip about the domain admin account. In reference to the domain user what is a better way of starting the services? Should...

I am the DBA for about 25 servers which are a combination of production and test systems some of which are physical machines and some are in a virtual environment....

Another vote for nchar for all the reasons previously stated!

I also agree with the blog 'sometimes the problem is you', I get to work with both SQL Server and Oracle. SQL Server works very well for our small to...

I will retire as a DBA in about six years unless of course something happens that causes me to lose this job!

I have a Ba in Administration and Leadership and a Ma in Computer Resources and Information Systems Management. I am also an Oracle OCP. I spent 20 years in the...

I don't mind doing this job, most of the time, however as I get closer to retirement age I find my interests have shifted. Instead of climbing the career ladder...

The ones I really enjoyed:

Juno

Fireproof

Boy in the stripped pajamas -very gut wrenching film with a hard ending but very good over all

Personally I don't think it is any ones business what I make however, working for a city government, we don't get a choice; our salaries are very public knowledge. I...

Gail,

I found the problem, seems when we moved the databases from Oracle to SQL Server, the SYS and another user SYSTEM came over but since they were not used were...

Gail,

Yes, that is for the AM20 database. I think I need to add some back ground; The AM20 database is one of about twelve databases used by a financial application,...

Gail,

I ran the script and received no output (0 rows). Thanks for setting me straight about HTH (I guess duh!)

Ken

Thank you for all your replys and suggestions sorry it has taken me so long to get back. I attempted HTH's suggestion of using Database copy, but keep running into...