Viewing 15 posts - 5,716 through 5,730 (of 9,643 total)
This is odd. Somebody smarter than me will have to give you the answer on this one. If you look at the
Estimated Execution Plan, it looks like...
March 9, 2009 at 3:04 pm
GSquared (3/9/2009)
GilaMonster (3/9/2009)
Bob Hovious (3/9/2009)
Gail, weren't you the person who observed that GROUP BY produces the same execution planas DISTINCT?
Yup. A group by on all columns in...
March 9, 2009 at 2:38 pm
K. Brian Kelley (3/9/2009)
"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server."
If everyone...
March 9, 2009 at 1:37 pm
I'm not sure that there is a tool for SQL Server that would show when a user copied your database. If the SQL Server is running and the database...
March 9, 2009 at 12:22 pm
You could look at http://www.endtoendtraining.com if you want a class.
Jacksonville has a SQLSaturday on May 2nd and that's "only" a couple hours from Orlando.
The Orlando SQL Server User...
March 9, 2009 at 12:12 pm
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.
Look at his latest post on that thread. ...
March 9, 2009 at 12:00 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
ALTER TRIGGER [dbo].[tr_insert]
ON [dbo].[table1]
AFTER...
March 9, 2009 at 11:55 am
Lynn Pettis (3/9/2009)
ALTER TRIGGER [dbo].[tr_insert]
ON [dbo].[table1]
AFTER INSERT...
March 9, 2009 at 9:22 am
Bob Hovious (3/9/2009)
I see a little silhouette-o of a man
Scaramouche! Scaramouche!
Will you do...
March 9, 2009 at 8:20 am
Like I asked earlier, can you post the trigger? Without seeing the code anything we say would be a guess. The main idea is that you probably are...
March 9, 2009 at 7:53 am
Steve Jones - Editor (3/7/2009)
I don't want to get too much editorial stuff...
March 9, 2009 at 7:38 am
You may want to take a look at this article from BOL, http://msdn.microsoft.com/en-us/library/ms191307(SQL.90).aspx
March 9, 2009 at 7:23 am
Raj,
This is the third time I've seen this post and the second one I've seen that has answers. Please only post once so we don't duplicate answers across threads.
The...
March 9, 2009 at 7:20 am
Here is an article that deals with the basics of DML triggers, http://www.sqlservercentral.com/articles/Triggers/64214/.
You should also lookup triggers in Books On Line.
SSMS also has templates that show you the...
March 9, 2009 at 7:17 am
Duplicate post. Please see other answers here: http://www.sqlservercentral.com/Forums/Topic671411-146-1.aspx
March 9, 2009 at 7:13 am
Viewing 15 posts - 5,716 through 5,730 (of 9,643 total)