If it worked previously, then you weren't trying to nest INSERT ... EXEC as they cannot be nested under any circumstances. You're going to have to figure out an alternative...

John Mitchell-245523 (12/20/2014)

---

You could put some control flow in your procedure, so that if a value for @top is passed, it used, but if it's null, the query is executed...

You can invalidate the subscription and re-snapshot, but I don't think that's what you want.

Easiest thing here would probably to put a delay in the export process. Transactional replication inherently...

Why don't you focus on the problem rather than adding more complexity?

Your problem is slow recovery on restart. If you're not careful, adding HA could make things worse. Do some...

HanShi (12/22/2014)

---

When connected to the proper SQL instance, execute "SELECT @@VERSION" in a (new) query window. The result will show you the edition of SQL Server and also states information...

Well, there you have it. INSERT .. EXEC cannot be nested.

simon.letts (12/22/2014)

---

Hi, I have the 'data and backup location on separate drives' policy failing on just one server, although there are no .bak or .trn files on the drive where...

Have you checked that the job is doing what it's supposed to do? If say someone changed it to just run CheckDB on master, then it will execute with success,...

Look at what conditions would cause the RAISERROR line to be executed.

Open up the proc, go to line 724 and work out, from the code, what it does and what...

No.

If any developer came to me with tables with a generic 'RecordID', they'd be changing their design. Unless the table was the Records table.

You need a primary key. It is...

If that login is the owner of a database, you won't be able to remove it. First change the owner of the database to another login, then try again.

Just wow.

I'm sure said engineer can point at the kb articles and/or connect items detailing said bug? Didn't think so.

Each core has it's own L1, at least with the Intel processors. L2 is 'shared' (kinda,...

No, a core is a measure of cores. The number of processing cores on a single physical processor.

My desktop at home has an Intel i7 quad-core processor. If I look...

Per processor is the old SQL 2008 and before licensing. Two physical processors - two processor licenses. Done.

Per core is SQL 2012 and later licensing. Two quad core processors -...