Try again, that code works.

Nope, read the previous and do that, we can't help without ALL that info.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Come on kids, kiss and make up. This is supposed to be a professional environement.

daveriya (8/4/2011)

---

hi

the thing is i cannot show my data ,its confidential ,i can show my execution plan,but when i save it comes with query,is there any way i can show...

He's not mixing anything with anything. That's his point of view. Then end.

Well this is a table with 13GB of data in it. I don't know what you call slow, normal and fast, but any index built on this will require...

I already posted the link for the db side of things.

This is for the sp side of things. First line of code should be.

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

I must...

I'm going to have to take a rain check. If you [re]read the article Jeff reffered to you'll realize that we need insert statements and not excel spreadsheets (which...

Finally got him to post ddl and sample data.

Please forward this thread over here : http://www.sqlservercentral.com/Forums/Topic1153535-149-1.aspx

I'm out for now (tired, nothing against anyone).

So you're all...

Yup, I wrote one back 7 years ago with other objects but I don't remember the field names too well. It's not hard to do, just a little trial...

sunshine-587009 (8/3/2011)

---

WE dont want to give them sa because they have the ability to cvhange configurations and passwords to logins. Microsoft created this credential/proxy security. I'm assuming it has to...

Now we understand the avatar. A couple like this one will do that to ya ;-).

Thanx for the update.

So do you still need help with this.