While the permissions assigned to public are absolutely atrocious, there are a couple of mitigating factors.

1) Unless the user is a member of db_ddladmin or db_owner, the user is only...

WITH ENCRYPTION works against everyone, including sysadmin level accounts. However, it's not very strong.

There's a script (I think there's a version in the script repository here) that is based off...

Not impersonate, no. But what you want to do, which is get information into DB2 from DB1, can be. With SP3 and cross-database ownership chains, it is possible. As long...

Keep in mind that this if the trigger is going to fire (don't know, may be same problem when dealing with CREATE TABLE and sysobjects), it'll fire when a user...

I haven't seen anything about that and you won't see it captured in Profiler. I concluded at least those three because they have information required for a new table.

K. Brian...

Well, the CREATE TABLE does a lot of things behind the scenes, so I wouldn't be surprised if it doesn't work in a typical INSERT fashion. Consider that sysobjects, sysindexes,...

Is the Windows account you are using to connect to SQL Server in the same domain (or a trusted domain) as the SQL Server itself?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Keep in mind that some of the system tables are really virtual. They are created for you on the fly when you query them. The system table syscurconfigs is one...

You have to install Analysis Services separately. One way to check is to look at your services (run services.msc from Start | Run). If you see MSSQLServerOLAPService, you have Analysis...

Okay, here goes with the standard Microsoft answer: Did you try reapplying the service pack? Perhaps something didn't get registered properly.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

What are the access times like from other applications?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Site Server is a real bear. I hated working with it. It never made it into production in our environment because it was just a royal mess to support. Any...

Unfortunately, SQL Slammer had spread so quickly, by the time anyone had definitions out, the devestation was done. Within 3 minutes, I think it was up to 55 million scans/sec...

That's extremely odd... I just tested and got what I expected in both master and Northwind: only the views. When you scan sysobjects (no WHERE clause), do the tables show...

Did some reading in microsoft.public.sqlserver.olap and some are having issues with SP3 and Analysis Services, though I don't see anyone mentioning the issue you cited. However, this is from the...