This sounds like an extremely strange architecture...are you sure you want to allow data in a text file to dynamically dictate the tables you reference in DML you apply to...

Time to hit the books...getting the contents of a folder is a trivial task in C# but it's a learning...

It may be possible with expressions, but my limited knowledge of them has me imaging an extermely ugly and complex one.

So, instead of using Derived Column you can do...

SQL 2000 does not have a SQL Browser service like 2005+. Accessing it by IP address should work for you.

*I think* if you register the server name as a System...

It creates a CROSS JOIN.

These should be equivalent:

SELECT *

FROM table_1 a

JOIN table_2 b ON a.id = b.id,

...

I would recommend you leave the sp_OA procs disabled on your instance and start using the SQLCLR for tasks like this...

If you're being boxed into using the OLE Automation procs...

I think he has a list of hostnames and he needs to discover the SQL Server instances in the first place...RamSteve, can you clarify?

As usual...it depends. I just found this little nugget and it reminded me of this thread. The article is also from the sqlskills.com tandem. It starts off by supporting the...

I started looking into this but have to go so figured I would post what I found so far...

After setting up a little test environment:

CREATE TABLE dbo.a (NAME VARCHAR(100))

INSERT INTO...

To clarify...I am implying that you would enhance your PowerShell script to update the configuration table in the database with the "last reboot time".

I would setup a SQL Agent job that was scheduled to "Start automatically when SQL Agent starts" to call your PowerShell script, retrieve the "last reboot time" from the OS...

Not that you won't receive help here...but you may be better off posting this in one of the Reporting Services forums: http://www.sqlservercentral.com/Forums/Group416.aspx

This is presenting itself as a "running total" problem...i.e. you need to compare a value in the previous row to a value in the current row to make a decision...

Martin Stephenson (3/15/2011)

---

HP EVA 4400, which gives us virtualised storage, my take on this is that it makes my life easier.

I am tempted to create an OS drive and a...

There is another Sybase migration discussion going on that may assist...this post in particular may be useful to you:

http://www.sqlservercentral.com/Forums/FindPost1078311.aspx