That too.. but with so little data, it's hard to come up with a garanteed right answer...

It might be good, but then again the OP might need something else.

1 cool thing that can happen for you :

Write all you warnings, recommendations and consequences if not followed. Send to your boss and CC a couple of his...

Alright... then a thread delete notification to e-mail would be nice.

Also we get the...

Was that what you were looking for?

... and what's the value for a transexual or people with both sexes?

I'm really asking, just wondering if they covered all bases.

You're giving up already????

My solution will work, you just need to figure out a way to make a permanent connection to the server without tying up someone or a computer...

Hey Steve another one that I requested before and it popped up again...

try going to that tread...

http://www.sqlservercentral.com/Forums/FindPost662201.aspx

I have no idea where this is and how to get there to help...

create temp table that matches the definition of sp_who2

insert into #temp (columns list) exec sp_who2

then read on cursors in BOL for exact cursor syntax.

You can make a script like this and start it... then just forget about it :

while 0 = 0

begin

Delete FROM...

waitfor delay '00:20:00'

end

I don't know any way to keep...

management studio >

Open your server >

SQL server Agent >

jobs >

Right click for all your options

Make a job and schedule it to run every 20 minutes.

Then in the job, simply do a

Delete FROM Orders WHERE datediff... >= 20

Search for datediff in bols for exact...

Yes, put a dropdown down in whatever application you are building to enter that data.

If it's ssms or QA, then forget about it as it's not possible.

Just go to mcrosoft download and type sql advisor, you'll get the most recent version both for 2005 and 2008.

Yup it is... and I bet it's going to hit 6000 posts even before you do! :w00t:

Ninja's_RGR'us (2/21/2009)

---

Ditto for the search... arhem "function". (I actually had to use the IE search function to even find it on the site, but that's another story).

For all who...