I didn't find much on Lumigent either.

Does Red Gate have a similar tool for SQL 2k5 & 8? (I've got the Credit Card ready.)

I looked @ the Apex product -...

Ok. Thanks, I'll dig into that a little deeper, taking the role route.

Yes.

Basically it confirms the information I already had: logical name, physical name.

I was surprised to see that the file group name for the log was Null (rather than Primary), but...

I understand the risk with a Simple recovery model. I initially created the database with full recovery, because I was mirroring it to another server, with a witness server, too.

My...

Thanks for all of your suggestions.

Currently we are running SQL2k5.

I like the idea of periodically loading batches of data - this could easily be done in the wee hours without...

SSIS is a good suggestion. However, the developer in question lives, breaths & may die from VB6.0 - note XPROCs.

Thanks.

Will give it a try.

We're now getting into the reports pages with http://localhost:8080/reports/pages/folder.aspx.

However, if I try to open the report I get a logon failure - nor was I prompted for a...

I understand the principals of SQL Browser, but we haven't utilized it yet. Do I just configure it to automatically start, or do we need to perform some configuration of...

I'm not familiar with Ultra Edit, but will give it a look over. I'm more familiar with PSPad & NotePad+ - don't know why I didn't think of these.

Thanks

Sam

When I open the viewer I have to wait 4-5 minutes before I can engage any filtering. What I'd like to do is stop the viewer from loading, so that...

I got it. I went to the Local Policies MMC snap-in. There I located the different permission settings I had & then removed the bogus user accounts.

SQL now runs like...

My bad.

All servers are running W2k3 SP2

All but 1 server are running on is running Microsoft SQL Server 2005 - 9.00.3282.00 (Intel X86) Aug 5 2008 01:01:05 ...

I'm getting the following errors:

ServerTaskNameErrorCodeErrorDescription

MY_SQL2Collect Backup History3Variable "User::SQL_RS" does not contain a valid data object

MY_SQL2Collect Database Status3Variable "User::SQL_RS" does not contain a valid data object

MY_SQL2Collect Disk Space - requires OLE...