May 28, 2009 at 1:47 pm
So in the Status columm, what does it mean to have numbers like 22 or 7? Is there a particular dictionary or index of what does codes mean? Thanks.
May 28, 2009 at 1:51 pm
Which table are you talking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:53 pm
dbo.status
May 28, 2009 at 2:01 pm
That's not a SQL system table. Ask the developer or vendor if it's a purchased piece of software
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:09 pm
SQL Server Management Studio.
May 28, 2009 at 2:12 pm
Right-click the table
Script Table as
CREATE to
Clipboard
Paste the results into a reply on this forum. We might be able to help if there's a foreign key on it or something like that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 28, 2009 at 2:20 pm
What's the name of the database in which the table resides? I'm not familiar with any table in the system databases called "status". If it's not in one of the system databases, it's in an application database. You'd have to ask the vendor whaat the codes in that column mean.
May 28, 2009 at 2:55 pm
julioregalado110 (5/28/2009)
So in the Status columm, what does it mean to have numbers like 22 or 7? Is there a particular dictionary or index of what does codes mean? Thanks.
The numbers are the answers to the meaning of life, but one of them is wrong . . . :w00t:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 28, 2009 at 3:54 pm
julioregalado110 (5/28/2009)
So in the Status columm, what does it mean to have numbers like 22 or 7? Is there a particular dictionary or index of what does codes mean? Thanks.
7 is generally better than 22. Call for help immediately if status 31 appears.
*shrug*
May 28, 2009 at 5:07 pm
Are there other columns in the table? Do you know what a foreign key (FK) is? Maybe this is a FK to another table where you can look up what the value means? Otherwise, you'll need to provide a lot more info to get some help. Sorry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 31, 2009 at 9:28 pm
Hey guys, I believe Julio created a new Topic instead of replying in http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx.
May 31, 2009 at 9:32 pm
Julio, as these guys have said, do you know who might have made that table? And do you know how your number may relate to, say the date instead of just the time?
June 1, 2009 at 1:24 am
NathanB (5/31/2009)
Nah. This one and the one you reference were started at the same time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply