Mini Searches with Answers

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Reporting Services – table sum problem : reporting, services, sum
How to add a grand total to a SSRS report to a column that has duplicate values. Write a custom code function to do it. See comments by PFrog. (sorry it's experts exchange)

PyWin32 Documentation
Actual documentation for the PyWin32 package

Do Vultures Eat Vultures?
Do vultures eat dead vultures? The internet doesn't seem to know, but these folks say no.

‘xp_cmdshell’ does not exist??
In order to configure xp_cmdshell, first need to enable the advanced options and then only all the advanced configuration options works out.

It can be done as follows:

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO

Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.

“Access is denied” error message when you run a batch job on a Windows Server 2003-based computer
How to make SSIS call a batch file. I used method 1: Grant the Cmd.exe program Read and Execute permissions for the user account that the batch job runs under.

Method 2 didn't seem to help.

Tags: , , , , , , , , , , ,

Comments are closed.