Or look at properties for the icon on your desktop if you got it installed, which for me yields:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

SQLWB.exe is the SQL Server Management Studio.

Really is only 3 ways I can think of that will convert a db from 2000 to 2005.

1) Detach and attach like you did

2) Restore a SQL 2000 backup to...

I don't think you can export the grid from Server Management Studio.  I've dealt with similar problems and ended up DTS'ing the package to an Excel format and then attached the...

All the selects are local.  The input buffer just has the stored procedure name and the parameter (XML data in a text variable).

We do have linked servers, but all to...

Immediatly before it crashed there is a stack dump.  The last thing in the error log before the ones associated with the stack dump is my backup 5+ hours earlier.

Here...

Guess my first inclination would be to have the job send an email to whoever needs it when it finishes.  Just set the job to send an email whenever it...

I can answer both yes and no! 

I grew up in Norway, was an exchange student in Iowa, went back to Norway to finnish high school, went to University of...

Seems like I found the problem.  My login did not have access to the share the snapshot was on.  For some reason it did not give an error message.  The...

Don't think you'll be able to use a trigger for this.  Trigger's only get triggered...by some event, i.e. most of the time due to an insert/update/delete, but now in SQL...

38 is Role Name, so should be the right one.  There are 64 columns total, see sp_trace_setevent for a full list (or at least as full as I have found).

Have...

Not familiar with SQL Express, but in 2000 creating a login with password encryption set to off meant you did not encrypt the password going into syslogins.  This was used...

I have a timestamp on a table I do somethign similar ( a report of DDL changes in the last 24 hours).  The part of the where clause looks like...

You could try the following to see if the login has serveradmin rights:

select

IS_SRVROLEMEMBER('serveradmin ')

Run this in...

Most likely not the answer you are looking for.  But at least one other person has run into the problem it seems.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=526047&SiteID=1

To read the file created from above use the fn_trace_gettable function.  To get a count of how many calls has been made:

select

count(*)