Hello,

so it was appear again. 
I dont know query, becuase I got only error code in error log.

before this i found also , so is possible...

got only 
Error: 8646, Severity: 21, State: 1.

I will try drop and create again, execute dbcc, then select and force this index, and then again execute dbcc, will...

Thanks guys,

I will check.
Goal is that I would like to have select of all jobs on these instances with some query(but this is litlte big and...

Hello,
thanks for response.

before was full backup every day, and that was little problem, also with backup system for tape. because like I wrote , every day backup...

Tables where are logins and jobs are different so it is needed to create also on another server. Problem it can be logins, because you have to copy with same...

.

OK, so restore again wasnt helpful ...

So I did this below... I am still talking about TEST Server..

ALTER DATABASE Database

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

DBCC CHECKDB (Database,repair_allow_data_loss)

ALTER DATABASE Database

SET MULTI_USER;

DBCC CHECKDB...

Jeff Moden (3/7/2016)

---

tony28 (3/7/2016)

---

thanks for the reply.. I am not sure if somebody knows what I want...so sorry for my english

Because this is test server and data...

Hello,

try to check WhoIsActive, is very helpful for me..Adam has also 30days blog like documentation..

http://sqlblog.com/blogs/adam_machanic/archive/tags/who+is+active/sp_5F00_whoisactive/default.aspx

thanks for the reply.. I am not sure if somebody knows what I want...so sorry for my english

Because this is test server and data will not be...

Yes , I found...

Gary Varga (3/3/2016)

---

tony28 (3/3/2016)

---

Hello , please can you share...