Give it a try

This script takes database names and table name as Input parameters and compares column names and data types if they are not matched it will display the...

try with explicitly opening distributed transaction like this

BEGIN DISTRIBUTED TRANSACTION

-- see BOL for more details

Return type should be sysname, It is the nvarchar(128) datatype used to store the object names in SQL Server

try like this

DECLARE @UseIt1  varchar(100),

@WorkQueue varchar(100)

EXEC ('SELECT  A.AcctNo ' +

'FROM QueueOrderExcessDol A ' +

' INNER JOIN _FinalFlat B

ON A.AcctNo = B.AcctNo

INNER JOIN QueueComboBox D

ON B.WorkQueue = D.ProgramKeyField

WHERE B.Tagged = 0

AND...

you can use Left function also, but it won't accept ntext datatype,

you have to explicitly convert the datatype to character types

This is because you may have one of the column with text datatype

try converting text to varchar datatype

select convert(varchar,textcol)+char(13)+' Right' from tab

Its exactly what Jun wanted

you can replace the select statement for cursor with this

select

o.name as tab ,i.

These are the SQL Server generated statistics for the tables. Statistics generated tables will have a row in sysindexes table 

you can register the server with the machine name itself (If it is having a default Instance)

In the local EM local DB Server will be visible as localhost only

hope this...

Use this procedure to delete all non clustered indexes in the database

Create procedure dropIndex as

Begin

declare @tab sysname,

 @idx sysname,

 @sql nvarchar(4000)

declare cur cursor for

select o.name as tab ,i.name as idx...