Ids could be deleted so they won't match from random generated numbers, I need something like existing Ids only to be shuffled.

Tried following and it only uses the random number...

Can you please let me know how can I test it and share the stats? then we can decided if it is feasible to go ahead?

Shamshad

As mentioned, rows could be added from auto increment onward.

1

2

3

4

9223372036854775807

reseed to 5

then it will start adding

5

6

7

As it is one time addition of this large number in PK due to...

I have resolved this by following:

1- Open SSMS Connect (LocalDB)\MapToolKit using my windows user credentials

2- Connected to database Server and listed the databases

3- Took a backup using SSMS and...

There is no error, when providing .bak file to SSMS to restore it, it does not load backup file details. we can't move further.

Around 30 tables do not show checksum value for given tables. Kindly let me know what would be the cause that checksum is null for those tables?

Shamshad

On the first step the checksum results were different, even there is no change in tables (100%) similar tables have given me different checksum values, that would be a base...

Tried given solution and put some efforts, it seems typical and can't help me. Still looking forward on my problem I requested here.

Can you please short list this? Can you recommend anyone out of your given list?

Sorry for asking this, as I wanted to get the idea from those who used it...

The list you mentioned is sorted by best one on top or it is mixed?

Thanks Gila. Further to this one, what about the column sequence matters then while creating indexes?

a) (MasterId, ID) OR (ID, MasterID)

b) (MasterId asc, ID asc) or combination of this with...

We had same issue with few users, where their network DNS entries were obsolete due to which those clients were unable to connect via SQL Server via windows authentication. After...

We had same issue with few users, where their network DNS entries were obsolete due to which those clients were unable to connect via SQL Server via windows authentication. After...

We had same issue with few users, where their network DNS entries were obsolete due to which those clients were unable to connect via SQL Server via windows authentication. After...

We had same issue with few users, where their network DNS entries were obsolete due to which those clients were unable to connect via SQL Server via windows authentication. After...