My understanding of CALs they are assigned to individuals.  So you need to get a list of individuals that can access a database on a server either directly or through...

A registry entry needs to be added.  I copied the post from another site.  Here it is.

This is a known issue and is logged as bug #364064.  We don't currently...

I am encountering the same problem with MSDE 2000 Sp3.  I have not discovered a fix for it yet.

SP_SPACEUSED does report incorrect results.  To correct the results you could execute it with the update option enabled

sp_spaceused @updateusage = 'TRUE'

It does generate locks in the database so only run...

Here is a SQL Script I use to truncate tables.  If the tables have foreign keys you will need to use DELETE instead of Truncate.

/* This routine delete all rows...

User's are unable to create anything in Master.   When I use the term user stored procedures, I'm referrering to stored procedures other than System stored procedures.

I just don't get why...

I found the answer I needed.

The traceon command needed the value -1 added to it

To set trace

dbcc traceon (1204, 3605, -1)

To query trace through another connection

dbcc tracestatus(-1)

The linked server is a cluster.  I thought we where using TCP/IP but I will need to verify. I have no problem registering any of the servers.

We are using the linked...

I agree it should work.

I am logged onto S1.  When S1 is setup for Windows Only authority, I can access tables on S2.  But when S1 is setup with SQL...

I get the error when I run it from the local copy of developer edition and when I am connected to servers with linked servers.

A technique we've been using instead of a global variables is to store the date in another table and then change the date in that table when we need to.

example:

DELETE...

I did some playing around and found when I specified a constraint name when creating the foreign key or primary key.  Enterprise Manager would generate the SQL with the constraint...