You can use a windows domain account to access the file in the network share path so that you can avoid authentication problems with the shared file.

Correct me if i am wrong. Let me know why do u want to create an index and then immediately. i hope u have a non clustered index. you need...

If you need a DBA's book go for Microsoft Admin companion or Pocket consultant they are really really good books to start with.

My advice is to create a backup plan as per the business needs may be full db backup every day and that other backups as they need. then you can...

To the best of my knowledge. NO. Are they variable columns datatypes.?

You have the zip file containing the code there hope u have missed to see the file over there.

This below link does exactly what you need.

http://www.sqlmag.com/Article/ArticleID/38790/sql_server_38790.html

Log shipping will not be the solution for your case you need to go for snapshot replication with your conditions met using tsql.

Yes thats possible you can add an alert in you MP to say if that has got succeed or failed.

Instead of enabling SSMS in all client machines what you can do is find the appropriate port and then add that to the firewall list so that they don't get...

Check if this helps u.

http://technet.microsoft.com/en-us/library/ms191450.aspx

Din't you find anything with the error logs. they should have said something more than what youhave said here.

you can create a package and then call the package passing the file name and path *** input parameters. Also try using bulk insert option. There are other options too...

Though u give permissions to execute the sp directly only users with sysadmdin rights can use xp_cmdshell exclusively. Other wil get some or the other error.

You have to have ur sql server services running with the account that you are going to use for mail profile. then configure your mail profile and then add the...