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.
Showing posts with label direct. Show all posts
Showing posts with label direct. Show all posts
Wednesday, March 7, 2012
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
>
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
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
Subscribe to:
Posts (Atom)