That's great. Thanks very much.

Hi and thanks for your reply.

I did look at Google Maps API recently for another thing - but it hurt my head - getting too old to learn new stuff....

Hi, sorry to bump this ... will using the Import / Export wizard maintain relationships? I don't think it will - so can anyone tell me the best/easiest way to...

Thanks for your reply. The tables already exist in the UAT database. When I import...

Thanks for the replies. I don't have a tool to do the copying - this is one of the things I need to find out - what is the best...

Can you mark posts as resolved on this forum?

GSquared - thanks very much for that - it does exactly what I need.

Wayne, thanks for your reply. I keep reading about the benefits of a tally table but have...

After a good few years doing classic ASP development, using, of course, lots of javascript to enhance the user experience - and doing a few other projects in VB6 -...

Again, thanks very much for your help. I'll give that a try.

I'm wondering if there a way to strip out all html tags but leave in ones that begin with...

Hi, and thank you for your reply.

I ran 'Select TextPlain FROM DistListEmailTbl' and looked at it in Text View. The text looked like this:

Dear Committee Member,

We'd like to invite you...

Found the answer - Edit | Intellisense | Refresh Local Cache - did the trick.

Thanks for your replies.

I want to copy the database from Server A to Server B.

On Server A it is a Sql Server 2000 Database.

I manage it using SQL Server Enterprise...

Thanks for your replies. Guess I'll do it in the front end.

Hi and thanks for your reply.

I'm just being lazy - I haven't bothered to create database diagrams in the Live and UAT servers - and figure it's about time I...

Thanks again for your help.

I'm trying to replace the hard coded stuff with dynamic SQL at the moment.