I use the bitwise and operator (&) to pull the status column apart for inspection.

For example:

SELECT

name

FROM

master..sysdatabases

WHERE...

Are you sure want the package to fail? I generally want to set aside the bad data with its error messages and then deal with the exceptions.

That way I can...

I think that the problem might simply be the NOT EXISTS. I converted a SQL Server 2000 database to 2005 shortly after 2005 was released and ran into a huge...

I do what Tim does. All that malarky with SSIS and MP. Way too much...

Steve Jones - Editor (8/23/2009)

---

Note that the import/export wizard could help you here, either with moving the data to some flat file, or even moving it to a new database...

Andeavour (8/24/2009)

---

There's also a handy add-on for Firefox that allows you to synchronise your bookmarks between different machines running the browser (I think it's called XA). That's been great for...

MS OneNote is great but confined to your computer unless you have a Windows Mobile phone.

I used to use Google Notebook for this sort of thing. Unfortunately, Google are...

The thing that ticks me off the most is the lack of ability to debug a stored procedure without the full Visual Studio 2005 Professional (i.e. not the lightweight version...

You won't find one. I looked also.

You don't tell us what exactly you want to do (transactional or merge, I'm presuming you are not talking about snapshot) nor the actual...

What do you mean by "bonded"?

As for the error which is the subject of the editorial, my guess based on past experience is that there was too much expected with...

There is one sentence you will never see on a tombstone nor ever uttered as someone's last words:

I wish I had spent more time at the office!

The trouble is that...

Thank you for the response. Yet another example of the documentation leading me astray 🙂

Thanks, I will give it a try anyway.

It will work, I suppose, but I haven't tested it. The preferential configuration would be to only have one publisher and the other two servers as subscribers. In the configuration...

Cláudia,

I'm sorry but there isn't enough information here.

The simplest way would be to route between the two networks but I'm guessing that you have reasons for not doing that...