I apologize, but I've never heard of the nested update statement before. I ran it through Google and BOL. I'm not seeing it anywhere.

System catalog view:

SELECT * FROM sys.servers

It's one of the properties, is_rpc_out_enabled.

Look up the EXECUTE statement in BOL:

EXECUTE ('USE STUFF;DROP INDEX OWNER_idx ON dbo.OWNER')

AT SQLnk

The linked server has to support RPC calls:

EXEC master.dbo.sp_serveroption @server=N'SQLnk', @optname=N'rpc', @optvalue=N'true'

Oh, and, Warren Peace: SKY HIGH...

You can use IS_MEMBER() to determine the current users inclusion in a particular group. There are also a series of dynamic management views (DMV) that access security. Try sys.database_role_members and...

I'd heard C++ too. I don't recall the source though.

The error logs are just text files. You should be able to simply open them in a text editor, completely seperate from SSMS.

And since this is 2005, the sqlcmd command line utility as well.

I wish I had real wit, but all I can come up with is "Hey, Steve, you've got a groupie."

Seriously though Sandy, you left out Gail Shaw, NinjaRGR and a...

You've got perfect programmers too? Wow. Small world.

Seriously though, sounds like you're on the right track.

John Aherne (10/15/2007)

---

wow. I have been an informal dba (i.e. the only person willing to look into it) since SQL 6.5 but I cannot answer any of those questions. I...

Steve Jones - Editor (10/15/2007)

---

Some very interesting comments and thanks for the debate.

However I think Matt made a great observation. Be careful about moving to a new employer because the...

Jack Corbett (10/15/2007)

---

and what's a bookmark lookup?".

[/quote-0]

I have to admit to not being confident on this one. I would define it by saying it occurs when SQL uses...

Maybe it's Rhode Island? But we ask these questions:

What's the difference between clustered & non-clustered index

What's the difference between blocks and deadlocks

What kind of recovery models does a database have...

I've been involved with hiring DBA's where I work for the last three years. It's been a frightful experience. We eliminate most candidates in a ten minute phone call. While...

I went through a period of swapping jobs quite a lot. It was those damned dot coms. Funny thing was, I took a pay cut each time I jumped because...