What you need in a trigger is to write the query to perform the update. Join the "inserted" table with the base table to perform the update.

We would like to...

Is anything different running on the servers? Where is the backup file v the data files on each server? As Jeffrey mentioned, I/O is usually to blame here.

I think you should mention it. That's quite an accomplishment, very few get there, and it's definitely an ice breaker.

It only queries locally, so it works for the local host, not remotes.

However, it will get you lots of stuff if you want it.

Did you create a computed column as GSquared indicated? You can't have an identity that is a character. You have an integer identity and then you have a computed column...

xp_regread?

Query the registry.

I still think he was creating a new word. Like "upgradation"

The question was edited to include an ORDER BY. Questions get edited if mistakes are found.

[drive by post]

Well maybe the questions aren't worse, but the grammar certainly is!

"The problem is that the order by clause was left out on the initail page."

[/drive by post]

blandry (5/29/2009)

---

If I get the salary like an athlete, does that mean that I have to...

- Immediately start using steroids?

- Open up a pit bull fighting arena in my backyard?

-...

Edited the title. Please don't use tags in the titles.

Are you not backing up data? Or are you just trying to get schema data?

You can let people onto the publisher after you've enabled replication, and if the subscriber isn't available, you are correct, the distribution db/log grow until they can get to the...

I used to deploy changes like this using osql and a batch file. Now I'd use SQLCMD. The SQL Server install runs .sql files for some things using SQLCMD

Interesting. I thought most people would be against it.

For professional atheletes, it's a dog eat dog world, and they often go down as well as up. It just isn't reported...