You didn't read the instructions down far enough.

There is a parameter @ChangeBackupType. If this is set to 'Y', it will automatically change a diff or log to a full...

How about:

SELECT COUNT(*), X.[UserName]

FROM

(SELECT

`user1` [UserName],

FROM usuarios

WHERE (`user1` is not null)

UNION ALL

SELECT

`user2` [UserName],

FROM usuarios

WHERE (`user2` is not null)) X

GROUP BY X.[UserName]

ORDER BY X.[UserName]

http://www.google.com

In the little window, type "Ola Hallengren".

His web page will appear. All of the instructions are explained clearly on his page.

And, it will automatically take a full...

You hate stored procs? Why? Did you think that there is a really good reason why your teacher is shoving them down your throat?

That being said, he...

Need any help???

Now that I look at this harder, there are many things that are not going to work very well.

The insert procedure:

As Scott Pointed out,

Begin

...

I think you have your architecture a bit backwards???

Instead of storing the audit id in the primary database tables, why aren't you storing the PK of the tables in the...

Convert the varchar fields to datetime fields, and then do the comparison.

You will need to use the style of 3 when you convert the varchar date values.

Luis Cazares (10/6/2014)

---

That's correct, you could keep a bit column to group status if needed. For example:

CREATE TABLE User_Status(

user_status_id int IDENTITY PRIMARY KEY,

...

Agree with Eric. This sounds like something that evolved over time. Little patch here, little patch there, little patch everywhere.

Document, and if possible, clean up the parts you can...

I echo the previous post!

Also, where are the test and QA databases going to reside? If you plan on having them on the same instance, then that's not a...

For starters, not sure why you did the dynamic code in the manner you did it. It's a lot of extra work.

You are not using the @DB_Name parameter anywhere....

My steps, in order:

1. WHAT is the problem?

2. WHY is it a problem?

3. Is it worth it?

Then, once I get those question answered, I start in this manner. Remember, it's...

Regarding the performance hit. It would help to know what goes on under the hood of MS SQL. If a view has 100,000 records and one of them...

This is not advice on what to do, but HOW to do it.

I have been involved with 7 different data warehouse / BI initiatives with companies of various sizes...