Quinn-793124 (7/27/2016)

---

Is there a way a way to figure out what license level I am at? Like express, standard or enterpriseso I get the same license...

tom.w.brannon (7/27/2016)

---

I expected the answer to be that there was an error because tbl did not exist. Since that wasn't an option, I did some experimenting around the open...

edwardwill (7/27/2016)

---

John Mitchell-245523 (7/27/2016)

---

Not sure whether you're...

Not sure whether you're saying you're surprised...

¿Cuántos archivos ndf tienes? ¿Por qué quieres eliminarlos?

How many ndf files do you have? Why do you want to drop them?

John

It's ready now!

John

You might want to take a look at this, in that case.

John

Where do the values from those variables come from? It looks to me as if you're inserting into activity_table one row at a time, which is very inefficient. ...

Glad it's working for you. Check out this page.

John

It's a SQL account. We can see that from the parameters for sp_addlinkedsrvlogin. What we still don't know is what message, if any, is appearing in the errorlog...

Jeff Moden (7/22/2016)

---

It's just easier for me to ensure that right after I bounce everyone out with a single user connection that I immediately shift back to something a bit...

I don't know where you're getting "Output.ColumnName" from. It's either Inserted.ColumnName or Deleted.ColumnName. Do it like it's shown in the examples, and don't be afraid to try stuff...

Because there's no such virtual table as "Updated". Like I said, Inserted is the values after the update; Deleted is the values before.

John

Edit: By way of further explanation, an...

I'm not sure what you mean. There are plenty of examples on that page I linked to. "Inserted." refers to the new value of the column after the...

If I understand correctly, you need an OUTPUT clause in your UPDATE statement.

John