use DATABASEPROPERTYEX( database , property )

for example select convert(sysname,DatabasePropertyEx('MyDB','Collation'))

see BOL

Bye

Gabor

Here is one of the solutions:

selectWorkOrderLot.LotID,

TravelerLot.TravLotID,

Process.ProcNum

FROMTravelerLot INNER JOIN WorkOrderLot ON TravelerLot.LotID = WorkOrderLot.LotID

JOIN Process ON TravelerLot.CurrentProcID = Process.ProcessID

JOIN (selectLotID,

min(ProcNum) as ProcNum

fromProcess JOIN TravelerLot ON TravelerLot.CurrentProcID = Process.ProcessID

group

byLotID) as MinProcs...

I never grant anything to the base tables.

No user can execute any query against the base tables.

Only via SP or sometimes throu views.

The maintenance is much easier.

When the developers change...

I've started with Sybase 4.2 after I've migrated several sites to MS SQL Server 6.0 but I do not remember to have a limit of 5 text columns in 4.2.

Bye

Gabor

I tend to agree Frank.

I hope you will never get even close to this theoritical limit otherwise your index maitenance jobs will be interresing and soooo loooong

Only adding files to the tempdb log won't help you too much.

Considere the followings:

• The tempdb should reside on the fast disk drives on RAID1 or RAID10 and definitly not...

Fragmentation is definitly using more space (and therefore hinder the performance)

If you want to insert a new row to a page and there is not enough free space to store...

Interesting issue.

My values are:

TempDB current

Insert 64K recs into #Temp in 220ms

Insert 64K recs into local Test64KInsertTemp in 216ms

Insert 64K recs into #Temp2 from #Temp in 173ms

Insert 64K recs into local...

But do not forget that the simple recovery mode is using a full logging but afterwards on checkpoint it is "autotruncating" itself.

In a bulk logged recovery mode BCP, bulk inserts,...

But you still need a transaction because of the usage of the generated number, let's say an invoice.

begin tran

get new invoice number

insert data into invoice table

insert data into invoice details...

Lot of questions outta there

As far as I know SQL Server is using only the actual size of the varchar data (with some extra bytes to...

To see the log space usage you can use dbcc sqlperf (logspace)

sp_spaceused reports only the data and index space usage (in the reserved, data, index and unused columns) and this...

But anyhow! Yukon, once available, will have (Endlich!) a separate date and time datatype.

Bye

Gabor

Unfortunatly you are not right.

Even the tempdb logs.

You have (at least) 2 possibilities

• BCP out the data you want to keep, then truncate the table, after BCP in the data....

create table Test_Results

(Equip_ID int,

A_Test_Result varchar(50),

Test_Date datetime)

insert into Test_Results values (1, 'test11', getdate())

insert into Test_Results values (1, 'test12', getdate())

insert into Test_Results values (2, 'test21', getdate())

insert into Test_Results values...