Can you post some sample data? Like suggested in the first link in my signature.

Are you just doing this in SSMS? If so the SSMS query window only output a certain number of characters. If you go into tools -> options and...

After years of voting in small-town NH where at least one of the election volunteers knew you so you did not need to prove who you were or where you...

Basic restore would be like this:

-- this lists the files in the device so you can find the right file numbers

Restore filelistonly from abc

-- this is the restore of the...

If this is a requirement then you need to implement your own "identity" function with a table that contains the next value. Otherwise you should live with identity as...

I believe you are asking if you can change the on UPDATE action for a foreign key constraint. You need to drop the constraint and then re-add with the...

I don't believe that there is a way to do that directly in profiler. I think you could figure that out by using a combination of the lock timeout...

Can you provide some more information, like:

Are all the SQL Servers at the same service pack level?

What are the parameters you used when executing the linked server stored procedures?

Can you...

arunkumar.sp (11/20/2008)

This is the code i written in web application and it is working fine for me.

...

I prefer to encrypt in the front end so that the data is not traveling over the wire unencrypted. I also like the way .NET does encryption better then...

Even if you use a third-party app to do encryption the developers would still need to change the app. There would have to be a step somewhere that encrypts...

I wonder if you are having an issue due to the space and period in your report path? If you are not getting an error I don't really know...

Like Gail said, if you have it indexed properly there is no reason not to use it in a where clause.

Is the code column defined as nvarchar(2) or something else? If all your codes are 2 characters you should use nchar(2).

Do you mean you are using the code column...

From BOL:

Restore a full database and a differential backup

This example restores a full database backup followed by a differential backup. In addition, this example shows restoring the second backup set...