Search results for query: *

Hi, I posted this on W2003 Server, but had no replies, so could be wrong forum. Anyway, here's the jist: I am having an issue in that I loose counters when I try to open the saved Counter Logs file that collects counters from remote cluster. The cluster is default instance, Active/Passive. The...

Hello, I am having an issue in that I loose counters when I try to open the saved Counter Logs file that collects counters from remote cluster. The cluster is default instance, Active/Passive. The cluster is Windows 2000 Advanced server, I am gathering them from a Windows 2003 Standard dev...

I know everyone says that GOTOs are evil, but why? Is it a memory issue? Code inefficiency? Thank you

Hi, Say I have numeric like: 765.9876000 I want to be able to present it as 765.98, basically leave only 2 numbers to the right of the decimal point? Round () function does not really work here, I think SUBSTRING () could, but not sure how? Thanks in advance.

I agree with vbkris, use pointers.

this works: strComputer = "." Set objWMIService = GetObject("winmgmts:" & _ "{impersonationLevel=Impersonate}!\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery ("Select * from Win32_Service") For Each colItem In colItems WScript.Echo objItem.Name Next

still getting an error: Line 7 Char 2 Object Required: 'objItem' Thanks

This script is right out of the book, and is supposed to show all services running on local machine. strComputer = "." set objWMIService = GetObject("winmgmts:" & _ "{impersonationLevel=Impersonate}!\\" & strComputer & "\root\cimv2") Set colItem = objWMIService.ExecQuery ("Select * from...

That's correct, it DOES take special effort to display quotes. I don't want to display them. Not only do I not want to display them, but when I copy thje result of the formula from Excel to notepad, I don't want to see the quotes. My problem is that when the formula is as: ="grant execute to "...

SkipVought, Thank for the reply. My point is I don't want the qoutes at all. I want the expression to appear as: grant execute to MyProc go But when my formula is ="grant execute to " & A1 & CHAR(10) & " go" it appears fine in Excel, but when I copy/paste it it has quotes, like this...

I'd like to code my GRANT EXECUTE statements in Excel, like if I have a sql stored procedure called myProc in Excel A1 field, this is the formula I'd type in B1: ="grant execute to " & A1 & CHAR(10) & " go" But the result contains quotes, like this: "grant execute to myProc go" How can I...

Thanks for the thoughts. my machine is XP home edition, high-speed DSL. I'll patch the malware, and let you guys know what came of it. Thanks again

Wierd issue, my taskbar disappears ocasionally. I'll reboot, and it's back, then gone again. I set the settings in Control Panel->Taskbar app, but problem still persists

I'm trying to render the following Hebrew caracters: îñ äëðñä ùìç îô÷ç ìáéú äëðñú. In my hotmail.

Hey there, I'm trying to render foreign text in my hotmail window, no joy. I've tried everything, Regional Settings, Tools->Options, and still see a bunch of gibberish. Any suggestins are appreciated.

Hi, I installed sql server 2005 with Notification Services, but I don't see it running. Is it under a different name? Thanks

you mean you script your own?

Hey, I found this without an answer, and realized I don't know it either. Can Someone comment on this? If the primary logshipping server doesn't exist anymore (bomb?), how can I run sp_change_primary_role and sp_change_monitor_role (if the monitor was promary). If I don't run it on primary...

no, just regular data types.

Denny, I suppose by "average length of the data is 17 char" you mean only columns included in the index, correct? In other words non-clusterd index is as big as the data? Thanks