what happens when setting up the connection in ftp connection manager and you click test connection?

yep or check sys.database_files for the name and compare to your mdf.

i had size issues with temp db too, it was down to the application using alot of temp. tables.

im sure that there is a Server Memory Change event class (tick all events when in profiler)

maybe use full text searching?

look on Microsoft's website they have a white paper comparing SQL Server to Mysql.

Also exclude Full-Text catalog files

you made the suggested changes as indicated by SQLBuddy and still experience the issue??

When following design best practices i usually try a normalise my database solution.

so basically i try and follow:

table should have an identifier

table should store only data for a single type...

I think that the default behavior is that sql will perform a sample scan on the target table or indexed view. SQL Server automatically computes the required sample size, and...

If i am reading your question correctly i believe it will update the stats for all the indexes for the table in question

i.e. ( testcustomerdetails table)

use < DB>

GO

UPDATE STATISTICS test.testcustomerdetails;

GO

Sorry...

If it is a SID issue then use ALTER user or sp_change_users_login 'auto_fix'

yes dont forget to read up on Resource Governor!

Thats true, then the other way is to use the alter user command.

This can be used to repair orphaned users and works for both Windows and SQL Server logins

i would use backup and restore especially if you dont want much downtime then make sure orphaned logins are fixed.