How big is the index?

You're welcome.

Alter Database requires exclusive database access. To make this work, you'd have to make the code disconnect all other connections to the database and kill all pending transactions. ...

The view is simply a pre-built select statement. When you query a view, it simply gets added to the definition of the outer query.

That means, no, it doesn't pull...

I posted a reply to that one in that thread (to keep it all in one place).

I'm not sure I'm clear on what exactly you're trying to accomplish with this.

If the first update statement updates 1 or more rows, but the second one doesn't update anything,...

It means something other than the ASCII standard tab character or spaces was used. That's why I asked about what editor you're using.

PiMané (10/31/2009)

---

damn.. forgot bout that :S

Thanks...

So, if there's no need to point in time restore, the best for us is to have single mode, with full backups and diff backups...

I can't really recommend any classes to take, since I'm completely self-taught on the subject.

I can recommend getting a copy of the SQL Server Bible (you can find it on...

@@Rowcount only works on the last command within the scope of the code. Thus, unless the trigger itself is updating something, it will return 0. What you need...

Delete the indents.

Are you using an editor other than Management Studio for this?

If you select from the backup tables in msdb, you should be able to get the file name of the most recent full backup that's more than 1 day old...

Haven't tried it, but I imagine Express would work just fine for that. Just keep the databases small and no heavy transactions.

I had to delete your indents and fix a typo in the Close command, but after that it compiled and ran on my machine.

There weren't any SPIDs to close, since...

Don't do it in a trigger. Set up a job that archives data on a scheduled basis. That almost always works better.