Hi

System user in msdb without login

We cant rstore the db from bak even the compatibility is 80 ??

HI

SSMS is connecting to server correctily

I am using the windows login. I added the id to Administrators group and then it is working fine. I am able to connect...

yes

If i connect from other machine all r working fine.Problem with local server only

I tried to execute select * from sys.databases

it is also showing the same error -Access denied.

sql service is running under windows functional id.I given registry privilages to that id.still it...

It is opening

But if i tried to execute the script it showing Access to the path is denied.

I tried -use master. it is working.But if i put sp_helpdb -error

Access...

Hi

I am having sysadmin rights in sql level.I created a sql script in notepad and tried to open , it is working.But when I tried to open new query it...

HI

Nothing on error log.

Hi

Yes.The recovery issue is only for one db.all other are fine.

Hi

DBCC is running every sat

HI

as per client request we are restarting the services.

HI

This is a production server. daily we are restarting the services.The problem start happening since last week

Hi

When we restarted the sql services other dbs came online fastly.Only one db taking more time to become online. it is in recovering state

try this

select invoieid from testtable where invoieid not in (select invoiceid from testtable where itemid ='C')

Thanks alot