Viewing 15 posts - 14,746 through 14,760 (of 19,560 total)
Ouch. I think that is the sort of thing that I was seeing. Machine dependency with all of those solutions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 6:26 pm
bitbucket-25253 (4/16/2010)
Aha, got it to work (Server 2000).
Pray tell Jason, what is this seemling unquenchable thirst for SP_Who ....
whatcha going to do with it?
Well, I am trying to document...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 6:11 pm
Express Edition has always been labelled as Server 200x Express since inception in 2005 (SQL Server 2005 Express Edition).
Prior to that it was MSDE.
I believe whoever told you that there...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 5:59 pm
WayneS (4/16/2010)
CirquedeSQLeil (4/16/2010)
Wayne - I like your new avatar.
Thanks. I was thinking about using this one (about 1/2 way down the page), but I figured that Steve would ask me...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 5:55 pm
Aha, got it to work (Server 2000).
Here is the SQL 6.5 version
if exists (select * from sysobjects where id = object_id('dbo.sp_who2') and sysstat & 0xf = 4)
drop procedure dbo.sp_who2
GO
CREATE PROCEDURE...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 5:50 pm
Those are one and the same.
SQL 2008 Express is SQL Server 2008 Express edition.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 5:34 pm
Steve Jones - Editor (4/16/2010)
Where's the reference for it? I don't think...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 5:05 pm
bitbucket-25253 (4/16/2010)
CirquedeSQLeil (4/16/2010)
Ok - this one is a stretch. Anybody have sp_who2 from sql 6.5?Heck Jason even this old timer does NOT save stuff that old.... Yikes
Haha - funny...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 4:50 pm
Steve Jones - Editor (4/16/2010)
sp_who2 didn't exist in SQL 6.5😉
It was sp_who. When they went to 7 or 2000, they kept sp_who and added sp_who2
It was undocumented in 6.5...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 4:48 pm
Ditto as the other two, just adding that the final Primary in your definition refers to the filegroup on which the clustered index was created.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 4:47 pm
Ok - this one is a stretch. Anybody have sp_who2 from sql 6.5?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 4:32 pm
bitbucket-25253 (4/16/2010)
CREATE PROCEDURE sp_who2 --- 1995/11/03 10:16
@loginame sysname = NULL
as
set nocount on
declare
@retcode ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 4:07 pm
Lynn Pettis (4/16/2010)
CirquedeSQLeil (4/16/2010)
If so, can you verify for me if ANSI_NULLS is off in sp_who2 on your server?
I believe it would be since...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 3:31 pm
Lynn Pettis (4/16/2010)
Jeff Moden (4/16/2010)
dma-669038 (4/16/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 3:22 pm
Jeff Moden (4/16/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 3:20 pm
Viewing 15 posts - 14,746 through 14,760 (of 19,560 total)