Experts,

Reviving this discussion after quite sometime. Per manangement we want to go for a pure DR solution now. So i am considering the option of either going for Log Shipping...

I just edited my post which probably would have gone unnoticed, i am adding that here again:-

The Stored Procedure hangs indefinitely at the UPDATE statement.

Just to re-iterate, all i did...

Forgot to mention one important thing:-

The execution of the stored procedure hungs at the UPDATE statement for the entire duration.

--Staging table script:

CREATE TABLE [dbo].[TokenUsageStatistics](

[ReportDate] [datetime] NULL,

[DiscDescription] [varchar](100) NULL,

[StreetDate] [datetime] NULL,

[TokensUsedInLast24Hours]...

Use Red Gate SQL Prompt tool. Its a nice tool and inexpensive as well. It will also do the formatting of the SQL Code. It's available for free trial for...

Hi,

By giving EXEC permissions on the Stored procedure the DML statements would execute. You need not give update permissions to the table explicitly with the exception that if your table...

Thanks Jason. Good pointers.

Call the Send Mail Task as a second step of the SQL Job, on success of step 1 go to step 2.

Amol

Did you check execution plans to see the data access is efficient. Make sure you are not doing scans or bookmark/key lookups on the table.

It also depends on how much...

Thanks David for the response. Now with that i am going to go back to the management and let them know about the potential data integrity issues that we might...

Nikhil,

Did you try viewing the Query Execution plan? Perhaps there is a scan or bookmark/key lookups happening on the indexes. Try to convert these to Index seeks by using covered...

I have used both ERWin and Embarcadero ERStudio. I currently use ERStudio and I feel it offers a lot as compared to ERWin. One feature that i liked is it...

Hi,

I am also in the process of designing a second colo database. That means we are going to use merge replication for colo 1 and colo 2 databases in order...

You need to use the Business Intelligence Development Studio for creating SSIS Packages. This comes along with SQL Server 2005. You need to create a SSIS Solution and then start...

Hi,

I had a similar requirement. Basically i had to email the statistics every morning to users.

I used SSIS to accomplish this as follows:

1) By using a FOR XML clause i...

Thanks for your replies guys.

Mike,

Are you referring to the commit size in the OLE DB Destination component within a Data Flow? How big or small should be this size if...