As far as I'm aware the only way to achieve this is to drop and re-create the table. If the table has data then you'll need to create the...

I'm not entirely certain on what you're asking for here but I'll give it a go.

1. To find the [PO]# in the LogMessage column you could use the charindex...

Check the sort order/collation for your restored database and check it for your master database. It's possible you've installed SQL Server 2005 with a different collation to what you...

Try this:

select 3.0/4.0

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'MyProfile'

, @recipients = 'me@mydomain.com'

, @subject = 'subject text'

, @body = 'subject body'

, @query = 'select * from master.dbo.sysdatabases'

, @attach_query_result_as_file = 1

, @execute_query_database = 'master'

BTW, this is...

Is this stored procedure accessing the master or the msdb databases?

It seems strange that restoring the master and msdb database on sql 2000 fixed your problem, and it would suggest...

KATHLEEN Y ZHANG (3/28/2008)

---

Thanks Karl and Steve for the input!

If I would use merge replication, how tricky it is to set up and maintain and how robust it is?...

KATHLEEN Y ZHANG (3/28/2008)

---

We are an online retailer looking to expand our business to international market. Currently we have one single database that takes orders and process them. We are...

No problem. Glad I could help.

Mike Menser (3/28/2008)

---

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

Well I mean I knew that much, but I thought maybe there was a way to just...

Ian,

The first error I think is related to the create table statement you have at the top. There's a missing closing bracket there.

The substring error relates to the substring...

Sounds like it didn't really go as smoothly as you'd thought:cool:

If the server version is showing...

Looks like you have a problem at your mail server - or you have some kind of anti-virus or spam killer installed somewhere.

Check this article to make sure you have...

Hi Ian. I get it now.

So each company has 3 agencies, 3 buses and 3 trads. And the first agency is paired up with the first bus and...

ian_dunlop2000 (3/28/2008)

---

Thanks Karl -what a quick and very impressive response

The code works great - 99% complete

Apologies as fairly new to SQL - how do I create a new table with...