My company has created an in-house application that we use to manage passwords, keys and access to them.

all data is stored in SQL tables and is encrypted by the application.

The...

All of the reliability concerns are valid; however my main concern is with the way the legal system views data ownership.

It is my understanding that you have to...

I participated in a technical SQL forum at Tech-ED in Orlando this year that focused on Intellisense that Microsoft is developing for SQL.  We saw the current stage of their development...

Steve,

I wholeheartedly agree with you.

Another interesting note about SQL 2005 SP2 is that Windows Vista REQUIRES it.

Here is a link to a story about it.

http://www.eweek.com/article2/0,1895,2050368,00.asp

It is very interesting that...

Thanks for the quick answer.  I don't feel quite as stupid as before, however my opinion of Microsoft has been reduced.

I wanted to let everyone know that I was able to rename the SQL server this past weekend.

By attempting to set up replication on the SQL 2000 server, I was...

I tried to set up replication on the server in order to then disable it to see if this would resolve my issue.

I received an error when I clicked Finish...

Ok after running

use distribution

go

select

* from dbo.MSpublications

I get no rows returned.

I spoke too soon.

The distribution database was detached

I have reattached it and am running the query now.

thanks

There is no distribution database on the server.

Thanks for the quick response.

Running sp_helpdistpublisher I get no results

Running sp_get_distributor I get installed=0, no distribution

running sp_helpdistributor I get null results

My main problem is  I don't know what database...

Thanks for your help, however I was already aware of these articles and omitted no steps.

The problem is the stored proc sp_MSrepl_check_server that is run is finding entries in msdb.dbo.MSdistpublishers...