Is it possible to compare in SQL or shall i use front end program to compare these?

Thanks for the reply.

I want to display (ONLY) all the updated columns in a record. When I use CASE in SELECT it will show only the Fname or Lname. In...

Ok, thx. Will do it manually.

But eager to know how to transfer just data from one server to other server using script.

Thanks I got it.

But it ignores Primary columns and relationship between tables. Is it possible to transfer along with it.

No, Express ediiton has no Import/Export Wiz. Is it possible to download DTSwizare.exe from net?

I will manage to script the table and triggers from one server to another server by using option "Script Table as" in SQL Express edition.

But how to transfer Data from...

When i update 5th and 11th coulmn, print print COLUMNS_UPDATED() displays "0x100400".

What it means?

My query is for example if you have a table with column named from a to z. I want to display all columns expect b,e,f.

Instead to writing all columns...

I found the location of error file. 😀

I stored my project in c:\Migration\MIGRATION1\SqlMigration1. So the error report is available in the below location in different report folders

c:\Migration\MIGRATION1\SqlMigration1\report\report_2008_05_27T10_05_18\mainindex.html

I am SQL express 2005, so Import and Export option is not available.

Wow! I have downloaded and tested SSMA it worked perfectly.

But I closed the Error report unknowlingly. Is it possible to generate the error report only without migrating the database...

Thanks but which one is best. Did you have any good web link for each.

1. Upsizing wizard in Access

2. SSMA (SQL Server Migration Assistant)

3. SSIS (SQL Server Integration servcies)

or

4. Data...

Yes, I understand.

I just testing it. I will modify this and use it to change the default value of column by deleting the previous constraint and recreating it again...

I got it the below code dynamically assigns DEFAULT to any column:

Create table tbl(title nvarchar(40))

Create procedure df_bppr @de nvarchar(30)

As

Begin

Declare @sstr nvarchar(500)

If Not exists(select * from sys.objects where name...

Shall any one check and give the correct code????