this almost sounds like ID_NUM is a foreign key, and you want to render the details inline in the table; why not just create a view that pulls the data...

i believe you'll get an error if the column doesn't' exist, right? physical_memory_in_bytes vs physical_memory_kb

i've done it with an exec command instead;

IF (SELECT CONVERT(MONEY,LEFT(CONVERT(VARCHAR,SERVERPROPERTY('productversion')),CHARINDEX('.',CONVERT(VARCHAR,SERVERPROPERTY('productversion')))))) >=11

BEGIN

SET @cmd = 'UPDATE...

whoops duplicate!

ocean3300 (2/29/2016)

---

Grant Fritchey (2/29/2016)

---

Global temporary tables are removed after the last process that is referencing them closes. Because you're closing the process, and no other process is referencing the table,...

Eddie that got me over the logjam, thanks;

grabbing the object_name you mentioned, and adding some new smart parsing to my email that shreds xml to get that object name in...

for a lot of my trigger or procedure based audits, i don't limit myself; i just log everything, since you never know what might be relevant later.

I add columns for...

sri2015 (2/29/2016)

---

I have few questions on Bulk Operations

1) how the SQL Server detects Bulk Operations ?

2) I did put SQL Server database in Bulk Logged recovery model and started to...

fatfingered an enter key; answer is below

one of the things i slapped together is a procedure i can call on demand, which grabs whatever is running via sp_whoisactive every 2 seconds, for speedy adhoc monitoring.

it creates...

when it happens, can you run sp_whoisactive or at least sp_who2 and see if there is blocking? I'd look to one instance locking a core table, and all the other...

i would do it similar to the way Luis is: remove ALL leading zeros by converting to decimal, and then add as many zeros as needed to make it a...

in South Florida, most of the SQL related groups are using meetup to organize and publish when there next event is:

this is my local group, for example:

http://www.meetup.com/South-Florida-SQL-Server-User-Group/; Diana Betancourt...

i think you have to set the 64bitruntime to false, right? otherwise no debugging/no data viewers?

i think this is an application error, that has nothing to do with the data; might have something to do with permissions, though.

how are you going into pwd destination? could...

data on insert is probably going to be an insert trigger on the table itself.

Since database mail...