Was that poster who provided the freeproc solution being sarcastic or was that genuine advice?

Take a look at the four convert scripts here. Maybe this will explain the issue you are facing.

Select Convert(char(100),0x526564,0)

Select convert(varbinary(20),'Red',0)

Select convert(varbinary(20),0x526564,0)

Select convert(varbinary(20),'0x526564',0)

The first two are regular converts. Take a look...

sysreplication alerts table in the MSDB get written with all the errors and warnings. You can use that table to do some custom messaging for alerts. That is what I...

Hey Congrats Lynn... 🙂

About setting up a meeting place, I had one place in mind where you walk 100 mts from the meeting place, you go right to the beach....

It is in the Publication/Properties/Subscription Options. Or as the script says @replicate_ddl = 1.

But by default the setting should be true. That is enabled. I wonder why it is disabled...

Here is a small piece of advice. Which ever method you choose to do, first test it on a testing environment. You can use your script that you put. That...

In SQL 2005, you can modify tables that are being replicated. For this first you will have to change the publication properties for Replicate Schema Changes to TRUE. Once that...

Good One jason... No Cursors.. 🙂

I could use that script as well...

Hi There,

Got couple of questions before anyone can give any good info..

1. What kid of replication do you have?

2. You state that you have some code in the message. Cant...

I am a poor guy... Not a multi millionaire like others... 😛

How about SQL Server Central sponsoring some people?? 😉

Ok..I am hooked...What does it depend on?

Thanks for giving me a count on the number of attendees for SQL Saturday.

A theoretical question....

If a SQL Saturday was arranged in our tiny island of Curacao, Would any...

Of Topic...

On an average how many people attend SQLSaturdays?

It depends.

1. Depends on the activity of the databases

2. Depends where the Distributor is

3. Depends on how many distribution DB you have

There are more.. 🙂

There is no way to...

From what I read, I do not think it has happened in their environment. It was a theoretical question raised by the Project manager/Interviewer.

Lots of reason for the Subscriber...