What I don't like in Michael's query is this: "null as AuditXml". I would say that in this case SQL Server does not know what type is this field. I...

I would say that either the tables (PolicyProcessAudit2 and PolicyProcessAudit have different structures - one of columns in the first table is longer than column length in the other table,...

The log is hard to read. I suggest that you use the sp_lock procedure:

http://msdn2.microsoft.com/en-us/library/aa213025(SQL.80).aspx

The information is provided in a very clear way. Especially you have ObjectId and all...

I think that if you start Profiler, you will see the queries. Maybe Agent service is running some procedures in background. Or check whether you have any active jobs.

Such problems...

Tina,

Are you sure that the export works correctly? I heard about various errors caused by "queryout" parameter and I prefer rather to create a view and export the view with...

I cannot directly answer to your question but I have few remarks:

1. If you use such universal key generator table, sooner or later you will run into locks/deadlocks problem (it's...

I often work as an advisor on database tuning for various companies and from my experience the hardware was never an issue (although it's good to have top level hardware)....

In the meantime I checked that BCP import works fine with views with columns renamed from e.g.: [Desc] to [Tmp_Desc_Tmp] - so renaming columns in the database is not required....

Barry,

Thank for the hint with import view. In fact I'm exporting data by means of a view. In this case I don't even need to rename the 'Desc'. It is...

You may take a look at samples available on the Internet like:

http://www.databasejournal.com/features/mssql/article.php/3391761

or http://www.windowsitlibrary.com/Content/77/14/1.html (look at second page - there are examples there)

or directly to Microsoft...

Dli,

Data models for Purchase Order are well known and you don't need to reinvent it from scratch. I suggest that you start Google and type "Purchase Order Data Model" (and...

Jeff is right. If you start BCP at 5:00PM on Friday, you will get the job done in 10 minutes (so you can still have few beers in the evening)....

You may consider the SqlBulkCopy class from .Net Framework 2.0:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

older version of the same: SQL-DMO objects,

or just simple INSERT statement (INSERT INTO ... SELECT * from linked_server_table).

In...

It's because the servers have collation set up in a different way; on one server it's on server level, and on the other it's on database level. And also something...

In the first version I was using native format but than I found out that national charactes are not transferred correctly despite the fact that I provided correct code page....