Viewing 15 posts - 46 through 60 (of 85 total)
Thanks, I got the a list of counters from the Microsoft PAL tool someone at Microsoft told me to look at the xml config files and there's a list that...
July 10, 2009 at 5:24 am
I see no problems if it doesn't affect anyone, it's the logical name.
July 10, 2009 at 4:27 am
Just looked up what I read and it says 'XML-like format' in BOL, that's why I thought it was XML, probably read it too quickly, it also says maybe use...
July 10, 2009 at 4:15 am
I use trace flag 1204, doesn't 1222 give the results in xml? I think it's , -1 after the command and it sets the flag to global rather than local...
July 10, 2009 at 3:40 am
The problem is if you rebuild your on a regular basis it will be slower if you keep shrinking the log file as it will have to grow with each...
July 10, 2009 at 3:28 am
What server are the linked servers connecting to? 2000 or 2005?
You could always either script out the paswords on the server the logins exist on using the scripts provided...
July 7, 2009 at 9:15 am
This is almost like a list of features rather than audit! Sounds like you need to write down all the settings on the server and then fix anything that...
July 7, 2009 at 9:06 am
I don't know if I've got this right but you could either try
select 'exec ee_updatestatus',',', '1',', ''', getdate(),''' ,', '5',',' ,'0'
if you just want the text or just...
June 19, 2009 at 4:22 am
If you're only going to pass getdate() each time then just declare it as a variable inside the sp and don't pass it so you don't get the error.
June 19, 2009 at 3:52 am
jason brimhall (6/18/2009)
I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I...
June 19, 2009 at 2:21 am
barsuk (6/18/2009)
if you have text data in your table, there is a good chance that table size will not be reflected properly under the scipt posted above
Can you provide me...
June 19, 2009 at 12:45 am
The account I was using is in the administrators group on the server and I've just checked and that group has the rights you mentioned.
The question is why would running...
June 18, 2009 at 4:24 am
I don't think there is a way other than converting the databases to be in the same collation, collation is a very annoying thing when you get into it for...
June 18, 2009 at 3:11 am
If it's a production DBA role be sure to know the things that ps mentioned above, especially questions like:
Name the system databases? (don't forget on this on to mention...
June 18, 2009 at 3:03 am
At the end of your statement add 'COLLATE' followed by the collation name that you want the results in.
June 18, 2009 at 2:55 am
Viewing 15 posts - 46 through 60 (of 85 total)