Using the text file connection, DTS will re-create the file each time the datapump runs. To append to an existing file you would need to output to a second file...

How is your app connecting to the server? Are you sure you're connecting to the new server?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

From the Server Explorer pane, add a dataconnection. Then expand the tree till you get Stored Procedures. Right-click on the Stroed Procedures folder and choose 'Add to Source Control'

Then you...

Steve is right, reindexing a clustered index can require 120% of the space allocated to the index.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

If you want to check the available space in the t-logs use,

DBCC SQLPERF(LOGSPACE)

This will tell you the size and the % used.

Other than that, I'd go with Allen's suggestion. Assess...

Just use the CAST, or CONVERT, function to re-format the field when you display it.

eg: CAST(Field as decimal(18,2))

Make sure you put the double brackets on the end, I always forget...

Ditto on the newsletter idea.

I'm betting Frank has his father, mother, brother, sister and wife all subscribed

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and...

Hmmm ... it'd have to be an Analysis Services default. Can you do some sort of display formula? Like only display the date if its > 1/1/1900.

Hope this helps

Phill Carter

--------------------

Colt...

Is there any default specified for the field?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Ok so I'm a stick in the mud

I just think that with our ever growing community (I see more and more users with single figure posts)...

Just what I was looking for to drive my ASP status report.

One other tip for #7, I modified the SELECT statement to be like this,

SELECT TOP...

Ok, now not meaning to rain on anyones parade, I know a majority of the posting is exceptionally helpful, but...

How can people be labelled SQL Server Guru's when a lot...

What sort of connection are you using as the source for this statement? The "Error Source: Microsoft JET Database Engine" would indicate that it's not SQL Server.

Hope this helps

Phill Carter

--------------------

Colt...

If you want to execute a DOS command in VBScript you need to create a Windows Shell object. Then you can execute any command you want.

Eg:

Dim WshShell, oExec

Set WshShell =...

Just as a side note to mccork's table definitions, you might want to replace the fields called ID with more descriptive fieldnames. Having worked with a database where ID is...