MCTS 70-431

what is the status of your database?

check the status using sp_helpdb

Have you configured any high availability options?

Hi Ritesh,

Collation can be set only during installation..u can change that during installation...

If u have already installed u need to uninstall and reinstall the server.

Thanks to all 😛

Thanks Florian for the Tips,

Actually created this as an experiment. I want to convert this to DB2 which i dont know..Do you have any idea? I will be very thankful...

ALTER procedure [dbo].[rkn_pk]

@tabname char(50),

@colname char(50)

as

begin

declare @sql as varchar(500)

select @sql='alter table '+ RTRIM(@tabname) +' add constraint '+ RTRIM(@tabname)+'_pk1' + ' primary key'+ '('+RTRIM(@colname)+')'

execute (@sql)

end

EXEC [rkn_pk] 'RKN','NO'

Solved

Created this but getting error while executing as the constraint name is creating lot of space

alter procedure rkn_pk

@tabname char(50),

@colname char(50)

as

begin

declare @sql as varchar(500)

select @sql='alter table '+ @tabname +'add...

Thanks Grant.

My idea was to create a procedure like

create procedure rkn_pk

declare @tabname char(50)

declare @colname char(50)

as

alter table @tabname add constraint @tabname+pk primary key on @colname

Is that possible.

TIA

Try giving port number with the connection string.

Check using the machine name rather than IP Address.

Check whether you have enabled the remote connections..TPC IP & Named pipes.

You can use Import Export Wizard but that wont create the constraints.

For that you have to script out the constraint and ran the same on the destination.

I just tried to shrink the tempdb issued the DBCC SHRINK command after that...

Anyway thanks for the information 🙂

Krishna,

Just try that and see what happens