Kerobin,

I sent a note to Idera on this and hopefully they will respond soon.

Shyam, there are a number of security changes to make SQL Server 2005 more secure. This behavior is probably one of them.

I tend to agree with Mike on this one. Don't want to have people use "unlimited roaming", don't sell it. Or at least don't complain that you're losing money on...

Maybe that's how you get 6000 posts: paste!

Norene has a good point.

Let's hope that these "problem customers" were in fact abusing their right to complain.

I think if you've had some experience and study to get the SQL cert, junior DBA is a job you should apply for. Don't forget that many people ask for...

I think that was in humor as well, or I hope so.

The problem is what is a "promise?" In most of my dealings, if someone asks me if I can...

No idea on Sp3. They are releasing rollups post SP2 about every other month.

There's a rollup from last week that's post SP2. Test and apply that.

There are a variety of tools from Idera and Quest, but they usually need some customizing from you.

I've tended to roll my own since many of these tools end up...

If you're paging, then you can do

select top 25 clientname from tbl order by clientname

for the first page. You can add a WHERE clause ot limit things as needed....

The licensing has changed since the OP, and so that's not an problem. Honestly it seems that people have issues they post about managing the multiple instances. You definitely need...

Which login is the user under Databsae->User mapped to? This does not have to match the Security->Login names at all.

Is field1 AND field2 indexed? The ORDER by requires a tempdb operation, as does the TOP 100. If they're indexed, then the optimizer can easily shortcut the first matching 100...

Also, which field is salary? It seems like you want to compare the first number and the second number at different places.

Maybe you can tell us what you are...