If I recall correctly, you can use UNICODE data type for multilanguage support, refer http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx and http://www.sqlservercentral.com/articles/Miscellaneous/globilizationinsqlserver/1946/ hth Hemantgi...

If I recall correctly, you can use UNICODE data type for multilanguage support, refer http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx and http://www.sqlservercentral.com/articles/Miscellaneous/globilizationinsqlserver/1946/ hth Heman...

Mustaq, Let us take an example of here, suppose you are writing a book - 100 pages book. While writing a book you are asked to skip 3~4 lines on each page, at the end you may have skip total 15~20 pages. That mean, the book is 80~85% full. In si...

Mustaq, Let us take an example of here, suppose you are writing a book - 100 pages book. While writing a book you are asked to skip 3~4 lines on each page, at the end you may have skip total 15~20 pages. That mean, the book is 80~85% full. In simpl...

Nirav, You may also refer the article I have published year ago http://www.sql-server-performance.com/2010/sql-server-upgrade-issues/ hth...

Nirav, You may also refer the article I have published year ago http://www.sql-server-performance.com/2010/sql-server-upgrade-issues/ hth...

Hi, To best of my knowledge you can use UNICODE datatype for this. Sorry was too busy to revisit this forums since month....

Hi, To best of my knowledge you can use UNICODE datatype for this. Sorry was too busy to revisit this forums since month....

Anil, Assuming you have SQL Server 2005 or above, try as below : SELECT top 5 kpid,lastwaittype,PROGRAM_NAME, ROW_NUMBER() OVER ( ORDER BY lastwaittype) AS 'Row Number' from master..sysprocesses order by 'Row Number' DESC...

Anil, Assuming you have SQL Server 2005 or above, try as below : SELECT top 5 kpid,lastwaittype,PROGRAM_NAME, ROW_NUMBER() OVER ( ORDER BY lastwaittype) AS 'Row Number' from master..sysprocesses order by 'Row Number' DESC...