Npeeters,

My Dad always said, a lifetime almost is a lifetime nothing....

Meaning if it doesn't work vor every situation it actually doesn't work at all.

Well two things.....

1. If that stored proc is slow in the query analyzer as well you can stop looking at .NET........

2. Not smart to execute an already compiled stored procedure...

In my humble opinion this will never work.

Let's say somebody is called "Gert Jan Van den Berg"

In this case hist first name is "Gert Jan" and his last name...

Another easy way of doing this is the following.

1. Click on the DTS JOB and select Schedule

2. Create a schedule ( don't matter because we will disable this later.....)

3. Now...

Yes every time a record is added or updated the timestamp will increase.

So by remembering what the last timestamp was you can very easily check wich columns have been updated

...

Shouldn't you disable something on the webserver ?

If you have basic and NT autentication enabled it will default to BASIC.

So disable basic authentication.

I think this is the way to fix...

This discussion could also be Apple VS Windows

Somebody who is in favor op product A writes an article and people who are in favor of product B comment on them.

From...

I think this is the only option, To write a DTS Package that does it all.

But i remember i saw something on a web page somewhere that did it immeadiately.

but...

Hmmm I know i get three resultsets......

that is why I am having this problem.

Switching to TXT is not an option.

suppose running a script on a production server with thousands of...

Hmmmmmm,

insert 20.000 records in one roundtrip......

doesn't make sense to me. I think that the client doesn't

type those records but it is some kind of resultset i suppose....

Well i would...

No customer is DEMANDING that every sync is killed as soon as refres starts

so i could kill all the spids that are synchronizing.

But how do i find out who is...

I know i can temporarily disable publishing on the server.

Then run the maintenance job and enable publishing, this works.

But the maintenance jobs BCP data out and we need to make...

I think people are messing things up here.....

There is a way to log in to a SQL Server ( SQL login or WA) but there is no reason whatsoever to...

I read the article again, and i still strongly disagree with you. No user whatsoever should have access to a database. So the problem of a user executing a stored...

I do not agree with this article, The way you get access to a SERVER is completely different with permissions INSIDE a datbase.

I did't hear the word Application role at...