To follow up on Gary's comment, go to the Index tab of SQL BOL and type in "accounts, services accounts" in the search field.  Then choose the article entitled "Setting...

The following query returns NULL if you are connected to a default instance; otherwise, it returns the instance name:

SELECT ServerProperty('InstanceName')

Easy, huh?

Cheers,

Chris

Well, I think the answer to this one is easy enough to get - though I'm sure some will come up with some complaints as usual - but did anybody...

> Hopefully this is Enterprise Edition ...

... or else that failover cluster might not work too well, either, eh?

Sorry, Frank.     You know ... I've...

Gotcha.  Yeah, that makes more sense.  And I guess I was missing something (half your post) after all!  But I had to ask.  I just looked at the post and...

Phil,

There's something wrong with the formatting in your query - a smilie snuck in. 

But having said that, the rest of what I'm going to...

> The dba to server ratio for Oracle is also lower compared to SQL Server.

That's an interesting thought, but I wonder what everybody else's experience is.  Combining data...

Dinesh is right.  I assumed you had a bigger requirement than that - such as a need to audit historical connections.  In that case, it would make sense to dump sp_who...

Here's one way:

if exists (select * from tempdb..sysobjects where id = object_id('tempdb..#t_sp_who_output'))

   drop table #t_sp_who_output

go

CREATE TABLE #t_sp_who_output (

 [spid] [smallint] ,

 [ecid] [smallint] ,

 [status] [nchar] (30) ...

Very good - I'm glad you got it figured out!

Chris

The tragedy seems to be an inherent handicap in the partitions itself. When using the single unified table, with SaleDate as the leading column in the clustered index, it just...

-- >>>>>>>>>>>>>>>>>>>>> Statistics with "Unified" Table <<<<<<<<<<<<<<<<<<<<<<<<<<<<

-- Table 'Stores'. Scan count 108, logical reads 210, physical reads 3, read-ahead reads 0.

-- Table 'Cost'. Scan count 1, logical reads 437, physical...

Scott,

Can you post DDL for ... hmm ... the stProc_GetCustomerInfo proc, plus all the tables involved (tables affected by both the insert and the proc)?  Or would that be gobs...

NMoore said something about the Java GUIs for Oracle being a little sluggish.  I agree!  I actually think that the DBA Studio is a nice interface (especially compared to what they...

Hi noeld,

I was referring more to the user named mssql_rules, actually.  Maybe I've gotten my users crossed up someplace...

Anyway, as a sidebar:  I believe there is an attitude in the...