Hi Igor Micev,bitbucket-25253

Thanks for your reply.

In bitbucket-25253 reply Error message is shown as warning/information in sql .So, I'm not able to get/display in front end(C#/VB.net)

Regards

GuruPrasad.G

Thanks Lynn Pettis

Max column length may vary.

And your code

select

country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;

does not suit...

I need to display country and currency_code in a single column.

select country + space(46-Len(country)) + CONVERT(varchar(max), currency_code ) from currency order by country

Afghanistan,...

Thank you

Vinu Vijayan

Imoveis em Guarulhos

Imoveis em Guarulhos its not working in some case..

Vinu Vijayan data type is int only.

Regards

Guru

declare @colname nvarchar(max),@coltype nvarchar(10)

set @colname='purchase_order_no'

set @coltype='int'

select O.name,ROW_NUMBER() Over (Order by o.name)RNo ,c.user_type_id,SCHEMA_NAME(schema_id)SCHEMA_NAMEs into #temp from sys.columns C inner join sys.objects O on C.object_id=O.object_id where C.name like @colname...

Thank you,

sqlzealot-81

Trying to create for database triggers

Regards

Guru

Hi

http://www.sqlservercentral.com/Forums/Topic1270780-391-2.aspx

Try this

Regards

Guru

Thank you sqlzealot-81,

But I need to track who changed and its history of changes..

Regards

Guru

Thank you Lowell

Regards

Guru

Hi all,

Can we use SET CONTEXT_INFO 0x9999 to disable trigger in current session /user?

Regards

Guru

Without disabling triggers how can be prevent trigger getting fired.. Because if we use multi-user it will be problem when disabling trigger right?

Regards

Guru

Hi Sean Lange,

Let me know if there is any change / modification regarding performance (writing simple query)

Regards

Giri

Hi sclements,

Ur Quantity have null values try for isnull

Regards

Guru

Hi Sean Lange,

Sorry for the delay.

I had attached 3 documents

CreateTriggerAfterAlterTable.txt

Is for altering the trigger when a column is added or deleted

And this will be called in

sp_StandardCDC_enable_db.txt

The...

when i surfed in google its shows that SQL Server Agent could not start in express edition.

Is it ?

Regards

Guru