create table #temp1

(col1 nvarchar(10))

insert into #temp1

select 1

union all

select 100

union all

select 1001

union all

select 20

union all

select 500

select * from #temp1 order by cast(col1 as int)

** this wud run only if col1 has...

i'm not sure abt coldfusion. all i know, each connection will initiate a user session at DB level. IF u've 10 browsers each connecting to the db, there will be...

delete from nbdocdeletedrecords where replicationID in (

select min(replicationID) from nbdocdeletedrecords

group by towid

having count(*)>1

)

** ReplicationID is primary Key

**deleting based on towid... min(replicationID)

Hmmm... never tried that buddy. was browsing through Microsoft's web-sites and found few links.

2000 BOL

When awe enabled is set to 1, AWE memory is used, and the instance can access...

That depends on the max limit you've set on ur database which should be less than or equal to the max limit set by Microsoft. It keeps on adding and...

?

1.

your first query doesnt contain username condition

and username = 'SQLKofc'

2. is towID primary key on the table? OR can it...

do u mean u have five flat files corresponding to five tables into which u want to load the data?

If yes, do u also mean that u're constantly adding records...

This part of the query is culprit.

You just need to omit this condition. I guess u need...

Session - You write a query in a query window in SSMS, that's a connection to the server and a...

Just a point to make.

If You're using Create table #myTempTable (), it'd be dropped automatically when the session that created it is terminated.

If you're using SELECT * INTO #myTempTable...

Thanks for correcting Gail :). Actually i meant what you've written. was a slip off :w00t:

What is the frequency with which u're taking transaction log backup vis-a-vis transaction volume?

try reducing the frequency of tran log backups. this will flush out inactive transaction more frequently from...

That link is from BOL(SQL Server 2005 Books Online) and not an internet url.

Refer to following URLs

http://msdn.microsoft.com/en-us/library/ms186865.aspx

http://technet.microsoft.com/en-us/library/ms191495.aspx

btw i never mailed you!!

Incidently i too got that error when i tried to fire some queries after restoring DBs. i ran my query again and didnt get the error again 😉