Showing posts with label direct. Show all posts
Showing posts with label direct. Show all posts

Wednesday, March 7, 2012

Application Roles and Bulk Insert

Is it possible to grant a user access to Bulk Insert via an Application Role
?
I have a situation where I dont want to grant users direct access to any
tables, but there is one table that they will need to do a bulk insert into.
I cant see anywhere that you can assign an approle as part of bulkadmin.
Any ideas of how to do this would be appreciated. Thanks.I don't believe you can use "Application roles" for this, but you can assign
"Bulk Insert Administrator" Server Role to any individual Server Login...
Under SQL Server Login Properties, Server Roles, one of the Server Roles is
Bulk insert Administrator.
"Jace" wrote:

> Is it possible to grant a user access to Bulk Insert via an Application Ro
le?
> I have a situation where I dont want to grant users direct access to any
> tables, but there is one table that they will need to do a bulk insert int
o.
> I cant see anywhere that you can assign an approle as part of bulkadmin.
> Any ideas of how to do this would be appreciated. Thanks.

Saturday, February 25, 2012

Application Interface

I would like to call reports from a Delphi 7.0 Application, and direct the
output to "Print, PDF, Excel or Email".
Any suggestions or articles would be helpful, so as not to reinvent the
wheel.
Thanx in advance,
Greg RowlandTake a look at this BOL topic:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_overview_v1_31pv.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:eDMpNqOaEHA.596@.TK2MSFTNGP11.phx.gbl...
> I would like to call reports from a Delphi 7.0 Application, and direct the
> output to "Print, PDF, Excel or Email".
> Any suggestions or articles would be helpful, so as not to reinvent the
> wheel.
> Thanx in advance,
> Greg Rowland
>

Sunday, February 12, 2012

API Information

Can someone direct me to the APi information that would allow me to retrieve
the "Last Run date" of a report as well as the schedule information that
belongs to that report?>From Reporting Services BOL 2005:
Report.ExecutionTime
Gets the date and time that the report was generated.
Namespace: Microsoft.ReportingServices.ReportRendering
Assembly: Microsoft.ReportingServices.Processing (in
microsoft.reportingservices.processing.dll)
C#
public DateTime ExecutionTime { get; }
Regards,
Thiago Silva