it's still the same issue.

the Print statement thing works because it contains no objects that resolve to database.schema.table.

The first thing the database engine does is map ALL objects in a...

the problem is the engine validates all objects mentioned in a script...regardless of if-then-else logic ; so if it doesn't exist at the moment it validates all objects in...

Tara-1044200 (6/2/2011)

---

is there a way to script out the setup and run the same on a differnt server. I have to create mail setup on mutiple server and its a...

I'm assuming you used my example as a partial model?

my knee jerk reaction was to use EXECUTE AS SELF to avoid permissions issues, and that seems to mask some of...

that won't work...scripting is a DML operation, where it goes out and selects the details for a...

no explanation whatsoever? another repeat of a schema?

if you cannot explain what you want, we cannot explain how to do it. please see my...

wouldn't do any good.

you need to help us help you.

go back to the beginning...we know table1 has a three column PK.

another table has two out of three columns of that...

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...