Do you really need them to execute at the same time or just both execute and return a value before sproc 3?

The technique above from sql_er will work if they...

The compatibility level affects which keywords are working, so you can't do this without changing the level. However you can use T-SQL, as mentioned above, to achieve the same type...

Very strange. I might write a routine to capture the sp_configure settings every hour or so and report if it's changed. That will help you narrow things down to see...

The problem with going with stored procedures is that you'll have an exception somewhere and that will cause problems. If you can tightly control development, this can work, but it...

Hugo,

Thanks and good seeing you last week.

Didn't think about those parts being optional when I reviewed this. I kind of glanced at it and took those to be valid options.

The...

One more thing I might mention here.

Don't feel bad about missing a session. If you get busy or get into good conversations with people, especially MS people, skip a session....

I think CU6 was stable on clusters, though I haven't heard a lot since then. You might email Geoff Hiten, SQL MVP that does a lot with clusters.

I would go...

I'm with Gail and Lynn.

I had to do this and it was hard, but I got management buy in, created Windows groups and assigned permissions (DBO, not SA) and then...

The SAN drives are just other disks to the OS. You can have some MDf/NDF/LDF files local and some on the SAN, though I wouldn't recommend it. I'd start migrating...

Great summary and I'll be writing one to post as well.

Talk to everyone. Sit next to new people at lunch, get to know them, ask them what they do. I...

ZBB is how I always did things, looking back at last year only to ensure I was covering costs or estimating expenses properly. It is a pain, but it should...

Wow, that's a lot of code. Posted a hint to a derived table article.

That's a lot of code.

Derived Tables - http://www.sqlservercentral.com/articles/DerivedTables/61388/

You might need to make two updates if you can't get it done in one. Gail has given you good hints, and you...

I think SQLCompare (Red Gate) will do this. There is an option to compare to a backup file.

You might be better off importing the entire file into a table with one column, one large varchar, and then searching through for this line, if the format is there....