Does not a

substring( @mystring, charindex( @mystring, ' ') + 1, len(@mystring)

work?

I agree with Tony. SQL Server breaks down the query in views and attempts to build a tree just as if you had embedded the view code in the FROM...

Yahoo did a good job with my draft, the lineup is set, let the domination begin! 😛

I should know in Oct if I can come. I'd like to. Allen is typically my roommate at places like the MVP Summit, so I'd like to go see him...

You'll have to run a trace. AFAIK, without some action, there is no way permissions are changed on objects.

I'm not sure what you mean. It's listed as an Event with an image, it says webinar, and it lists a product name.

This typically occurs when you have a string that overflows the storage size.

Can you post some code?

Ha, we got two new horses this weekend. We have plenty to shovel. I'm sure Alice will be happy to command delegate some chores to you.

Why do you care?

NULL is null, whether the user passes it or not.

Nice advice. That and check the cable/power cord first will help.

Great to hear, and glad it worked.

Partitioned views can work. There is work done in the optimizer so that only the partitions needed are accessed. The keys to making this work, as always, are good I/O...

Did you click the "Manage Connections" in the maint plan editor? There's a "remove" button. (see attached)

Are you perhaps doing a restore of the database?

wenrui_yang (9/9/2010)

---

I still remember an article I read in a class: One man's meat is another man's poison. It also applies to job. In many cases, the same...