Viewing 15 posts - 23,596 through 23,610 (of 39,818 total)
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...
May 30, 2009 at 6:51 pm
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.
May 30, 2009 at 3:15 pm
I think you should mention it. That's quite an accomplishment, very few get there, and it's definitely an ice breaker.
May 30, 2009 at 10:40 am
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.
May 29, 2009 at 2:04 pm
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...
May 29, 2009 at 2:03 pm
I still think he was creating a new word. Like "upgradation"
May 29, 2009 at 12:42 pm
[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]
May 29, 2009 at 10:49 am
blandry (5/29/2009)
- Immediately start using steroids?
- Open up a pit bull fighting arena in my backyard?
-...
May 29, 2009 at 10:38 am
Are you not backing up data? Or are you just trying to get schema data?
May 29, 2009 at 8:55 am
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...
May 29, 2009 at 8:52 am
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
May 29, 2009 at 8:34 am
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...
May 29, 2009 at 8:11 am
Viewing 15 posts - 23,596 through 23,610 (of 39,818 total)