I was finally able to figure this out without doing a re-install.

I have monitoring software on the server that I was installing the SQL 2008 instance on; a 2005 instance...

Rebooting didn't fix either problem... =(

Any other suggestions?

Thanks!

Hmm...

I rebooted before I went to install SP1. I installed SP1 and it erred out at the end. Every since, I've tried to repair the instance (got perf-SQLAgent...

Any ideas? Anyone?

If you are using SSMS 2008, you can View => View Object Details. Then navigate to the "Views" folder. Select the 30 Views you want by holding down...

Nooo...unfortunately not. My schedules all have days and times picked out. All of my reports also have data sources associated with them. I haven't ever seen a...

Things like this???

Unhandled exception caught in Scheduling maintenance thread: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

ui!ReportManager_0-1!1498!03/12/2010-12:12:23:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred...

DM is actually the one that I'm currently looking at. Idera's free version, SQLCheck, is nothing more than what is already built into SQL Server, just in a prettier...

I'm running SP2.

And once I killed the process in question, the application speed returned to normal.

Matt Miller (#4) (11/18/2009)

Would there be a downside to that data getting published...

Typically, would something like email addresses/phone numbers be ok to store in a databases in the DMZ???

Oh ok. That makes sense. Thanks!

Here's the basic structure of the query:

SELECT [COLUMNA]

,[COLUMNB]

,[COLUMNC]

FROM [DatabaseName].[Schema].[Table]

where ColumnC.value('(/Something/Something/Something/Something)[1]','nvarchar(30)')='OOO 0000000-00'

Does that help at...

Hmm...interesting. I already have SQLcompare Professional Edition installed on my computer. I mostly just use it to run regular database compares so I can move database objects through...

Hmm...

Nothing is returned when I run --> SELECT * FROM dbo.sysoriginatingservers;

But when I run --- SELECT * FROM dbo.sysoriginatingservers_view; --- I see

originating_server_idoriginating_server master_server

0 ...