didn't find a single list from Microsoft, but i found this one on codeproject:

http://www.codeproject.com/Articles/39131/Global-Variables-in-SQL-Server

•@@CONNECTIONS

•@@MAX_CONNECTIONS

•@@CPU_BUSY

•@@ERROR

•@@IDENTITY

•@@IDLE

•@@IO_BUSY

•@@LANGID

•@@LANGUAGE

•@@MAXCHARLEN

•@@PACK_RECEIVED

•@@PACK_SENT

•@@PACKET_ERRORS

•@@ROWCOUNT ...

Dorthy Jeff Moden has a couple of posts on this, which i'd saved in the past:

here's the specific threads in question:

http://www.sqlservercentral.com/search/?q=%22Headerless+Ragged+Right%22

basically, he uses some dos commands to make sure the...

at my last job we had a similar situation, after one core issue boiled down to the client creating poorly written triggers, which broke the application's logic. against the user...

i can think of only a couple offthe top of my head:

TCP/IP / remote connections are not enabled by default.

no Dedicated Admin Connection is available by default.

depending on the...

here's my best guess based on your post's info:

i'm explicitly aliasing the target table, so it might make it a little clearer:

UPDATE MyTarget

SET MyTarget.updtbl_lat = i.infotbl_lat,

...

SQL Server Central currently has 103 videos on various SQL related subjects:

http://www.sqlservercentral.com/Articles/Video

add in the Stairways series on various SQl related paths, and you've got a great start right here on...

Pretty sure SQL server will...

it's not obvious, but if you look at the html source of some of your own email, the trick is referencing the content id(cid) of the attachment(s) that was included;...

well, you are only going to capture changes that occur in the future, after you've put some sort of auditing in place.

stuff that has already happened just plain is not...

well, i'd start with implicit users that come from windows groups:

select *

from master.sys.server_principals

where type_desc = 'WINDOWS_GROUP'

from there, for each name in the list, you can use a built...

hdillow (10/18/2013)

---

Hello, if you were to remove the dlls from an installation directory, what happens if the SQL Server Instance is restarted or the cluster fails over to another node?...

more details from you before we can help, i think.

you really need to analyze the trigger itself, and fix the issue;

for example, if there is a trigger on a...

Select from sys.triggers and sys.server_triggers. based on the brief description you gave plus the fact the.name contains "nested " you might have a trigger that blocks itself as well as...

here's the first actual code example i found:

http://www.codeproject.com/Articles/13391/Using-IFilter-in-C

along the lines of what Erland was suggesting, i think i'd simply add a column that will hold the extracted text from the...

I suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are looking...