I would suggest looking at VBScript and the WMI objects.  You can run a VBScript on one server to check objects (like services) on another server.  Check http://www.microsoft.com/scripting (and...

In the past when I've had todo this, I loaded the DB2 Timestamp column into a varchar column, then had a computed column that converted the text to a datetime. ...

Hey!  Finally a question easy for those of us that are develpors first (and dbas second).  That keystroke combination is second nature for us!

I assume your concern is running 4 separate queries on the table ReportOpenItemsOverDue.

How about creating a table of the email addresses, then doing a cross-join on the email address table...

The hotfixes have been replaced by Service Pack 4.  If you want both servers at the same level, it would be best to upgrade both to current service pack and...

It is likely that the table you have linked to does not have a primary key.  The best way I can think what Access is doing, is that Access cannot...

And if you want some real life examples of storing documents in databases directly to refute your DBA, just look at MS SharePoint and MS Project Server.  I've seen an Hyland...

How about running a SQL query, using OPENDATASOURCE or OPENROWSET to access the flat file, and use SELECT TOP 1 ... for the query?

This has been in the forums fairly often.  Check

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=165368

Basically, your delimiter would be "\",\"", but there a couple "tricks" you need to do for the first and last column. ...

If you are using Visual Basic.Net, you might consider using SQL Server Reporting Services.  This is a free add-on for SQL Server, and I believe it does have a Report...

Jeremy;

Not sure of your question.  You still need port 445 open, whether it is on XP or not, if you want to connect via Named Pipes.  OS does not matter.

To...

This actually is a common question in relational databases.  If you search here or on Google for heirarchical queries or bill-of-material queries, you can find many examples.  Also, a good...

How about just:

PRINT '-------- Utah Authors report --------'
SELECT '----- Books by Author: ' + au_fname + ' ' + au_lname
FROM authors
WHERE state = 'UT'
ORDER BY au_id

Then there is...

What I will "usually" do for states in an application (again, it depends), is have a state table:

create table State(name char(2))

and put the state in the record itself (to use...

Hopefully not.