Thanx for the clarifications, that will solve my problems on the short term.. but I think I'm gonna go back to vb to do this one since I already have...

Actually I replace only the first occurance of the "create", so if I replace a comment instead of the script then I get an error that the object already exists.

You...

I forgot to tell that when I execute the printed statment I get nothing beyond Col01 printed (even id Col02 has text in it)... maybe that's another problem of its...

What we do here is put the .adp on a shared folder. Then every morning a batch file is executed from the user pc and the files are copied...

BTW I would be interested to know what's the final speed compared to the original trigger you posted... I curious to know how much of a difference that makes (the...

I think you could make it even faster... I noticed that you are joining deleted to inserted on every update query. What you are doing is asking sql...

I can think of 2 things, 1st you could try updating 100 rows at time to see if the update trigger actually works and if the time required is lower....

Those are system generated indexes (or statistics.. maybe someone else could clarify this). As far as I understand they are generated when a where condition or order by is...

I've also seen this error accur in many different situations. But most of the time for me it was a faulty SP as the data source of the form...

btw if you are planning on using this on huge tables (1 M + rows), you can also disable the triggers, constraint, foreign keys and indexes to do the bulk...

That's why I was suggesting the openrowset, because what you do is force sqlserver to make the inner join instead of coding it yourself (which is exponentially slower as you...

I can't tell you what's wrong wit your script... but I can give you another way of doing this which would be much faster than ado..

I assume you can use...

Sorry... I missed that part of the post but I'm glad the query could help you.

This will also retrieve the indexes of the indexed views and also tell you if the index is a primary key.

SELECT O.Name AS tbl_name, i.name AS...

if exists (Select * from dbo.sysobjects where name ='Teams' and xtype = 'U')

drop table Teams

create table Teams(team_id int IDENTITY (1, 1) not null primary key, team_name varchar(50) not null)

if exists...