Hey... I tried that. 🙂 Doesn't work if F reports to B.

Hi Atif, in many ways I'm still a relative newbie to SQL Server... your example of a recursive CTE is probably an old technique to some of the regulars, but...

DKG (5/6/2009)

---

No i didn't mean that way 🙂

The question just came in my mind was, if a user can do other limited operations (can see the DBs by Ent Manager)...

Steve, I looked at her qualifications and they seem to be: marketing, managing at various IT companies, and an MBA. This would explain the extremely generic and wish-washy advise provided.

Vortex (9/27/2007)

---

Folks,

I have the same problem here, but the solutions provided solved the problem... while running the query on the server.

select * FROM OPENROWSET('ADSDSOObject',

'adsdatasource;', 'SELECT cn, mail,...

It should be maintained after a set period of time. Thank...

Steve Jones - Editor (4/10/2009)

---

azz (4/10/2009)

---

Absolutely agree, that "If you can deliver a well performing, and good looking application, no one cares about the code."

But are there a lot...

Muralidharan Venkatraman (4/1/2009)

---

Please, if you don't have anything else to do, go read some whitepapers.

Don't waste other dba's time.

I spend every day some time to keep learning new stuff and...

Of course, there are issues to deal with here, both in terms of the extra burden snapshot isolation places on tempdb, and the fact that swapping to this mode may...

Back in early 2001 I worked at this place where the new boss's middle initial was a "W". He seemed real proud of it. So did his aides. So I...

If someone finds a way getting a massage from SQL Server, can they let me know? I've been feeling a bit tense...

Funny you should ask. I saw the following article about this the other day:

Getting a clue about your database.[/url]

Best article I've seen in ages on this topic 🙂

Steve Jones - Editor (1/12/2009)

---

XP supports encryption, but it's a CPU cycle issue from what I've read. I haven't tried one, but perhaps enough complaining will get my boss to...

Oh come on Steve! I don't agree with that sentiment. Surely with a Windows XP build you can install VPN software or setup encryption? And if you install a Linux...

Hmmm... it looks fine to me. While that KB article looks like its talking about stuck IO, any of those scenarios in...