Hi Steve

It was via our partner#, I think its MS Professional Services and not enterprise which offers the 24x7 (from reading their site). I didnt winge too much with...

I would shrink during a quiet time (if there is any) for your DBMS, get a feel for the average times taken and move the times around from there.

As for...

Hi there

Experience tells me to manage it yourself in terms of shrinking (when it happens, what is going on and sync it with other jobs that may be going on)....

Great coverage of the topic, thanks for the article.

Hi

Uninstall 2000, install 7 as a default instance, then install 2000 overtop with named instances... all should work a treat. Note that there are some DTS designer issues managing...

Hi there

Try this from a MS script I have been using for some time that deals with an INI file...

set @i = 'C:\ActivityTrace.ini'

if exists (select * from dbo.sysobjects where id...

Thanks Antares686, your a champion! ill give the SQL a go, funny enough I was pondering the case inside of the join but didnt go through with it.

Cheers

Ck

Hi all

Microsoft has assigned bug #: 469546 to it for SS2k

This may be fixed in Yukon, doesnt get the error apparently, but returns the incorrect results.

Cheers

Ck

Hi Guys

Whats really strange is that the developer swears black and blue that he initially created select via query analyser with no issues, the only change since that faithful day...

Hi all

Here is another very basic test:

-- 3 levels (FAILS, BUT WORKS IN A CREATE VIEW statement and running it)

select

(select org_id

from

(select org_id

from (select org_id

from organisation...

Hi all

Following on with this..

If you wrapper the SQL in create view statement, it creates and runs perfectly.

If you wrapper the SQL in create procedure statement, it...

Hi there

I believe many SQL Server DBA's can leaver off the Oracle OFA (flexible architecture) in terms of structuring data/log and install directories for your SQL Server databases. Generally...

Hi Andy

I forgot all about them! 🙂 this should keep the analysts off my back for a while.

Cheers

Ck

Hi all

I believe the key is in dbcc page with the:

Allocation Status

-----------------

GAM (1:2) = ALLOCATED

GAM pages record what extents have been allocated. Each GAM covers 64,000 extents, or nearly...

From the http://www.transactsql.com site, great t-sql reference over the books online:

DBCC EXTENTINFO ('@dbname', '@tablename', @indid)

Example

--Display information about the extents in the authors table

--Clean up the display

SET NOCOUNT ON

--List information about...