Viewing 15 posts - 5,971 through 5,985 (of 6,105 total)
What you are most likely going to have to do is
DECLARE @result int
EXEC @result = master.dbo.xp_cmdshell '<command line>'
or something similar and test @result. That's the only way to get the...
December 5, 2001 at 12:21 pm
Wow. Though I'm not surprised, I guess. I understand why Microsoft probably didn't send anything about it because they don't consider it a security vulnerability (assuming everyone would...
December 5, 2001 at 12:15 pm
I didn't have any issues with it during beta testing. Haven't installed it on a production box yet, though.
K. Brian Kelley
December 4, 2001 at 3:06 pm
SELECT C.*
FROM INFORMATION_SCHEMA.Columns C
JOIN INFORMATION_SCHEMA.Tables T
ON C.Table_Schema = T.Table_Schema
AND C.Table_Name = T.Table_Name
WHERE T.Table_Type = 'BASE TABLE'
K. Brian Kelley
December 4, 2001 at 2:18 pm
W32.Cblade.Worm
http://securityresponse.symantec.com/avcenter/venc/data/w32.cblade.worm.html
K. Brian Kelley
December 4, 2001 at 1:59 pm
quote:
It is just extremely slow when I say select * from table or go to Enterprise Manager and do Open All Rows...
December 1, 2001 at 12:10 pm
This Q article talks about how to run rebuildm in a clustered SQL 2K environment:
http://support.microsoft.com/support/kb/articles/q298/5/68.ASP
Once that's done, restore from backup.
K. Brian Kelley
November 28, 2001 at 4:11 pm
In our case we have mainframe extracts that can show up anywhere from 3AM to 7AM and so what we do is ship a "tickler" or "flag" file last. ...
November 28, 2001 at 4:07 pm
Whenever a job runs, it runs in the context of the user account the SQLServerAgent service runs under. Which means if you run under the Local System account, you...
November 28, 2001 at 1:34 pm
SQL2K supports SSL and SQL7 had multiprotocol for encryption, provided client and server both are configured correctly, but Steve's right. There are a ton of relatively secure, easy to...
November 28, 2001 at 1:04 pm
BOL only has the following:
Error 208
Severity Level 16
Message Text
Invalid object name '%.*ls'.
And a brief description... but it only talks about trying to reference a temp table that was created using...
November 28, 2001 at 12:59 pm
This Q article might be of some assistance as far as opening up the firewall only as much as needed:
http://support.microsoft.com/support/kb/articles/Q287/9/32.ASP
K. Brian Kelley
November 28, 2001 at 12:49 pm
Hi Hendra,
As Paul said, to specifically respond to your problem, we do need more information. However, there are general books on the subject if you are looking for a...
November 28, 2001 at 12:38 pm
Service Pack deployment is probably the biggest bear.
We manage somewhere in the neighborhood of 40-50 SQL Servers where I work. We've built some simple custom utilities to...
November 28, 2001 at 12:33 pm
Is it not working for any machine which you specify using UNC or just a specific one?
K. Brian Kelley
November 28, 2001 at 12:21 pm
Viewing 15 posts - 5,971 through 5,985 (of 6,105 total)