ALZDBA (3/17/2008)

---

btw: I've noticed that when you receive at website timeout for the reply, hitting the "back" button may also recouver your typed content, so it may be worth the...

There is a SQL Server 2008 forum where you might get a better answer for that part of your question.

As for SQL2005, although it is easy to do from SMO,...

Take a look at the Profiler, under Tools in Enterprise Manager.

Jeff Moden (3/16/2008)

---

Thanks, Matt... that'll teach me... I normally do a lot more research and "due diligence" before I post an article. I got in a hurry this time...

Does anyone know if this works for SQL2005 and the [font="System"]sys[/font] schema?

Thanks! I've added it to my favorites too.

That'll definitely improve my GPA. 😉

Seriously though, I don't mind the initial stuff. Everybody needs good examples to get started.

Matt Miller (3/16/2008)

---

I love reading standards. Theory, especially when backed up with actual real-life appications and scenarios the theory is supposed to address, is very useful. I just have...

Thanks!

yxl1108 (3/16/2008)

---

My original understanding is for best performance, one should put data (with clustered index) seperate from nonclustered index, so in my environment, I have the two in different file...

I think that you want the events SQL:BatchCompleted and RPC:completed.

and then make sure that StartTime and EndTime columns as selected.

Glad I could help.

Try this:

Select * From borrow Where borrow_date < DateAdd(dd, -10, GetDate() )

I used vb6 just fine with Sql2000. I would think that you could get it to work acceptably with Sql2005.

Hmm, I tried to swear off "ranting" some years ago, but that doesn't seem to be working out so well... Sorry.

Anyway, for those who may actually be interested in what...