If u post select scripts too with index details that will be more helpful to see what happened and why.

Hi Alan,

insert into lookuptable

select * from lookuptable1

where raw_sw_manufacturer not in (select raw_sw_manufacturer from lookuptable ) and

raw_product_name not in (select raw_product_name from lookuptable ) and

raw_product_version not in (select...

tony28 (5/7/2013)

---

Hello,

i have maybe stupid question

why sometimes the SELECT use Noncluster index instead cluster index

I thought that still use PK like primary, if there is value what I...

GilaMonster (5/6/2013)

---

suneet.mlvy (5/6/2013)

---

Thanks for the response, now I understand the timeout concept, but can u explain me how sql server kill sleeped session is there any setting available to kill...

Are u sure there is no DB or schema connected to that user.

plz try this.

Use [Master]

select name, default_database_name from sys.sql_logins

go

Use [User_name]

select * from sys.user_token

If you already in administrator group then just login using windows authentication, Create new user with admin rights and login through that login.

Using new login u also can chaneg password...

Matan_Yungman (5/6/2013)

---

I'm not sure what you mean when you say "ideal", but the default is 600 and most of the times it is left that way.

About the 3 sessions, do...

Thanks for the response, now I understand the timeout concept, but can u explain me how sql server kill sleeped session is there any setting available to kill them in...

Hi,

Thanks for responce.

Is there any settings in sql server to set timeout for ideal process.

and i have one more doubt i had run single query on one table why it...

You can use any third party tool to decrypet encrypted procedure

select b.name from sys.syscomments a join sys.objects b

on a.id=b.object_id and a.text <> '' and b.type_desc in ( 'SQL_STORED_PROCEDURE','SQL_SCALAR_FUNCTION')