Lately I've been reading more about Ruby on Rails -- actually it has been rather entertaining, colorful, testy, and somewhat enlightening. One important aspect of programming is the ability to analyze, understand, and adapt. I have been using more Python lately in work as well as JavaScript and it has been enjoyable although I still like and prefer C#. Sometimes I wonder how many programmers get fixated on specific language features that in turn becomes a "must have" or requirement for any language he or she uses. That isn't to say the feature is not important but rather usually the...
I was setting up a linked server from my web database to my local database to ease the backup procedure. Currently I have a script which I run to copy all of the database from the web database to my local database. I thought I could simply use sp_addlinkedserver to conect the SQL Servers. My initial attempts to connect the servers was rebuffed:-- Try 1 (failed)
EXEC sp_addlinkedserver
@server = 'subtext_web'
,@srvproduct = 'SQL Server'
,@datasrc ...