Hello,

Autoshrink is set to false.

However, the files autogrowth is turned on.

Thanks.

Thanks for posting this.

I just configured a new server with SQL Server services. For some reason, SSRS would not start.

I used these steps and rebooted. The service started...

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