It depends on the functionality you are looking for. If you trying to find all records where partcode starts with, contains, or ends with some value, then the LIKE operator...

Have you run this code? If so, what error did you receive? The error will at least give us a general idea of what to look at. At first glance...

If you do decide to use replication, I beleive that if you delete out records from the publisher, that deletion will be replicated to the subscriber. 

I am in agreement with...

I would use a partitioned view.

For example, if you have 10 databases with a table called customersales for example, you can put a contraint on the customerid in each...

My first exposure to SQL Server was 6 years ago. I started out my IT career as a hardware/network guy who also worked as the company webmaster. While investigating ways...

"Procrastination will get me nowhere." My wife said that over the hollidays in reference to going out to pickup some last minute gifts.

Cliff

We have not done this as of yet. We had our data vendor supply the currency conversions on a monthly basis for us as that was the easiest. A quick...

I beleive the MCDBA will become obsolete early next year. They are being replaced with new exams from Microsoft. Here is a link for more information on the new layout.

http://www.microsoft.com/learning/mcp/newgen/

You can...

Adding on to what MG says, you can schedule a job to kick off the package every minutes if you want around the clock processing. It's the same technique we...

When printing out the SQL statements, CHAR(10) does indeed make it easier to read. Maintenance on any sproc that uses dynamic sql however, depends on the complexity of the code.

From...

If you are just doing staight imports of data without and sort of transformation or applying business rules to the data you are transfering, there is no need to use...

What's happening is one or more of the columns you are trying to filter on a character columns and you are generating the dynamic sql as if all the parameters...

Is there a reason a workflow from the SQL Task to an ActiveXTask will not work? That would be the simplest solution.

I would recommend keeping at least one SQL 2000 server to support your clients who are still on that platform. Some people may not upgrade for quite a while and it...

What does the target table look like?

What is your mapping from text to table?

Can we see a few sample rows of data?