Also if you want to get two rows you can use the IN statement

SELECT STNNo FROM table1 where VoucherBookletNo IN ('VVB0000021','VVB0000025')

Everybody who has seen Arthur Christmas knows that reindeer names are

Dasher, Dancer, Prancer, John, Bambi, "You with the white ear", "And You" and "you". 😉

There is way but only for really desperate situations.

You can install SQL server on another box. This computer should have the same name that the one you are in trouble....

How long did was your database now?

How do they fix WMI error?

Where you able to find any relationship between all the events (WMI, MOF, master corruption)?

Any clue about the root...

Hi Tafarelo,

I do not feel comfortable with Outlook installed and configured on server, so I guess I've tried to convince the customer.

I know that some customers does not let...

Are you really sure you want and need to have outlook installed on a server?

With CDOSYS and a couple of stored procedures you can perform the same job.

Regards

Have you run your program in a step-by-step basis in order to debug?

Are the values correct for the fiels you are trying to insert? eg. you are trying to put...

Is there any Error table generated in Access?

Have you checked NTFS permissions?

Have you run in a step-by-step debug mode to check what is the code doing?

Regards

Ramon

The mail server is requesting you a valid user/password before you can send the message.

Ask you mail administrator for this info, if it's inside your network maybe he/she/they can setup...

Have you checked view permissions?

Regards Ramon

You can send emails without outlook just with cdosys. Take a look at How to send e-mail without using SQL Mail in SQL Server http://support.microsoft.com/kb/312839/en-us

Have you checked store procedures related to replication like sp_droppublication?

Could you be more specific about the error messages and you environment?

I've experienced some auditories, and my conclusion is that in many of the cases auditors don't have a deep knowledge of whatever are they auditing and they are following a...