Any chance of seeing the code and the table definitions?

You can only have one distribution database per instance.

alanm 5339 (1/8/2014)

---

I ran your CheckDB command on each database on the server (not including the system ones). Each one just reported that "the command completed successfully" and nothing...

Why didn't you address the problem when this or the scheduled checkDB job started to fail? (You do have a scheduled CheckDB job?)

You're probably going to lose data as a...

Log the job output to a file (properties of the job step -> advanced).

However, you have larger problems, run the following, post the full and complete results and start doing...

Script the permissions from dev before you restore (semi-manual), run the script that recreates the permissions after the restore.

http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

We still don't have enough information about the problem to even guess at a solution. I can't read your mind, I can't see your server.

GilaMonster (1/6/2014)

---

Get the book I recommended,...

Can you post (as an attachment) one of the error logs for the server?

chandan_jha18 (1/7/2014)

---

Thanks. But the index which is being used is having only 1 column and if the other column is being retrieved internally from clustered index, shouldn't the execution plan...

Don't restart, it could well be a waste of time.

20GB is not huge for a TempDB and if the files grew to that size is means that TempDB needs to...

Break it into multiple procedures and ditch all the ELSE statements, you don't need them and they're making things more complex

IF (@Var = 1)

EXEC PROC1

IF (@Var=2)

EXEC...

Chapter 3 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Backup buffers, thread stacks, linked server drivers, CLR, few other things too.

Chapter 4 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

joey6401c (1/6/2014)

---

Thanks for the reply

I modified my query but it returns an error

Delcare @dt date

Set @dt = GETDATE()

select distinct v1.name 'Machine Name', v1. 'Username', t1.displayname 'Unlicensed Application', t1.installdate 'Install Date'...