I usually just reindex when page count > 9999

Win 32bit STANDARD can only use 4Gb RAM maximum. To use more than this you would need to install Enterprise Edition.

To allow SQL Server to access this extra memory available...

Double post

It's woth checking that you can see the remote tables via Enterprise Manager.

Expand Security, Linked Servers, then the link you have created and select tables. If your link is working...

Just tested this and it works.

You will have to detach the database first using sp_detach_db ''

Then run

sp_attach_single_file_db '', ''

You will get a message saying that the file name of the...

Hi

Did some digging and found the command: -

sp_attach_single_file_db

Did a check in Books Online and it looks like it may work, although i haven;t...

Hi Yelena

Thanks for the update.

To be honest, i forgot about using the windows event log

However, it would stil be handy for the...