I searched in the rdl file and cannot find any dataset in there. Might be because we always use stored procedures?

Where would I go to re-link the dataset?

I have a very similar problem. We have many developpers that are coding stored procedures to be used in Reporting Services. I want them to be able to create/alter/drop procedures...

After testing it, I can confirm that it does indeed stop logging both in the SQL Server Log and Windows Event Log.

Since my backup is scripted with outputs, I'll probably...

Thanks, this is a nice tip but want I would really want is to log into the SQL Server Log without logging in the Windows Application Event Log.

Is that possible?

Thank you for your reply. I've searched a little on the web but found nothing about that problem.

We have decided to create a view and informed the users of the...

It's important to note that for some settings, like "ANSI_NULL_DEFAULT" and "ANSI_NULLS", the ole db connection overrides the database settings:

"[...] Connection-level settings (set using the SET statement) override the default...

At the end of my first post, you can see the differences. The output is missing the name of the indexes on which it updated the statistics. It actually does...

Well, both scripts run fine. It's just the output that's missing text.

That is a strange issue. I might open a case with Microsoft.

Well, after some testing, I found that all lines begining with spaces get trimmed on the left and all lines begining with a quotations get the quote truncated as well.

This...

Thanks for the heads up on the QUOTENAME and context.

I have change my code to this and still, the ouput is still missing the name of the indexes:

PRINT 'sp_updatestats results...

Sweet, exactly what I was looking for.

Thanks!

I'm looking for a script that would grab the logins and associated server roles, database users and associated databases roles and their permissions. Anyone already did something like that?