Viewing 12 posts - 106 through 117 (of 117 total)
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...
October 14, 2004 at 8:58 am
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...
August 26, 2004 at 2:37 pm
I am encountering the same problem with MSDE 2000 Sp3. I have not discovered a fix for it yet.
August 26, 2004 at 1:38 pm
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...
August 18, 2004 at 6:40 am
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...
August 12, 2004 at 7:00 am
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...
June 7, 2004 at 6:40 am
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
June 1, 2004 at 2:39 pm
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...
May 5, 2004 at 10:04 am
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...
April 8, 2004 at 6:17 am
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.
April 7, 2004 at 2:08 pm
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.
March 5, 2004 at 6:38 am
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...
February 27, 2004 at 9:03 am