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 [...]
Archive for May, 2007
blah blah … all logical log files are in use
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 [...]
Fixed drives and its MB
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
Setting Parameters
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] [value] distributor serverA publisher serverB subscriber [...]