As Graham alrady wrote, it's the OS which determines how much memeory SQL Server Standard Edit. can use. Also on a 32-bit OS you need to use AWE and 3/gb,...

This seems to be some kind of bug and you're not the first one to encouter this.

Try the folowing:

Check if the database compatibility level is 90.

Run sp_updatestats. Statistics were invalidated...

Thomas,

I'm a bit confused. What do you mean with "a database which originally was created in the master database." You cannot create a database inside another database.

How do you restore?...

Not sure if this is the problem, but shouldn't it be DataTypeCompatibility=90 ?

Markus

Chris,

you need to register the servers. In the registered servers pane you should then see your instances.

If you don't see the registered servers pane use Ctrl+Alt+G.

Markus

Sean,

I haven't used 64-bit standard edition only Enterprise Edit.

We had no issues running it side by side with 32-bit SQL 2000, but I remember one issue with linked servers from...

Sean,

a inplace upgrade from a 32-bit Edition to a 64-bit edition is not possible. You need to install a new instance and when copy your databases, logins, jobs etc. to...

What about converting it into a XML document and when store it as xml datatype ?

Markus

Sorry but the question is about database snapshots not snapshot isolation level. and from BOL "Database snapshots are available only in the Enterprise Edition of Microsoft SQL Server 2005. "

Brij,

reading your post I wonder why you "need" to do partitioning. If your not even sure if it's benefical, why you're so sure you need it?

Trying to answer your questions

1)...

Mario

no need to worry about this. Some applications need specific cnfiguration settings. That's why they issue a sp_configure statement each time they run, just to make sure the setting is...

Chris,

before you install SQL 2005, you shuld define which parts of 2005 you will need. I did some large migrations and most of the time we choose only to install...

Mark

as far as I know this is exactly the case. Building up the grid takes a lot longer than results in text. The 3 ms is the real execution time....

If you read the article carefully you see that it's based on Beta2. A lot of things which there working in Beta 2 didn't work in RTM. So I assume...

Hi Randolph,

I had the same problem a while ago. Check out this link:

http://support.microsoft.com/?id=906954

Running   instcat.sql which is included in SP4 for SQL 2000 solves the problem.

Markus