I need to describe a bunch of tables programatically (i.e. get their attribute names and corresponding data types). I can use Describe table on them in the SQL window, but when I try to get the ...

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy ...