Steve the free tool from Redgate works very well, easy to use on one of my machines (XP Pro) running 2005 Express.

The other machine (XP Pro) running 2005...

Brute force nah with finesse / elegance.

This has got me intrigued ... been a long time since working with 2000, but here may be something to stir your creative juices...

Just a wild idea, which I hope will stimulate your creative juices.

Have you considered running sp_who, at least it will tell if some one is using the database, if no...

In USA they are like cockroaches - coming from under the wood work, thought the walls ... any place...

Rowan-283474

A rather over powering number of DTS packages.

Do all packages import the data into a single table or multiple tables?

If a single table is it a...

For an explanation of what happened read these 2 articles:

Changing Table...

This should work to convert the import to what you need

DECLARE @Sub VARCHAR(50)

SET @Sub = REPLACE((CONVERT(VARCHAR(50),GETDATE(),102)),'.','-')

SELECT @Sub

Result: 2010-02-03

Peter Brinkhaus

I tried a new approach, where I started a nested transaction to solve the problem but since SQL Server does not support rollback of inner transactions without rolling...

Now never having had you problem but my guess would be a custom format of String.Format .

peterzeke

Have you looked at:

http://technet.microsoft.com/en-us/library/ms178710(SQL.90).aspx

Which contains:

Use the Choose Format dialog box to specify a text box format. This dialog box opens when you click the ellipsis button (...) in the...

Way back in time (1970s) the Monsanto Chemical company where by corporate head quarters employees could select their path for advancement, that is technical or managerial. Each year the...

If I were that friend of yours I would hope that you would

Now this might be 'cause the company...

milzs

MIght I suggest that you go to

http://technet.microsoft.com/en-us/default.aspx

and in the search window enter "ghost clean up"

In the list that follows you may find this of interest

http://blogs.msdn.com/joesack/archive/2009/02/03/page-cleaning-with-sp-clean-db-file-free-space-and-sp-clean-db-free-space.aspx

There are many,...

Fishbarnriots

An area of SSMS you might consider exploring to determine if you can use a template to do what you want to do.... now I am not sure their is...

honza.mf

paul.goldstraw (2/1/2010)

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

It seems to be happening more and more at the moment and it makes me wonder how many of the people who get the answer right in any...