Please can we see your stored procedure definition?

Thanks

John

Gail, reading between the lines, I think what the senior DBA is saying is that if you insert data that is already sorted in the order of the clustered index...

Jeff

Unfortunately I don't. One of my colleagues has written a sophisticated application for use in house. It collects data from servers about all sorts of stuff - file...

Ryan

But how do you want to limit it? First 30 characters? Last 30 characters? Remove all vowels? If you want the first 30 characters, use the...

Ryan

That all depends on your requirements. Here's one way (not tested):

...

LEFT(COALESCE(PROP.postcode + N'/','') + PROP.address ,30)

...

John

Bhuvnesh

What I meant is that you should use an ORDER BY when SELECTing, not when INSERTing. So instead of this:

-- INSERT data into destination table

insert into email_destination_bk

select ut_stub,acct_id...

This method is only useful if the table was created recently enough for the default trace to...

Bhuvnesh

I'm not sure what you're asking, but in any case, why would you use an ORDER BY in a SELECT statement for an INSERT? This doesn't guarantee that the...

Bhuvnesh

If you specify the column to order by by name instead of ordinal position then you get your concatenation.

John

I think your only realistic option is to get on to the client PC and find out what it's running. I'd have thought that a developer might have some...

Only if you are happy for this user/PC/application to be connecting to your database. As Pradeep suggests, use...

Client xx.xx.xx.xx is still trying to connect to your server, even though you've deleted the login it's trying to use. Find out what application is running on that client...

Raghavender

Please will you describe what you're trying to do? It looks as if you want to display the server name and instance name without the separating backslash. To...

I'm finding this difficult to visualise. Please will you provide table DDL, sample data and what you have tried so far so that we can picture it more easily.

Thanks

John

I would say so, yes, otherwise you will need to change your code every time your exclusion list changes.

John