In this simple example, this would not error, but could cause blocking, meaning the Web page is waiting until the UPDATEs are finished and their transaction committed before it performs...

latkinson (12/1/2016)

---

I am refreshing a warehouse table nightly. The refresh is designed so that only when all the tables are successfully refreshed is the refresh considered complete. This allows the...

Over the years I've used both purchased and self-built monitoring solutions. Now that I've acquired a large set of monitoring and diagnostic type queries that I've put into a...

Weekly basis...

If you want to explicitly stay with SSIS tasks though instead of SQL, then you'd have to do a lot of gyrations, including saving the results explicitly to a variable...

the obvious answer would be sp_send_dbmail:

https://msdn.microsoft.com/en-us/library/ms190307.aspx

I prefer to use the @attach_query_result_as_file=1 option, because the results are often easier to read in the text file than in the body where outlook...

You can use the INSERT... EXEC... construct to save the results of stored proc BB into a temp table, then read from that. You'll need the @name parameter to...

JP10 (12/1/2016)

---

Hello Chris,

I tried this before, but doesn't this trace only catch the culprit if they create the temp table at the time of the trace being ran? It...

r5d4 (12/1/2016)

---

Hiya,

I'm on a site where SQL Developers have a functions database which only contains functions.

The functions are used via 3 part naming in code in other databases.

It is done...

GilaMonster (11/30/2016)

---

It might be an attempt to reduce IO contention, as tables and indexes in PRIMARY will be spread across all files. Whether it's effective at that, or just someone's...

The way I think of it is the following:

- a stored procedure is a container for code that executes on request

- a trigger is a container for code that executes...

It's not entirely clear what you're asking. Are you saying you want to add another node to the cluster with this new instance? That would require you're on...

JP10 (11/30/2016)

---

...Ok next question is then how do we find out who the person is that created the temp table? I have seen people post traces to find, but...

Jeff Moden (11/29/2016)

---

Heh... 40 years ago, Troy Michigan was mostly farms. Now, its a see of houses and many large business building with a shedload of 4 lane streets...

😀 just what I was thinking. I've worked with SQL Server since version 2000, but it wasn't until the redesign...