+1

what is .mpmp format?

It would be advisable to create the code and than execute it so that you can have more control. If you directly performing chang in your code it happens in...

If you feel that Transaction log is filling quickly and would like to find out the issue...

1. You can start SQL Server trace for the specific database to find...

By executing following command:

ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb1', SIZE = 5120000KB, FILEGROWTH = 1024000KB, FILENAME = '<path>\tempdb1.ndf' )

GO

Yes, you can add secondary file(.ndf) to tempdb.

Easy one, thanks Steve.

+1

You can have trusted domain. If not possible you can BCP/SSIS to CSV file, transfer file to destination location and do BCP/SSIS in.

Execute following command to find the status:

select name, page_verify_option_desc from sys.databases

There is nothing to do with database restore and Tempdb growth. Tempdb is used for the different purpose; check BOL.

Thank you, Steve. Easy One.

Good One!

How about creating VIEW? will it work?

Refer following link for the query:

http://stackoverflow.com/questions/20085249/import-excel-spreadsheet-data-to-an-existing-sql-table