Viewing 15 posts - 6,331 through 6,345 (of 9,643 total)
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)Hey, that's why I've spent the last 2+ months in NH.
Because my wife told you too?
Every married man has a "She who must be obeyed", but...
January 9, 2009 at 11:25 am
Well you could use the undocumentes sp_MSForEachTable procedure to loop through and run the update. Something like this:
Exec sp_MSforeachtable @command1 = 'Update ? Set column_Name = value' , @WhereAnd...
January 9, 2009 at 11:24 am
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)
Steve Jones - Editor (1/9/2009)
I'm with Grant, heat, heat, heat.I like skiing, but other than that, I'd like warm weather all the time.
Denver doesn't seem like...
January 9, 2009 at 11:11 am
Roy Ernest (1/9/2009)
Thanks Jack for completing my answer. I have to work on my answering skills. I always give the answer in a general form. Not specific to the question.
Sometimes...
January 9, 2009 at 11:10 am
If all you want is a copy of the source in the destination the simplest and most error proof solution is to truncate and reload everything.
January 9, 2009 at 10:54 am
gcopeland (1/9/2009)
January 9, 2009 at 10:23 am
Any SQL Server CD\DVD will have this. When installing just choose to install the tools.
January 9, 2009 at 10:09 am
There are also several third party products that do real-time and historical monitoring.
http://letmegooglethatforyou.com/?q=SQL+Server+Performance+Monitoring+tool
January 9, 2009 at 10:06 am
Do you mean the actual column name needs to be changed or the data in the column needs to be updated?
January 9, 2009 at 10:02 am
IF the service is running using the domain\JkSQL account then you add this account as a login to the SQL Server and then create a database user for that login...
January 9, 2009 at 10:00 am
sp_who and sp_who2 show blocks.
January 9, 2009 at 9:49 am
You'd probably get better answers posting this on a asp site as it has nothing to do with SQL Server.
My guess is that FormatNumber is expecting a numeric and that...
January 9, 2009 at 9:46 am
I'll chime in that I have always used the separate tables. I don't recall reading either of the articles Grant mentioned so I must have slept through the days...
January 9, 2009 at 9:39 am
Interesting discussion thus far. I don't think any regular readers/watchers care what you wear as long as it is not offensive, of course someone has to define offensive.
I've never...
January 9, 2009 at 8:47 am
Steve Jones - Editor (1/9/2009)
I'm with Grant, heat, heat, heat.I like skiing, but other than that, I'd like warm weather all the time.
Denver doesn't seem like the right place for...
January 9, 2009 at 8:34 am
Viewing 15 posts - 6,331 through 6,345 (of 9,643 total)