On SQL Server 2000 CHECK CONSTRAINTS were enforced "BEFORE" the insert actually took place apparently on 2005+ there are issues with this as you have already verified. There are several...

If I were to get a penny for every problem I have been called to "solve" regarding "I forgot to highlight the WHERE clause (or part of it)" I...

ganeshmuthuvelu (1/13/2009)

---

The file is a fixed width fields. Each field is of length "1". For example, one line of the data file is like this:

A CDE

Notice the space between the...

And what is the problem with that ?

It is not if you can ping it, It is that your connection to the server is not "stable" for some reason. You should check the monitored server for load...

TRACEY (1/13/2009)

---

Just following along on the thread.

When setting up the linked server.

provstr 'Integrated security=SSPI"

SQL SERVER1 (Use domain\tracey)

MYFIRSTDB

...

What is the frequency of your Transaction log backups ?

I bet you are experiencing autogrows!

Be careful not to give the account that run that stored procedures more privileges than "read" or you still may be surprised! 😉

You should check two things.

1. Verify that the source data is actually NULL and not an empty string.

2. Verify that the destination column does NOT has a default value...

If you don't care about "fancy" features like Partitioning, Database Snashots, Online-index rebuilt among others you are probably fine.

Given the transaction rate you are posting "standard" maybe ok. How...

You are being NICE ... any table with 1000 columns is...

Follow the link I posted for tablediff or use our good old friend google, there are many articles on the web with examples on how to use tablediff.

From your...

MarkusB (1/13/2009)

---

Gaby A. (1/13/2009)

---

MarkusB (1/13/2009)

---

I just did some testing myself and even though I can't find anything in the official documentation it seems like the function get_sid() has been removed...

Linked SQL servers tend to not like ".." you should try the post above where it is correctly specified as ".dbo."

Something is killing your connection from the monitor. You should check the network and any other component that maybe doing that.