The permission is specific to object you are selecting grant on. If I have a table users and I am Granting ALTER to that table to user1 then user1...

Use a For Each Loop Container to iterate over the rows in your variable and put the Send Mail Task into the For Each Loop. In the Execute SQL...

If you are really using SQL Server 2005 and you set the service account to a domain account during setup then the setup handles setting the necessary permissions.

If you changed...

I would cluster on the Identity column which will help with the MAX and the filter on the max. And depending on the the other queries affecting this table...

I think this is what you are looking for, keeping in mind my other comments:

[font="Courier New"]CREATE PROCEDURE OrderID

    @StartDate DATETIME,

    @EndDate DATETIME,

    @OrderID NVARCHAR (40) = NULL,

    @CustomerId NVARCHAR(40) = NULL,

    @ICPAuditID NVARCHAR(40) = NULL

AS

SELECT                

    T_OrderHeader.OrderID,

    T_OrderHeader.CustomerID,

    T_OrderHeader.ShipCountry,...

You need to specify what you granting ALTER to like:

Grant Alter On schema::dbo TO user/role, etc...

This is new because SQL Server 2005 has changed syntax for users, roles, etc... to...

I know what you mean. I did use the ODBC driver back in DTS days and have used the .NET driver in an ASP.NET web service. They work...

I don't believe that this is possible. The subreport uses the page settings of the master report. It would be a nice feature and I wanted it back...

First of all the code you posted only has one parameter defined and you reference 5 in the query so where are they coming from?

Here are a few things to...

Sure you can transfer data between AS400 and SQL Server using SSIS without HIS. You can use the ODBC or OLEDB provider provided by IBM or another provider to...

a.thomson2 (7/25/2008)

---

Just to confirm then, when the 3rd party app writes the data back to this table, hen the trigger fires and changes the last column to Null from what...

This is in addition to what GSquared and tertiusdp said. Although since the id field is character you can't convert it to an Identity column without changing the data type...

khushbu.kumar (7/24/2008)

---

The space available on disk is in GB and RAM is 2GB.

The process doesn't need to be killed at back end but from task manager or closing the application...

Chris Morris (7/25/2008)

---

The recommended method which Jack posted (where are ya, Jack?) will always run fast because the column in the WHERE clause on which it operates isn't subjected to...

Can you attach the rdl file to the thread so I can see how you are trying to do the report? Are you sure your report data source is...