Put the parent proc in a try/catch also.

A procedure will return 0 if it is successful, and non-zero if it fails.

In the parent proc, you can do this:

DECLARE...

Maybe the question should have been worded like this:

According to the first paragraph about aggregates in Books Online, which of these aggregate functions does not ignore NULL values?

REN *_09162014.txt *.txt

Maybe.

We did not have direct control of our servers in our old data center. The windows admins would push patches at some point during the week, and re-boot on...

My first IT job was a similar situation. When the phone rang, we wrote code. Or changed the light bulbs. Or fixed the copier. Or upgraded a network.

Basically anything...

This is a...

This:

20141222133915

is more readable than this

2014-12-22 10:42:21.693

or

2014-12-22

Really?

There are significant differences sometimes. Again, I could tell you stories!!!

The other thing to consider is that there seems to be a lot of employee turnover at placement firms,...

Agree. There are some good ones, and some bad ones.

In my area (Pennsylvania), there seems to be lot of recruiters that really did not look at your resume....

By using the series of in-line queries, you have created a situation where this table is hit for each row of the outside query.

You are using a CASE statement, so...

A DDL trigger will work.

Something like:

CREATE TRIGGER [DDL_NoIndexes] ON DATABASE

FOR create_index, alter_index

AS

ROLLBACK

PRINT 'Please don''t do that!'

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ENABLE TRIGGER [DDL_NoIndexes] ON DATABASE

GO

I have the same issue. The developers...

When you create a publication, there is an option to replicate schema changes which will propagate changes to the subscription automatically.

But not always! If you add a...

If this is a one time process to get things back in control, Ok, my apologies.

But, as I read your post, it seemed as if it was your normal process....

kevin_nikolai (11/25/2014)

---

--Step 2:

/*

With 2 cursors in 2nd proc (original), if I select 9 campuses, query finishes in 4 minutes 10 seconds.

After removal of 2 cursors from 2nd proc (step 1...

Dave, what problem are you trying to fix? What you are describing is normal. Unless you are running out of disk space, there is not a problem here....