When...

RBarryYoung (7/17/2009)

That's...

Check out codeplex

Interesting result. When I run this, it shows as SQL:StmtCompleted NOT SP:StmtCompleted.

I know you can get this for the Database Engine from system tables, but for SSAS I don't think you can. It can be found in the tracedefinition90.xml. This...

Huh, that is very odd. Both the need to grant permissions and the fact the blog won't display in FF (that's what I use).

Are the objects (views, tables) in...

Is the view in the same schema as the table? If not, then the schemas need to have the same owner. I actually have a blog post about...

Well, it works in FireFox, but it doesn't look good.

Well, I can't really help because I don't know anything about ORACLE. I can suggest that you find an ORACLE forum to post on, although there are some ORACLE...

I wonder if you might be better off breaking it down into some steps using temp tables. You reference the transaction_update table 5 times. Could you get all...

Here's an idea. Report uses AdventureWorks, but you can change it, and it has no formatting. I just set the visibility properties.

Perhaps if you posted all the data so we can run the exact code we might find an anomaly or two in your data.

I'm actually not seeing that behavior. In both cases the 'th' is being replaced. I'm not sure why it is working at all. According to the ASCII...

I have a step in my backup jobs in SQL Server Agent that uses the CMDEXEC job type and does a DOS COPY to copy the file to a network...

While Jeff is likely correct, as usual, what happens if you run the same query in SSMS/Query Analyzer? You will probably get a better error message or might find...