The SP runs through the pre-reqs without an issue, but once it gets to the available instances screen it does not allow the new instance to be selected.

Thank you, I appreciate the info.  Ironically the vendor asking for this change is installing an application to monitor our servers with the purpose of INCREASING security.

We ended up going with an IBM v5000 with RAID10. The price for the IBM was only a couple thousand more than the EMC with RAID5. The configuration includes tiered...

Thanks for the input! Much appreciated.

Is that with a RAID5 disk array or RAID10?

Wish we could go with all Flash, but not sure the budget is right for that!:-)

I think more info might be needed to best answer this.

1. Are you running this process on a recurring basis?

2. Are all rows in the destination table deleted each time...

You need to filter on the join if selecting only specific records in the left join.

I.e.

Select a.*, b.*

From a

left join b on a.id = b.id

...

I think i figured this out. I was ending the conversation each time an event was fired and because of this, it was causing the event notification to be...

You mean you aren't the know it all DBA that our employers expect us to be? 🙂

Here are the errors, i forgot to post them last night!

7 variations of this...

Bingo, that worked. Log Spaced Used % is down from 99% to < 3%

Thanks a bunch!

I did have Transactional Replication setup at one point, but i removed it in favor of Snapshot Replication. Transactional Replication is not supposed to be setup on this database.

DBCC OpenTran returns:

Transaction information for database 'Askesis_Dev'.

Replicated Transaction Information:

Oldest distributed LSN : (0:0:0)

...

Hi Everyone,

Figured i would ask the question on this topic.

I have a database set for Full Recovery, which I run Snapshot Replication on for DW purposes once per...

Just a thought, but with the addition of the need for the windows group SQLServer2005SQLAgentUser to have SQL sysadmin permissions in SQL 2005, doesn't this create a fairly large security...

Ok after auditing successful logins, the local admin (SQLAdmin) shows as being able to successfully login, even though it is not setup as a SQL user.

Login succeeded for user 'Server\SQLAdmin'....