You can use Export/Import Wizard to achieve this task. You can also use bcp to achieve this.

can also try: select * into new_table from old_table

Please try to run the select statement on the table filtering on the column missing statistics and sql should automatically create statistics.

Did you try to use sqlcmd or any other client tool apart from SSMS? do they work? any alias created for the sqlserver name?

I haven't tried this but have you looked for an option of formatting the date before it pulls into drop down something with expression like: "=Format(Now(), "MM/dd/yyyy")"

Agreed on xp_cmdshell. The very simple procedure is outlined here.

http://blogs.msdn.com/b/varund/archive/2009/06/04/backup-sql-server-database-to-a-share-drive-on-another-server.aspx

Does the sql server agent service account has full permissions on that network location?

You should be. Both editions are compatible with Windows 7. Also, please see if it helps: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/24a76770-f6e1-4de9-a262-476b04f7e975/targeting-sql-server-2008-or-2008-r2-with-sql-server-2012

why not using Indexed Views functionality?

Have you looked into network traffic/ traces during the time of the issue?

Did you get a chance to look into this: http://support.microsoft.com/kb/969845

So My understanding is below, Please correct me if its wrong, or if I am missing anything, so can review further

1. You select an ID from a list (let's say...

Yeah that's right! you may have to change that. You can get the hashed value but not the actual password. Need to be secure & safe 🙂

Are you using a table and saying that it's a single value displayed again? Can you please elaborate further with a design view/example.

It entirely depends on the code that you have as to how much can be reused, but you may want to explore the use of functions and calling those functions...

Did you check this?

http://www.mssqltips.com/sqlservertip/2624/script-to-find-and-drop-all-orphaned-users-in-all-sql-server-databases/