I've worked with SolarWinds software before and would check with them. They probably have the fix for their code as a patch/hotfix/update or something. I don't recall ever...

Oh, forgot about that.

If it ran on multiple platforms we would loos stability (I think), I'm fine with it being a Microsoft OS only. Alot cheaper than that Oracle program :hehe:

Just a shot in the dark...but on the Connect to Server prompt when you open SSMS look at Connection Properties and see if "Connect to database" is set to <default>...

Adam Bean (4/23/2010)

---

You and me both. I just dropped and re-created the NT group with sysadmin, default database master, and new query still defaults me to this user database. Crazy...

The only though I have is on this page it mentions:

When you first connect to an instance of SQL Server, the default database for the login is...

If it is a standalone server you can follow this:

http://msdn.microsoft.com/en-us/library/ms143799.aspx

A test can be what hostname is returned for this query:

SELECT SERVERPROPERTY('ServerName')

SELECT SERVERPROPERTY('MachineName')

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

Are you refereing to Microsoft SQL Server or MySQL, because the Microsoft product will only run on Windows OS.

Do you know of any issues that occurred during the timeframe with your Domain Controller(s) that host those user accounts?

Where did you pull that SID number from? That type of information is not going to be found in SQL Server system databases. You will have to look...

Good article and instruction...however

I would move that warning you put on the "bottom" of the article to the "top" of the article. Or at best make it read lettering...

In general if I come across an application error that does not generate anything on the Window Server logs or SQL Server logs I look to server side traces or...

http://www.sqlteam.com/article/working-with-time-spans-and-durations-in-sql-server

I'm not a big writter of SQL code but the link above looks like it might give you a good starting point. Since you will need to calculate 60...

As Mike has stated server-side trace is much less intensive in that the trace will only capture records of the events you specify at the beginning. If you use...

That has nothing to do with SQL Server. I suggest you contact the support/web master for that site.