It's ok, you can replace sensitive info with something else, the thing is - what traits in your data would indicate to programmed code that 'this is a servername'..?

From the...

imo 'it depends'...

Bottom line is, it's a design choice. Yes, there are issues with allowing nulls where perhaps a default value serves the...

Just to clarify things a bit (or at least attempting to do so )

'*' denotes 'all' or the 'outer table'. Thus:

'*=' is a...

Is there anything in each rows that signifies where the servername starts and ends? (I assume that it's not as the example where it seems to be all the same,...

You could try:

ALTER DATABASE myDb SET RESTRICTED_USER WITH NO_WAIT

/Kenneth

If you're building the table column by column, you should be able to stick in a 'SELECT COL_LENGTH('myTable', 'lastColumn')' to keep tabs on the accumulated table width.

/Kenneth

You're not allowed to use 'select *' with identity_insert, you must explicitly list all columns involved.

insert newTable (identcol, othercol)

select identcol, othercol from oldTable

/Kenneth

Well, the 'simple' answer would be that you can't. It's not the 'proper' way to audit what you want, you should use profiler for this.

/Kenneth

I can see that this leads nowhere, so it's probably as well to end the discussion.

I might suggest that you, dear sir, read the entire posts that you feel inclined...

Well, you've lost me. If you indeed have something to say, just state your mind in clear terms instead of playing around.

/Kenneth

..and you intended to add something useful to the thread...?

/Kenneth

Well, glad your problem is solved.

Just a final word about 'select *'.. Carl (hopefully) used the '*' for demonstration purposes only. You, as coder, should never write any queries that...

I'm sorry, but it's not clear what you want here. You have to be more specific and give us some more details.

/Kenneth

Also, if you want to review the entire rows for analysis that holds the dupe keys, you can do like this:

select *

from  myTable

where dupeValue in

      ( select   dupeValue

        from    ...

Haven't the foggiest really, since I don't use fulltext services I can't say I'm particularly versed in it's do's and dont's..

However, here's a generic description of a method to count...