If looks as if you need a grouped report similar to this

BrandURL

Alain Mikli http://www.800.com

•800http://www.800.com

•Sunglasses

Additional info...

I've looked through articles and confirmed it does not exist.

I dropped and recreated the subscription.

Based on sp_addarticle I'm thinking that the call to sp_MSdrop_article is occuring inside sys.sp_MSrepl_addarticle.

This...

So are you saying I can ignore this message:

Contract DEFAULT is not bound to service //TgtDB/Test/TargetService ???

Why would you want SQL 2000? It was removed from mainline support over a year ago?

Try the 2005 Express version http://www.microsoft.com/downloadS/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en

or 2008 Express version at

Is it possible to combine the databases into a single database with different schemas?

scehma1.table1 references schema2.table. This is a solution I used when migrating Sybase databases to SQL Server and...

Praveen, I can provide or point you to several white papers on MySQL to SQL Server migrations not the other way around. I suggest you look in a MySQL forum.

How about granting exec to the user?

Such as grant exec on {stored proc name} to {X}

DAB

Glad I could help

DAB

Then try

DELETE from License_Table

where license_date between '2008-11-15' and '2008-11-16'

DAB

bpowers (11/20/2008)

---

I have a couple of rows in my test table I would like to delete based on a date. However, I can not seem to get the syntax right...

Use RECONFIGURE WITH OVERRIDE

DAB

Yes it does...

strContains = split( "cats dogs mice fish") will return an array of 4 values

strContains(0) = "cats", etc.

In addition, you can specify different delimiter values (the above...

Since you're using VBScript, why not use the Split() function?

DAB

As far as I can tell there is little difference between these two statements:

Select * from myTable where textField like '%Cats and Dogs%'

Select * from myTable where CONTAINS(textField, '"Cats and...

Exactly Jeff! I've had a db start to grow in the middle of the day during peak web traffic and it brought everything to a crawl until the growth completed....