I can tell you that PASS now supports non-PASS branded events. The person to talk to at HQ is Blythe Morrow, she's the community coordinator. There's been discussion around this...

Thanks for clarifying that for me.

Garadin (10/3/2008)

I personally...

Typically I...

In order to do what you're describing, you'll have to use sp_executesql to execute your statement at run time. You might run into binding issues using a function that...

Are you saying that results may vary? If so, are there any rules of thumb for determining UDF's use? Or do I just need to try the stored procedure using...

UDFs, in the same way as sprocs, reduce the compilation cost in T-SQL by caching the execution plan and saving them for repeated executions. You take a performance hit...

Thank you! While I haven't tested this at work, I re-created the same situation at home using multiple databases and was not able to EXEC any stored procedures until...

I have not. Do you mean that I should set the TRUSTWORTHY option? That is the only thing I...

I'm clearly not understanding something with ownership chaining.

I have created a database login, Processor, and given processor data_reader and data_writer permissions to both my datamart and web databases.

I then created...

From BOL:

So, the...

In this case, dbo owns both databases...

A co-worker recently ran into a similar issue with parameter sniffing. The solution he came up with was to copy his input parameters into local variables inside the procedure...