"Instead they cherry pick jobs from networking or standing offers."

I'm still waiting for you to make me an offer steve... and I hope I won't have to sleep with you...

I'm the TSQL guy... ask the transaction guy .

I got nothing for or against it.  No one ever proposed something like that. Maybe...

You can always start a job in the trigger (in another process with an alert or raiserror... don't remember which).  That way there would be no delay besides the execution...

"

I don't believe this so for no one even read this post. No one like Remi is hanging around any more??

"

Was reffering to this... Took only 30 mins to answer...

So now I'm supposed to answer all messages under 10 minutes .

I don't think there's a much better way to do this unless...

Well you don't absolutely have to but I'd suggest that solution to extreme problems only.

Are you able to create the table before running the SP??

If not then why not??

Wow that's usefull.. Are the tables that the view needs created when the view tries to copy?

Is there a syntax error in the view (try to alter it and resave...

Back from retirement Sue???

Unlike many of us, he doesn't have lots of spare time at his work .  It'll be fixed some times today don't worry.

This proves how many of us need to use books online to answer to questions.. maybe that's whta he really wanted to learn

Select CompanyID, SUM(Earnings) as Earnings From dbo.Companys GROUP BY CompanyID

I wish I could help but my experience with IIS in extremely limited and I never encountered that error.

Please check the collation setting at COLUMN level... this is the one that will count. I suspect it hasn't been affected by the alter database statement.

Where did you change the collation setting?

If I remember correctly the only place it could have an effect would be at column level and nowhere else.

First if you want to order something you must use Order by in the select.

Second, check what is the collation of the column in question.. You should see that is...