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...

Come on guys I'm not even a DBA and I know this one. I built a little software that queries pretty much every major system table to extract information...

I'm glad I'm not the only one who thinks this isn't a fair question... at least I learned something new today.

I found the solution... Sqlserver was a named instance using a domain account so I just changed to local info to : REMI\Dev and it worked like a charm...

That's 1...