Can someone provide a cite to the recommendation to set a maximum memory limit please, that's a new one on me.

SAs and DBAs should both be involved in/be required to sign off on/approve any change to a production database server.

The SA and DBA role are actually very complementary...

The behavior you're seeing is pretty normal for a SQL 2005 instance not configured to use a minimum/maximum amount of memory. SQL 2005 "self-tunes" and will raise and lower...

Given that it's been a couple of days since you posted this issue it's likely that you're going to need to restart SQL Server if you're still in rollback -...

What kind of linked servers? Other SQL Servers, Oracle?

Assuming that your text field contains some sort of delimiter it should be possible to seperate the text into seperate lines either in SQL or in your .ASPX page. ...

There are quite a few possible gotchas in the migration from SQL 2000 to SQL 2005, and a few more when you go from 32 to 64 bit.

The SQL 2005...

Why Excel? Take a flier at learning how to do it in .Net... if you don't already have Visual Studio you can pick your flavor to download on trial...

Sounds to me like a perfect use for a web page with a data caching mechanism built in - just expire the cache every second and force a client refresh...

What is different about the new databases you've attached?

Do the new databases have substantially more data than the previous databases?

Also check and see if your new...

Is reporting services on the same server or a different server from SQL?

Sounds like you've got to do some DNS work - with the servers in different domains, etc. it's no wonder that you have to use an IP address to connect...

Search for SQL Server Linux on google and it will show up. Please note the date on the "announcement", 4/1/2005 - April fools.

By the way, some time ago there were "announcements" from Microsoft that appeared here and elsewhere that MS would be porting SQL Server to Linux - please note the date...

Karthik -

Your sample code is a good start, basically what you're trying to do is avoid bringing a whole lot of data down to the client for further processing if...