I did a quick google search: 

"SQL Server" "reporting services" vista "home premium"

On the page  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1320161&SiteID=1

there's the entry stating

"Note that IIS7 in Vista Home Premium does not include Windows...

So you have a "live" table (one that's permanent in the database I presume) with a definition similar to

create table myTable(  col1 int, col2 varchar(10), col3 float, col4 bit, ID...

Have you got your linked server running for an interactive query that you can run?  If so, then you can use the same code to make a job for SQL...

You shouldn't have many problems, but you should set up VMWare to use multiple physical disk drives so that you can still separate the databases onto different disk spindles as...

Can you please provide some of the SQL statements from the table?

Where did you try to insert the "AS" keyword?

You may wish to look at SQL Server Replication rather than triggers. The only reason is that if the link between the servers disappears briefly then you trigger will...

I'm not really sure what the SCADA system is but I suppose it's some sort of system that has disparate controllers and gets upset with local time zone changes such...

Phil's reason is the only one I can think of. Such tables are not really "tables" per se but are represented as tables in SQL Server in the absence...

I haven't seen anything to the contrary.  You wouldn't ask the question unless you had a suspicion that this was not the case.  Are you having troubles with your restored...

An article on the front page of this site might be right up your alley! http://www.sqlservercentral.com/columnists/mdillon/2863.asp

Recompilation due to different query plans for different circumstances seemed to be the best...

To elaborate on Sergiy's response (which is 100% correct btw), it's common for many people from the dbase / flat-file world to store dates as strings in the database. ...

and I realise that my code includes an extra comma Fix as needed

It's always "yukky" to return data like that, but if you must, then you can do something like

declare @X varchar(8000)

set @X = ''

select @X = @X + ',' + myCol

from...

SQL Server will take row locks or page locks as required. Look for "lock escalation" in SQL Books Online. Essentially, SQL wil take row locks, but if you...

Joe, your answer is certainly correct - although it is a touch brutal.  Yes it is annoying to get saddled with applications that do all sorts of very nasty, ugly,...