I have finally got two stored procedures sp1 and sp2 which return results.
1- sp1 returns a dataset like:
period Gross Net return...
The stored procedure returns fields i.e. field1, field2, etc...
field1 has figures in percentages such as:
3.65, -1.22, 1.3, etc...
field2 has the...
I have created a chart in ssrs 2008 report.
The x-axis shows dates i.e. 30 jun 2010, etc...
The dataset returns 18 records and each record has a...
Solved by using the correct user in sql server logins.
I have now done this:
go to the property tab and create a new group with name
And in the role assignment tick browser role
I have put my web project (which uses reporting services) into the web server for testing.
All works fine on th elocal machine but on the...
I am running a stored procedure (sp) in the Data tab so that I can create a dataSet. of the reporting services 2005.
This dataset returns too...
There are thousand of records in tblMain and I am showing a few of those below...
There are many records which are identical except for their...
sorry, incorrect post
I am running this query from my database.
set @Packagename = 'JobName'
EXEC msdb..sp_start_job @job_name =...
Thanks for now.
I changed the log as for SQL Server Agent from "Local System" to my local login and the job worked.
Is it ok to leave the log on as my login...
How do I find the login details?
I am trying to change the User name under which my created job is run under.
i.e. in the General properties of the Step of the Job it shows...
I do use the full UNC path.
The owner of the job shows "domainmyusername".
In the job step properties under Run as: it shows "SQL...
I checked the properties of the Job.
In the owner section under General page, it shows "domainmyusername"
In the job step...
yes because it is using my account
My package uses the UNC i.e. the full path in the foreach loop container which works fine.
When scheduling this package as a job, it seems that...
USing the script task I can get the name of the file being processed and pass it on to a variable.
How is it possible to start a...
Separate names with a comma.