For the service accounts I mean the accounts that are being used to run the SQL Service. I could be wrong but I believe you need to use domain...

To drop those endpoints from in SSMS open the Server Objects\Endpoints\Database Mirroring. Delete is available from the context menu.

Did you verify that the database you restored on the mirror was...

You might want to delete the existing mirroring enpoints on each server, then go through the wizard again since you got an error the first time through.

Before using the Wizard,...

Microsoft Squirrel? Sounds like what every squirrel that's lost a nut could use.

In SQL Server Management Studio (SSMS) is where you'd run that query to find out the status...

Did you use the "Configure Database Mirroring Security Wizard" to setup mirroring?

You can get some information about the endpoints on each of your servers by querying the sys.endpoints DMV....

If you have AV on the server check its configuration. Some will block SMTP communication by default and require adding in the Database Mail executable to its exclusion list.

You...

Since you mentioned Windows XP SP2 you might want to check that the Windows Firewall is configured to allow the ports that each instance is listenting on.

You can also use SQL Profiler to track down deprecated features. Add the "Deprecation Announcement" event class in a new trace and let that run for awhile. It...

What is it that SQL server won't give you access too?

Are you trying to relog directly to SQL? If so, did you use Windows NT authentication or SQL...

shari (12/18/2008)

---

I tried your example - thanks for posting it! 🙂 However, my output is in the XML in the email sent and I understood the query results to be...

No, it doesn't have to be the name of the .blg file, that was just an example of something you could use.

If you're looking to do some reports...

That's a good question.

It can be any string you want. For example, you could use the name of the perfomance monitor log or anything that would be meaningful to...

That looks close. Doing it that way will create three tables in your database: counterdetails, counterdata, displaytoid.

relog log_file_name.blg -cf counterlist.txt -f sql -o sql:sql_dsn!logfileidentifier

Another option that might...

Sammy,

That's exactly what I was thinking. Don't know specifcally how to code that but I'd think the impact would be minimal if any. Best to test if there's...

Since you can't change the code and responding to the dialog allows things to continue on, then you might want to consider running the application in an AutoIT script to...