Hi

Thanks so much, I will start testing it and see what it does exactly, and how it fits on our tables. I will get back asap to let you...

I will try that with a trace, we have looked at using top, but it has not been very effective. The only difference between the two is one gets copied...

This is the cursor specifically where I picked up the problem

DECLARE @object_id INT

DECLARE @table_name VARCHAR(128)

DECLARE @col_name VARCHAR(128)

DECLARE @exec_sql_string VARCHAR(500)

DECLARE @exec_sql NVARCHAR(500)

DECLARE @max_id NVARCHAR(4000)

DECLARE @OutputParameter NVARCHAR(4000)

DECLARE @id_count NUMERIC(38, 0)

DECLARE @id_count_to NUMERIC(38,...

Thanks I will have a look at what you said, check the settings etc.

The cursors we use look for a table table and field name, and for example if...

Maybe I am being a bit slow, but explain to me exactly how to compare the two.

I would also like to find out why everyone is saying do not use...

It runs faster on SSMS than on SSIS, I need to get the performance of SSIS up, and I am not sure why the scripts runs about 4 times faster...

Not seeing it, am using Visual Studio 201 BI development, am getting to options but not seeing the rest there

John, thanks for the reply

First of all the cursor seems to be the only way, we are updating/deleting records where rowcounts are in the 100 of millions or early billions,...

Thanks to both of the options, I think this is the route I will take, will try both of them and see which one works best for me

Koen

How exactly would you do that?

Hi

I am not sure what the exact limit it, test it by copying and pasting scripts, then it cuts off at some point. Not sure if the limit has been...

For now it seems the solution is to create a Cursor which updates the user profile. Please, if there is some other way, respond. Here is the code I used.

DECLARE...

Just some info, the issue is that I need to grant Alter permission to sequences, at this stage it looks like the only way is to grant alter on each...

The suggestion works, only one concern I have is that we need to at minimum create a user on the database even though it does not have rights on the...

Thanks, will test this tomorrow, looks from what I saw in that article that it could be the ownership of the DB's. Will respond tomorrow then.

One question though on...