It's hard to say if that is normal without knowing what type of system your database supports and your environment. I can tell you what happens when I perform...

Generate scripts can be used to set up your table structure and copy any other objects needed such as stored procedures and functions. To move the data, I would...

Try using an actual share \\SERVER\SHARE\ and give the appropriate permissions to the share. I think using \\SERVER\C$ could be the problem.

Try moving the file local to the server. Put it on c:\import\ and see if it throws the same error. I think you are correct, it's not the...

Does the agent account (or the account running the agent job) have permissions to the directory? Is it on a file share that you only have access to?

SELECT ord.CustomerID, c.companyname, ord.Max_Shipped_Date

FROM

( Select CustomerID, max(ShippedDate) as Max_Shipped_Date

From Orders

Group by CustomerID

)ord

JOIN

Customers c ON ord.CustomerID = c.CustomerID

where c.Country='usa'

-- GROUP BY ord.CustomerID, c.CompanyName -- Error because your ord.Max_Ship_Date. I...

This article looks straight forward and even has an example procedure. Have you tried this?

http://support.microsoft.com/kb/283790

Check the permissions of the account running mirroring. Not 100% sure but should be the service account.

Change line:

FROM #DBFRAGMENT where ltrim(rtrim(#DBFRAGMENT.indexname))<> ''''' -- ADD A SINGLE QUOTE

To have another single quote. When I pasted this in an editor, the next line with the EXEC...

You may need to restart the SQL service. I get this error about once a month and restarting the service clears it.

These messages were going to my junk folder. For some reason they were not doing that before. This is a non-issue.

Try using dynamic SQL to concatinate the variable into your view. I assume you do not want the variable to be created as part of the view rather whatever...

Did not. Thanks for the post.

Ummm.... I had an error when processing this sql. That is the option I picked before I answered and decided to check it after I was wrong.

I just guessed. This one was way to much to think about.