I disable the replication and Distribution database is gone.

Thanks for all your help.

Special thanks to David.

Yes,

How about if i try like this.

sp_configure 'allow updates', 1

reconfigure with override

go

UPDATE master..sysdatabases SET category = 0 where name='distribution'

and then delete the distribution database.

Sorry about that.

Thank you Jeffrey.

Steve.. Thanks a lot.

I like your idea of denying connection to sql server. Here is the TSQL I am going to use. I will deny connection for all the users...

Steve.. It's a AD group account in SQL Server. The reason I am trying to disable these user account because I don't want any user to connect to the server...

Account has folllowing rights

SecurityAdmin

serveradmin

setupadmin

sysadmin

I checked the domain name and it's correct. I can disable all the logins except NT Group Logins.

Individual logins are there.

I found a weird issue. I backed up database from sql 2000 server and restore on sql 2005 server. This weird table does not exists on sql 2000 but somehow...

the weird thing is I backed up the database from SQL 2000 and restore on SQL 2005. This table does not exists in SQL 2000 database but somehow got...

That is not a temp table. It's a real table with # in the begning.

Actually, Some Analytical users are using this database and they create whatever they want.

I have removed the dbo prefix but still getting an error.

drop table #tablename

I tried but no luck. Looks like AD group login has issue. Actually, what I was tyring to do is to disable some logins for particular time so that process...

I tried using [ ] but getting following error.

Msg 15151, Level 16, State 1, Line 1

Cannot alter the login 'SUTTER-CHS\SC.IT_Data_&_Web_Services', because it does not exist or you do not have...

I have figured out the issue.

The query I was using was like that.

Select * from serverName.DatabaseName.dbo.[tablename]

but the table name had space at the end like this [tableName ] so I...

I think Ahmed misunderstood the previous reply, it was Mani not me, we both are singh that is why you got confused.