Nice

What I wanted you to do is simply:

BACKUP LOG [dbname] TO DISK='NULL'

Then do the shrink

dbcc shrinkfile ('TLOGFILENAME', yoursize) -- where yoursize is a number in MB

Cheers!

DBA without Local admin rights ... Been there

The right answer is "it depends" ... If you have SLAs that are tight and a...

It just happens to be the one posted above you

You can do it in a user defined function, not necessarily a trigger.

schema_option must contain bit 0x04 "ON"

Dual core is *NOT* the problem HT *IS*

Can you confirm that you can "READ" *AND* not "WRITE" ?

Note that my page says at the end:

©1988-2004 Microsoft Corporation. All Rights Reserved.

and your page says:

©1988-2000 Microsoft Corporation. All Rights Reserved.

Cheers,

By the way If that is the case use the tool in the kb below to verify you can go through

http://support.microsoft.com/kb/306843

I have to...

The reason I asked is that when you use OPENDATASOURCE or OPENROWSET to "read" (SELECT statement only) you *don't* start a distributed transaction. Which is *not* the case when you...

I would expect "denylogin" = 0 and "hasaccess" = 1

Joining to a view has some repercusions but for your info SQL Server "expands" the views by default and tries to come up with a plan. Problem is that "usually"...

Correct!

Just leave out all those calls to sp_OA* procedures

You only need pure TSQL

Good Luck!

I am using the Latest BOL for SQL Server 2000... I hope