Viewing 7 posts - 1 through 7 (of 7 total)
I usually just reindex when page count > 9999
May 9, 2011 at 2:43 am
#1321585
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...
July 27, 2010 at 3:22 am
#1198600
Double post
July 27, 2010 at 3:20 am
#1198597
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...
September 24, 2008 at 4:40 am
#876214
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...
March 16, 2006 at 3:57 am
#626970
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...
March 16, 2006 at 3:46 am
#626969
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...
March 16, 2006 at 3:40 am
#626968