Viewing 15 posts - 5,971 through 5,985 (of 6,102 total)
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
DBCC DBREINDEX(), if no index is specified, will reindex all the indexes for the given table.
K. Brian Kelley
November 17, 2001 at 7:55 pm
I have to agree with Nigel on this one: it is a good thing for a DBA to be a control freak. It's not unusual for performance issues to...
November 14, 2001 at 7:50 am
Viewing 15 posts - 5,971 through 5,985 (of 6,102 total)