Unless the SQL Server instance is running under your account you need to check to ensure that it has rights to the directory in question.

You just need to use brackets around your database name so bcp doesn't parse the "-" as a parameter.

bcp [bbc-nortal_d].tnt.empt out c:\shasha\empt.bcp -n -Utnt -Ptnt

should do it...

You are certainly missing something.  

The db_dbOwner group does not give actual ownership of the database nor of any particular objects to its members.  It does give most ownership rights so...

It all depends on who owns the table(s) being referenced by the stored procedure.  If you have dbo.table1 being referenced by the owner1.usp_get_data proc this creates an Ownership Chain.  Regardless...

What does your disk space look like?

First off it will require a window of time that your application will be offline.  The question really is how long?  The simplest method is to shut down the application,...

I think you are in for some pain...  With 800 tables you might want to invest the time to create some SQL generating SQL to create the statements necessary. 

But...

There are several ways to see what the definition of a foreign key is, but my preferred method is to open up Query Analyzer, in the Object Explorer pane expand...

Oh yeah, just to directly answer your question...  Since sort order is part of the collation, everything I and noeld said about collations is true about sort order.

First off you need to realize that the collation affects only non-unicode character columns with the exception of sort order.  The sort order specified in your collation applies to both unicode...

what you are seeing are the statistics that SQL Server creates automatically.

The database design should not be affected by SOA or any other system architecture.  The database should reflect the meaning of the data that it stores.  The arcitecture chosen to...

If you are going to wipe and rebuild the server just make sure that you have good backups of all your user databases plus the msdb database.  Use the scripts...

To answer your specific question, yes, you can restore a database of whatever collation to a server with whatever default collation.  With SQL 2000 collation is actaully controlled down to...

If there is some sort of sequence required that is not supported by the data itself, as in this case, you will have to add a third column and use it...