If you are still using remote server for SQL, I suggest you make some progress and start moving over to linked server. Linked server is pretty easy to use/add.
sp_addlinkedserver ’server.f.q.d.n’
There are other parameters sp_addlinkedserver can take as well but the above should suffice. This will add an entry into the sys.servers table/view:
select name,data_source,is_linked,is_data_access_enabled [...]

Dev asked for assistance w/ truncating a log file for one of the databases. He’ve tried most of everything:
setting the recovery mode in SIMPLE
shrinking the database
setting the recovery mode back in FULL
dbcc shrinkfile (logicalname,%)
dbcc shrinkdatabase (dbname)
dbcc shrinkfile (logicalname, emptyfile) — to empty out the transaction log
tried to drop the log files and create a [...]

I was working w/ a dev this afternoon and noticed he used an extended sproc to get fixed drives and the amount of free space on a server via Management Studio:
master..xp_fixeddrives

Recently, I’ve noticed a few tables @ work that has static information and is being reference from mutliple sprocs. We have a table called Parameters. In this table, it would have values, like I said, its static and only 1 row can exist. Let’s take replication, for example:
[column] [...]