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.

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...

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...

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

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

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...

Hi, is there an easy way to estimate the size of the indexes for a database? there's this microsoft site: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp but it mentions the index levels, ect. I don't know the levels, just need to estimate the...

This is probably a dumb question, but I gatta make sure, never done it before. When replaying the Profier, do all the transactions ACTUALLY get performed on the database (inserts, deletes, etc)? Thanks

Running a trace in Profiler, I see the longest duration corresponds to TextData column = NULL. I'm talking like 10 min duration. At first I suspected those are system spids, but there's an application name in LoginName column. Then those that have actual statements in TextData have normal...

Hi, I am taking this here based on a member suggestion, Question: Is there a way to import the added counters from saved Counter Logs file into System Monitor for viewing? I don't want to manually add all the counters every time I want to view the saved file. And you gotta make sure the...

Hi there, Can I import a chart from perfmon (Windows 2000 System Monitor) into Excel graph? Thanks

Hello, I want to run the perfmon on remote server from my machine, and avoid logging onto the production server. I know that sometimes Local System account will not let you write the file to disk. But I have write permissions on the server. If you map remote server drive to your local machine...

Hello again, Question: Is there a way to import the added counters from saved Counter Logs file into System Monitor for viewing? I don't want to manually add all the counters every time I want to view the saved file. And you gotta make sure the counters are the same! Would be neat to just...

I have a db_owner sql account that I want to revoke create permissions from. I log in as dbo (sysadmin) and execute: REVOKE CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW, BACKUP DATABASE, BACKUP LOG from test_me But I can still create table...

Hi all, I got PCMCI D-Link AirPlus Extreme on W2K Pro laptop, and can't figure out where to enter the password for Wep64 wireless network. My driver sees the network, I can connect and see it, but ipconfig shows 0.0.0.0 I can't find where to enter the passwrd, any help is appreciated. Thanks

Hi there, Any good place to get the list of the most important counters to monitor, along with their thresholds? Thresholds are key, I havn't found a good list of these anywhere. Thanks