Another case

I have a big Table with 100+Gb data. I need to change one column datatype from varchar 200 to varchar max. I was trying with Alter command but it...

Yes we have a clustered index on it.

DOB also has an Non clustered index on it.

It is a user database.

Put your Dynamic Query in two different variables and then

run it as

EXEC (@cmd + @cmd1)

Hi All,

I have tried this below sp. But it shows the Script of Length 256 only. Can anyone please

tell how to increase the Length.

if exists (select * from dbo.sysobjects where...

Can u please send me the link where the Source Code is available.

I had alread tried it but unable to find source code.

Thanks,

Amit Khanna

Hi,

I think there is not any application for such task.

Even the Coding standards are company specific.

Thanks,

Amit Khanna

Hi,

Please tell the data type of Start Date and End Date.

Thanks,

Amit Khanna

Try this one:

DECLARE @sql_handle-2 VARBINARY(20)

SELECT @sql_handle-2= SQL_HANDLE FROM MASTER.DBO.SYSPROCESSES

WHERE DBID=DB_ID('db name')

SELECT TEXT FROM ::FN_GET_SQL(@SQL_HANDLE)

Thanks,

Amit Khanna

Please check out the permissions on your login.

Please go through the below link.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d4c26311-d9f4-432c-953a-1c1042b33c97.htm

Bhuvnesh,

I guess you have not gone through the problem fully.

Thanks,

Amit Khanna

Please post some insert statements too.

Change the definition of Position Column to

Position VARCHAR(8000) NOT NULL

This will work.

Thanks,

Amit Khanna