Actually your single line question does not convey the complete sense of your...

Try this

SELECT CAST(@issueDate AS DATETIME)

Nothing to worry, the user you are connecting must not have permissions on that Database.

On the SQL Instance, see the permissions to that SQL login and if not given already...

You need to restart, so should plan a maintenance window for your production server.

Have you tested by applying SP3 on your test or development servers? If not, then test it...

I am starting to understand a little bit more now. But encourage you to post the create table scripts and some insert scripts to test the data. It would...

Thanks Jack for correcting.

Would be able to help if error details / description can be posted.

Use this script

select [NAME] from dbo.syslogins where isntname = 1

If I am not wrong SQL Server does not store the First Name , Last Name of the Users, so...

forumdog (11/18/2009)

---

I shouldn't have to say it. It is assumed. My requirement was what I stated. For you to assume otherwise is just being unhelpful and being difficult. Be a...

forumdog (11/18/2009)

---

Alot of very rude and what appears to be blatant disrespect and rudeness so far. Okay you arrogant and unhelpful people. May life and God show as much caring,...

Do not be so rude. If you...

If that is all you are doing, why not do it using the Execute SQL Task?

That's only half of the answer. What about the other part of the answer.

.

Any...

You are welcome !

Did it solve your problem, if so how long did it take?

It will create a problem when a duplicate record is...