The best form in my opnion, is to create a Job to execute every 1 hour, using SSIS (export, import), informing that the table should be initialized, in this case...

The big problem is to avoid locks or bad performance, then the use a snapshot Database for consult and reports web application, I don´t know this is a good solution....

Support for AWE is available only in the Enterprise and Developer editions and only applies to 32-bit operating systems.

Thank's let's me know, it is so good information.

Att,

Ian.

Recompile or SP_RECOMPILE, is the stored procedure that force a recompile of a stored procedure the next time it is run. ok!

Hi, Krishna

I did the migration from DTS Sql Server 2000 to SSIS Sql Server 2005, the protection level is put when you created the file .DTSX, what is the protection...

Hi Mohit, your help, it was so good for me.

Thanks

Ian. 

Hi, Thanks lets me know, but I ´m  looking for this parameter inside DTS package properties. I´m not found it, please, is possible you explain me detail about these parameters. Where...

Hi Andrew, thank you by your attention.   

When I use SP_WHO2 procedure or Activity Monitor, it isn't show me, that database XXXX is using ALLOW_SNAPSHOT_ISOLATION ON, after  have been used...

Sorry, I did this command in query analyzer  in database Northwind for test, but all the columns are nulls, I think that some column...

Please,  Follow this eg. Steps on Enterprise Manager, at database Northwind,  Tables,  you click with right in Desin Table eg, ORDERS table,  show  the...