Viewing 8 posts - 436 through 443 (of 443 total)
I'm assuming you want to run a .cmd or .bat script (or something similar).
If so then you can use xp_cmdshell, something like this:
declare @cmd varchar(100)
set @cmd='c:\bin\test.cmd ' + select something from...
August 31, 2005 at 3:40 am
Look carefully! It's not quite the same as Monday's QOD
August 25, 2005 at 7:47 am
The Language setting is in the Misc. section of the Report properties.
August 24, 2005 at 6:27 am
Use the RowNumber function in the expression for the city ie.
=RowNumber("<put your group name here>") & "." & Fields!city.value
August 24, 2005 at 2:07 am
ReportingServices installs a service called 'ReportServer', it is this that polls the event table, and actually runs your job.
The Report Server logs you need to check for errors are in:
August 17, 2005 at 4:48 am
I think the problem is in the final two statements
select @sqlstring = 'Current table ...'
exec sp_executesql @sqlstring
you're trying to run invalid SQL ie The statement 'Current table ...'.
I'm pretty sure...
August 11, 2005 at 3:49 am
As Greg mentioned the DateTime class (actually System.DateTime) is part of the .NET framework, and is documented here:
July 7, 2005 at 3:50 am
The solution is extra double quotes to quote the quotes:
... -Q"sp_msforeachdb @command1="""print '?'""""
Thats single quotes around the question mark, 3 double quotes before the print command and 4 (yes...
July 5, 2005 at 2:42 am
Viewing 8 posts - 436 through 443 (of 443 total)