Viewing 15 posts - 16 through 30 (of 79 total)
i am getting 1418.
i tried to use FQDN, something like :
tcp://server.fakedomain:5023
where i put : server.fakedomain in the host file
or should i try to do it in another way?
June 20, 2011 at 1:40 am
what do ypu mean by
"but I would suggest running the production services under an unprivileged user account. "
June 16, 2011 at 12:41 pm
ping and telnet works on both directions.
i dont see any errors.
the thing is that the server are not in a domian,
so i can't build a fully qualified domain for the...
June 15, 2011 at 12:49 am
Yep. A CTE can be referenced multiple times inside of the statement immediately following it, but it can't be referenced by multiple statements within the query.
you mean it can...
January 11, 2011 at 12:33 pm
"SSC Veteran" - what do you mean by that?
that you can't use the same cte more then once in one session?
January 11, 2011 at 12:20 pm
vbscript is not secure enough, but powershell has it's dangerous too.
i think that doing it in PowerShell is better, if you start from Zero, beacuse it's being added more abilities...
November 8, 2010 at 8:56 am
Geoff A (11/8/2010)
renasoursou, try this;create an alias for RLDB2,4949\RLDB2_05 and call it something like "monitor"
then change Data Source=RLDB2,4949\RLDB2_05 to Data Source=monitor
how/where do you define this alias?
November 8, 2010 at 5:42 am
you have problem with the WMI object, not with the DB.
what did you change with the code?
query = "Select * from __InstanceCreationEvent" _
& " " & "where TargetInstance isa...
November 8, 2010 at 5:29 am
the problem that newbie got, isn't related to the DB, rather to the query of the wmi object.
November 8, 2010 at 5:24 am
since the DB is required to make it work, the script would have to include some logic to handle itself if the DB was not avaialble.
this logic should run...
November 8, 2010 at 5:22 am
the only thing that i whould change, is running the vbs from windows schedule task and not from the sql server, i think it's more correct way.
This will give you...
November 8, 2010 at 1:15 am
i get PAGEIOLATCH_SH,
what execlly this means?
August 18, 2010 at 5:57 am
SSC-Addicted thanks
1 more question
how do i take the FG offline as you mentioned?
June 18, 2010 at 4:15 am
Viewing 15 posts - 16 through 30 (of 79 total)