Hi George,

I will take a look in the errorlog.... and let you know.

I try to get our IT-Department to switch AWE on... when we have the next maintenance window... As...

Hi,

thanks for the reply.... mmh... that means it can not be done. :crying:

So, there is no way to get the 32bit SQL-Server to use more then 4GB of memory on...

Thanks for your answer, :Wow: I will try it right away.

Regards,

MrAkki

Hi,

I just wanted to say, that this is a great discussion.... 🙂

I learned a lot... thanks....:Wow:

Nice article. 🙂

Another way would be:

DECLARE @Start BIGINT, @Step BIGINT, @max-2 BIGINT

SELECT @Start = 1, @Step = 10 , @max-2 = 10000000

...

Here is another solution without using loops....

INSERT INTO #util_nums

SELECT TOP 1000000 ROW_NUMBER() OVER (ORDER BY a.[object_id])

FROM sys.columns a

CROSS JOIN sys.columns b

GO

Thanks, for your help.

I get your point. I guess I'm gonna put the error handling completely into the database.

Thanks.

🙂

So there is no way to do this in a SP? :unsure:

The Problem is, that I do not have all the info in the client. I wanted to create a...

Thanks for your answer.

The problem is, that the Rollback is initiated by the Client and not in the StoredProcedure....

So I was wondering if I can log the errors to a...

Hi,

I had the same problem with some SPs. The problem was, that I used a variable (it was a parameter of the SP) directly in the select statement in a...

As I know, thats not possible.

1000 seems a bit to high. Try a lower value...

By the way, set the QueryTimeout to a very high value....

(MTU-Settings Maximum-Transfer-Unit is a windows setting)...

You have to change the settings in Merge_agent.

Try playing around with:

- ChangesPerHistory - Try setting this to an higher value like 300 (that cuts down the overhead)

- DownloadGenerationsPerBatch Set...

Hi,

I'm wondering, too. I just got me the new book "Self paced training kit" for 70-442. I think 70-441 is not available, yet.

Does any one know if I can take...

Hi,

I just figured out the right link to the english KB:

http://support.microsoft.com/kb/933508/en-us

I have to put an "/en-us" at the end of the...

Thanks a lot....

Now, I understand what Microsoft tried to say...

Yes...