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)
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
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.
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.
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.
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: Batch, Cheatsheet, Cmd, Collaboration, Dos, Python, Pywin32, Sqlserver, Ssis, Ssrs, Whiteboard, Win32