Yes, we do have quite a few foreign keys created for some of the tables.

But the diagram only add tables, no replationship link at all.

Thanks for the answers, that helps a lot

Yes, I restart both services, the job seems run successfully.

Thanks

I didn't recreate the job, I just changed the package configuration to point to the newly created enviroment variable.

So I don't think I need to recreate the job or schedule.

But...

Another question related, if our production is going to be using standard version, can I install first the standard version on my testing box, and then after this, I will...

I got it, thanks.

If i can see more examples online somewhere, that would be helpful

Thank you.

I am still a little bit confusing.I'm new to programming. It seems I have never seen before a parameter is in where clause but it is not the field...

Thank you!

The situation is, we want to upgrade server from sql 2005 to 2008 on production.

But we want to test this on a testing box first, also test the application, if...

Good to know, thanks

Yes, you are right, there is a trigger for auditing the table for update, insert , delete,

Thanks!

Thanks for both of you.

I see your point of using it.

Only at the time which is really helped and needed to visualize

Lowell, just curious how did you add the image to the post?

Please see attachement in a gif file

I have written a stored procedure like below in an admin database on the server,

but there are some errors:

CREATE PROCEDURE sp_AddUserToArchivedbs

@username varchar(20)

as

DECLARE @databasename nvarchar(80)

DECLARE @Mycursor...