Only thing I could recollect is to run the following command.

Select [NAME] ,DATABASE_ID from Master.sys.databases where [Name] like '%$%TempDB'

If the command returns any rows, then it would be an...

Have you searched Google for "Linked Server in SQL Server" ? I guess you will get plenty of links to read...

You are welcome !

Don't jump into conclusion that the problem is caused by McAfee Anti Virus, it may be one of the reasons.

Check with your systems engineer if they have exceptions enabled on...

Ray is right. You would be getting 44.9 rather than 44.8

Start with this.

select ROUND(44.8730084,1) -- gives 44.9000000 as output

Or try this way.

declare @val float;

set @val = 44.8730084

select ROUND(@val,1,1) --...

GilaMonster (12/28/2009)

Not a game though. A new controller (motion sensor, face recognition, etc) for...

Thinking about games remind me of this fantastic one from Microsoft, it's called Project Natal.

Look at the link below. If you haven't heard about it.

http://www.youtube.com/watch?v=HluWsMlfj68

Back to work..

GilaMonster (12/28/2009)

What is this 'console' you speak of? Just about all of my games are for...

I wonder how you guys get time to play these console games. 😛

I bought a PS3 and a dozen games during Thanksgiving weekend, haven't played a single game yet :w00t:

LOL 🙂 🙂

I guess you should be good with a single publication with all the tables.

Agree with Steve, you can't use Mirroring as a solution for this scenario.

To filter the data for each branch, you got to have individual publication for each branch filtering only...

Have you enabled lock page in Memory.

http://technet.microsoft.com/en-us/library/ms190730(SQL.90).aspx

I assume you are using 32 bit SQL Server. Have you seen the memory settings on the SQL Instance. Enable AWE and restart the instance.

Look at this Blog Enable AWE...