Hi Paul

Good advice from metawizard2. Using a "properjob" development environment is always going to be more scaleable and easier to debug, but there is a much steeper learnig curve!

I suspect...

Hi LittleSquall

Sorry for the delay.

[font="Courier New"]dim objConn, strConn, objRst, strSQL, strText

strConn="PROVIDER=SQLOLEDB;DATA SOURCE=SQL_SERVER_NAME;UID=USER_ID;PWD=PASSWORD;DATABASE=Northwind "

strSQL="SELECT CategoryID, CategoryName FROM Categories"

strText=""

If Not IsObject(objConn) Then

set objConn = createobject("ADODB.Connection")

objConn.open strConn

End If

If Not IsObject(objRst) then

...

Fair point Jeff!

So really it would depend on how many rows are returned?

I'm guessing the threshold would be around 200?

Mind you, if it's 150 columns and 200 rows that's one...

Hi

I thought I'd put my pennysworth in.

No-one has suggested writing a VBS file using ADO to loop through the recordset writing to a file at each iteration. This could be...

A well constructed article, but can someone explain to me why American database professionals continue to use the ambiguous and confusing mm/dd/yy date format? I can understand them using it...

Sorry, you wanted size aswell:

SELECT SERVER_NAME,

 substring(max(right('00' + cast(DBSIZE as nvarchar(4)), 4) + DATABASE_NAME), 5, 3) DATABASE_NAME,

 cast(max(right('00' + cast(DBSIZE as nvarchar(4)), 4)) as int)

FROM #TEST

GROUP BY SERVER_NAME

Using Lowell's temporary table (thankyou Lowell):

SELECT SERVER_NAME, substring(max(right('00' + cast(DBSIZE as nvarchar(4)), 4) + DATABASE_NAME), 5, 3)

FROM #TEST

GROUP BY SERVER_NAME

will work very efficiently.

You can't directly...

"Open Enterprise Manager. Expand until you see your database. Right click on it. Select Properties. Go to the tab for the Transaction Log. How many files are listed?"

 

One file.

You are correct - I am using a backup device.

How do I check which members there are?

If you absolutely MUST have your date stored in YYYYMMDD format, then why not create another column in the table that simultaneously records the same date in the more traditional...

Thankyou all for replying, even Aaron who inadvertently missed the forum subject title!

Lynn...your solution was the one I first tried. However it doesn't guarantee to always bring back a max...

Thankyou for raising this very important topc.

Of most use to me would be an article that concentrates on how to convince the HR department that they must make the investment.

Most...

Sorry to be boring guys - but have we not strayed just a tad from the original question?

I'd like to know if we can assume that the initial state of...