Viewing 15 posts - 76 through 90 (of 515 total)
vmsbalaji (3/28/2008)
Suppose i am having 10 tables in a database.in that 10 tables,5 tables are having the column value as 'cat'.i need 5 tables name alone.more over it must...
March 28, 2008 at 1:36 pm
rbarryyoung (3/26/2008)
You could just use the veiw defined in this article and do a SELECT on it WHERE NAME={your table name}, : http://www.sqlservercentral.com/scripts/tables/62545/
Am I in some sort of time warp?...
March 28, 2008 at 1:30 pm
Chirag (3/26/2008)
Want to clear some things here...
What i really wanted to know when i started this link was whether the query plans would be affected if i drop and create...
March 28, 2008 at 1:20 pm
I suspect that a recovery was started and left so that more logs could be applied.
RESTORE DATABASE [analysis] WITH NORECOVERY
I would suggest trying to recover to read only mode first.
RESTORE...
March 28, 2008 at 7:09 am
albuterol with wings... And if you happen to be allergic to the bat, well they counter act each other. 🙂
Can't say it was too exotic considering some...
March 18, 2008 at 12:42 pm
Oh, the rest of it? I was only curious if actual connections was set to 0, which would imply the issue was something other than running out of actual...
March 18, 2008 at 8:10 am
The current version of SS 2k5 is 9.0.3228 http://support.microsoft.com/default.aspx?scid=kb;en-us;949095&sd=rss&spid=2855, although I don't see any need to apply what are called Cumulative Updates. I would however go to MS and...
March 18, 2008 at 8:08 am
Which version of SS are you using? What about the Server configuration?
March 18, 2008 at 7:20 am
You need to enable advanced options first
sp_configure 'show advanced options',1
RECONFIGURE
sp_configure 'user connections'
-- sp_configure 'user connections',0
-- RECONFIGURE
However, I suspect that you have a different issue. The default is 0 (Auto...
March 18, 2008 at 7:18 am
Steve Jones - Editor (3/17/2008)
I once got a resume with the "Interests" section saying "Eating exotic meats"
I wanted to bring the guy in just to see him, but...
March 17, 2008 at 1:21 pm
Jeff Moden (3/15/2008)
Bob Fazio (3/14/2008)
Pat Reiter (3/14/2008)
Examples use CHAR(9), but compare to string of format '###-##-####' . Are the dashes not part of the string?
The example was wrong. ...
March 15, 2008 at 7:21 am
It is currently against the law to use the SSN as a PK (I went through much pain to change several databases). Ok, the law states that it can't...
March 14, 2008 at 3:19 pm
Pat Reiter (3/14/2008)
Examples use CHAR(9), but compare to string of format '###-##-####' . Are the dashes not part of the string?
The example was wrong. It should have been...
March 14, 2008 at 2:20 pm
Mike Menser (3/13/2008)
March 13, 2008 at 2:19 pm
Chris Morris (3/13/2008)
...told of seagulls which used to land, swim and drink from an outside, open-air cooling tank - then deposit luminescent radioactive droppings on peoples' cars.
That's nothing. We...
March 13, 2008 at 2:02 pm
Viewing 15 posts - 76 through 90 (of 515 total)