Whenever you put a field in a group level that is not part of the grouping you need to use an aggregate and by default SSRS uses FIRST() for non-numeric...

Can you post the EXACT error message you are getting? There should be one in the event log and/or the SQL Server error log.

Can you provide an example of what you want to do with the CAST? I would venture to say that you can do it, but I'm not sure what...

If you only want to audit access to 1 table you could apply filters on DatabaseId and ObjectId.

I don't know anything about RSA EnVision, but I would assume you could...

I don't think there is a way to do that because the mail is successfully sent by the mail server which then receives an undeliverable message in return.

I believe that using the 4 part naming syntax executes the functions on the local server. You should use OPENQUERY().

I'd suggest using the .doc/.ppt/.xls formats instead of .docx/.pptx/.xlsx that came out with Office 2003 believe. There are a lot of Office 2000 and XP installs out there, especially...

What are CommentsConv and Comments? Are you attempting to do this all in one derived column transform?

Why not do one derived column transform to DT_WSTR and then a second...

I doubt that a global temporary table will make a difference as scope is not the problem. Why are you using dynamic SQL to execute the OPENQUERY statement? ...

Your destination table will not accept a null value, that's what NOT NULL means in a table definition. So if you explicitly try to insert a NULL value then...

Paul White (8/4/2009)

---

So...today's SSC newsletter - entitled {title} - features Gain Space Using XML Data

You can all relax in the knowledge that everything will be smaller and faster if we...

Why are you using the JET provider when there is a FoxPro OLE DB driver? This could be your problem.

rustroot1,

Don't know where you are in the Northeast, but Adam Machanic and his user group put on a PASS Community Connections event in the Boston area last January. It...

Are you changing anything in the database schema or just "copying" the tables and data to SQL Server? It should be fairly straitforward if you are copying the Foxpro...

Another one from the same guy. Not sure what he wants and asking the right questions is not my gift.