my google-fu pointed me to an issue where SQL server Agent needs to be restarted, based on this MS article?

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/32a2c09a-156f-43b2-9076-b11ba9ccdafb/

do you think that could be the issue? that db mail...

mohan.pariveda 18256 (6/1/2011)

---

Thanks for the reply. According to your reply if i am not wrong, all my sessions need to show in negative times but it is not.

Only...

nope. a foreign key must...

don't just re-paste the same question...that doesn't help at all.

two tables can be JOINed via a SQL statement, and that join is not restricted at all...it can join on...

patla4u (6/1/2011)

---

I am sorry ,,,,but I want to create relationship with two tables.

Means composite primary key to composite foreign key ????(it's not working)

SO how can i create relationship with table...

unless you alias the table, you must use the whole 3 part naming convention(Database.Schema.Table.ColumnName) toi identify the columns in the joins:

here's the right way, and then again with aliases for...

dunno about most folks; since it's on by default, and it's a low impact trace, i'm under the impression most people don't actively go and disable it;

I personally think there...

you can join the two tables on two of the three criteria, but you can potentially get duplicates due to the third column

unless you assume/infer a specific customer_br?

...

LEFT OUTER JOIN...

nice link!

char(44) is a comma, is that your special character?

this statement in syntactically correct:

--the char

select char(44)

--an example

select 'the severity level of the patient or resident' + char(44) + 'injury'

INSERT INTO [dbo].[Events]

([ID]

,...

if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:

ok, an update to random is certainly possible... you were really thin on the actual firstname/lastname table definitions, so i cannot provide you with a perfect example...

but, based on your...

dbcc timewarp? (inside joke)

actually, i think the issue is the times are cumulative, and are since the server restarted...

so it's quite possible if your server is active, or has been...

this will be boatloads faster and is a single set based query, instead of using a cu..cur... i can't even say the word...it's so evil....

SELECT top 1000 *

FROM (

SELECT

A.FName,

B.LName

FROM FNAMES...

they way i would recommend is by using the script i contributed in this article:

Reverse Engineer A Database Trace[/url]

first find all the traces on your server with SELECT * FROM...