Can replication be used?

I am working on an old project, which is using 10 digit string for tracking credit card transactions. But problem with the old code is that sometimes it generates duplicate...

I want it for storing transaction no.

I think it will be better to check in database for uniqueness.

Thanks.

But if I take only 10 characters of string generated using newid() like this:

select CONVERT(varchar(10), right(newid(),10))

still will it generate unique string?

Hi

So, newid() function only generates random no.

Will I have to check for its uniqueness?

Hi

Thanks. This looks much simpler.

But will it generate unique string for a table?

Hi

Thanks for your solution

I need to generate a random 10 digit alphanumeric string that is also unique within a table.

Hi

Is there any way to do this?

I am not changing the datatype of column.

It was previously ntext and now also it is going to be ntext.

What I am changing is the insert query for this...

Thanks a lot !

-Abhijeet

Hi

I killed that process successfully.

Before that process was running for 1 hr.

Will it take same time for rollback?

How to make sure that rollback is finished or going on?

Thanks alot.

Thats what I was looking for.

How to create unique constraint over multiple columns?

In Administrative Tools - Services -

Check whether SQL Server is listed

I am using this :

select * from users

where regdatetime > Dateadd(hour,-24,getdate())

Will this give correct result :

if suppose user registers at 11 pm of 15 sep

and if I see...