Check

query governor cost limit setting on server.

Add the user as member to the specific database roles.

Particular db_datawriter and db_datareader.

Is win2003 Clustered?

What's difference between 7.0 standard edition instance which have the problem and other 7.0 instances. Are other 7.0 instances not standard edition?

What's sp version on both...

Little change to the code.

 SET @findSQL = 'declare @suppress sysname;SELECT @suppress=table_name FROM INFORMATION_SCHEMA.COLUMNS

      WHERE TABLE_SCHEMA = @vOwner AND TABLE_NAME = @vTblname AND COLUMN_NAME = @vColname'

 SET @parmdef = N'@vOwner...

script dbcc dbreindex to exclude those 'large tables'

select ascii(alpha) - 65

or

select ascii(upper(alpha)) - 65

It works for me (sql2000 sp3).

case approved when 1 then approvedvalue else unapprovedvalue end

Openquery if you have linked server

or

openrowset

Get sql collation info from

exec sp_helpsort

Not sure about db2 link, it may relate to OLEDB provider.

Check Autostart SQL Server Agent option when the operating system starts.

isqlw -Sservername

No hard-coded table name in trigger and works for any number of columns.

Create Trigger tr_admin

-- list all columns that were changed

On admin

For Update

As

 SET NOCOUNT On

 declare @intCountColumn int, @n int, @tblname sysname

 select...

Table with any number of columns

create Trigger tr_admin

-- list all columns that were changed

On admin

For Update

As

 SET NOCOUNT OFF

 declare @intCountColumn int, @n int

 -- count columns in the table

 SELECT @intCountColumn = Count(Ordinal_position)-1

 FROM...

if admin table has 8 column or less

create Trigger tr_admin

-- list all columns that were changed

On admin

For Update

As

 SET NOCOUNT OFF

 declare @intCountColumn int

 -- count columns in the table

 SELECT @intCountColumn = Count(Ordinal_position)-1

 FROM...