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

I didn't have any issues with it during beta testing. Haven't installed it on a production box yet, though.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

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

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

W32.Cblade.Worm

http://securityresponse.symantec.com/avcenter/venc/data/w32.cblade.worm.html

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

quote:

---

It is just extremely slow when I say select * from table or go to Enterprise Manager and do Open All Rows...

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

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

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

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

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

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

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

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

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

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

Is it not working for any machine which you specify using UNC or just a specific one?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

DBCC DBREINDEX(), if no index is specified, will reindex all the indexes for the given table.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/