Viewing 15 posts - 7,096 through 7,110 (of 14,953 total)
One of the most fundamental rights any human being has (or has been denied) is the right to choose with whom to associate. If Lynn, or anyone else, chooses...
February 10, 2010 at 2:34 pm
There isn't a built-in function for that, so far as I know.
However, does this give you enough for what you need?
select serverproperty('machinename'), serverproperty('instancename');
February 10, 2010 at 2:27 pm
Oh, and as for stumping the gurus: It's pretty easy to stump just about anyone when you can only provide half of your problem-space definition.
You can be just as proud...
February 9, 2010 at 2:55 pm
CirquedeSQLeil (2/9/2010)
I think the only method to exclude those two tables (sysdiagrams and dtproperties) is to hard code them into the query. Anybody else have any other ideas?
That would...
February 9, 2010 at 2:53 pm
Lynn Pettis (2/9/2010)
J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be...
February 9, 2010 at 2:51 pm
BaldingLoopMan (2/9/2010)
...I still havent figured how ensureing the table doesnt exist in the ext prop table omits the sys tables however i've been busy defending myself. ...
It's not guaranteed to...
February 9, 2010 at 2:49 pm
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.
Expert? Yeah...
February 9, 2010 at 9:35 am
Alvin Ramard (2/9/2010)
GSquared (2/9/2010)
Alvin Ramard (2/9/2010)
Oh oh. Someone is asking for documentation or white paper for the "command". :w00t:Gus, wipe that smile off you face! 😀
(Desperately tries to...
February 9, 2010 at 9:32 am
Alvin Ramard (2/9/2010)
Oh oh. Someone is asking for documentation or white paper for the "command". :w00t:Gus, wipe that smile off you face! 😀
(Desperately tries to attain a straight...
February 9, 2010 at 9:22 am
mehmetburak.akkus-832492 (2/9/2010)
hi guys 🙂is there a full description or a white paper for this command ?
There isn't yet, but if you plan on storing the future document into a filestream...
February 9, 2010 at 8:45 am
The Dixie Flatline (2/8/2010)
Michael Valentine Jones (2/8/2010)
February 9, 2010 at 8:35 am
Lowell (2/8/2010)
somehow I've forgotten to create...
February 9, 2010 at 8:34 am
sys.tables, by design, only returns user tables. BOL says that right at the top of the description, and I just tested it and confirmed it on two servers. ...
February 9, 2010 at 8:20 am
EdVassie (2/9/2010)
Problem is, they're local admins--they can get round stuff like that!
True for NT4, don't know for Windows 2000, but not true for Windows 2003 and above. There are...
February 9, 2010 at 6:09 am
Standard measures and rules of that sort are of incredible value (in most cases) to people who are first learning a subject. Once one really knows the subject and...
February 8, 2010 at 10:50 am
Viewing 15 posts - 7,096 through 7,110 (of 14,953 total)