Surely the correct solution is to have a column for each number?

Using LIKE will be tricky as using the clause WHERE nums LIKE '%10%' will returns rows 3 and 6.

How...

Ignore this post, having a bad day!

Avoiding temp tables is a little hard as the SP's in question are several hundred lines long. They are honking great things.

All the DDL is at the top - so...

1) Why can't a small database not be placed on this server when SQLserver2000 is already on it?

It can, in fact many can.

2) If the databases are...

Jacob,

Creating a database in SQL Server can be as easy as creating one in Access. If you are familiar with the client tools that are part of SQL Server (Enterprise...

DTS results to text file on managers desktop?

Alternatively, xp_SendMail - results delivered to your inbox

The way to do this is by using the sp_executesql stored procedure. It has one main input variable, and that is the actual statement you want to run, all you...

Ok, have looked - there is nothing to remove - there are no other files.

I dont think there are, how would I check for, and delete these?

Nicholas,

I tried your method - however, after the snapshot agent has finished, the Distribution agent stops with an error: Log on failed for 'sa'

Any ideas?

Nicholas,

Thank you for your reply - I have never scripted replication before, how should I do this?

I am having a really bad day - forget any of this, I have solved it.

If there are any moderators viewing this, feel free to delete this thread altogether!!!!

Thank you.

Forget that - I am was having a dizzy moment. I have found it, but am now getting the following error whilst trying to debug:

OLE DB error trace [OLE/DB Provider...

It is something that we have looked at too, we have compared it to a few other similar SQL source control options. We have found that mssqlXpress is definately the...

Thats great thank you. What if the machines cannot be on at the same time (same names). Presumably go via a third server?