Thanks Fitz for jumping in there with some help. I appreciate it.

Yay! I got it to work. Here is my journal of how I did it:

•Installed developer install of SQL SERVER for reporting services.

•Got an error that says: The...

Thank you. I will give this a try.

I really appreciate it. I know on most servers, we are not allowed to cmdshell.

However, this is a DEV server, so...

I appreciate the help. However, what I need is to list ALL incidents for each facility whether they had any incidents or not.

For example,

if Table b had the following:

Sample...

Oh My Goodness!!!!!!!!!!!!!

Finally success.

I had to create the profile name on the server that I am using with the connection manager. I had previously created a profile on the...

I've already done that.

Most of the sites are saying go into SSMS and create a profile.

I've done that.

I've created a public profile in database mail in SSMS and set the...

Well thank you for responding. But like a lot of the things I am seeing, there is one or two things that aren't explained.

I ran the script, but it...

Suresh,

The link just opens a blank window.

I did figure it out though.

1) Use a trigger to get the username when it is inserted into the user table.

2) Take...

Alright, I changed the constraint to failure. It turned red.

I then clicked on the scripttask and there was a green constraint also.

OK, I'm good on this now.

Thanks.

Hello,

1) Yes, I am using a foreach container.

I have over 80 databases. For debug purposes, I need to stop when the name of the database gets to a...

Thanks man.

I just wanted to make sure that it is the way to lock down the folders.

Thank you gentlemen.

I was hoping for a different way. However, if that is the prescribed way of handling such a request, guess I have to do it.

Thanks again.

Gianluca,

Thanks for the response. Looks interesting.

Now what is a spaghetti DBA?

Tony

John,

It worked perfectly. I just have to make a note that you can only run this on servers that are 2005 and above.

We have just a few servers still...

Markus,

Thanks for replying. It worked well.

Unfortunately, my folks here do not want to have something loaded on each production server. This script works, but you first have to...