Not necessary as long as its a standard reboot, not a pull the plug out of the wall reboot.

Keep in mind there could have been another change made prior to...

It could be, but would be pretty rare - I've never seen it. What changed before it stopped working? Disk permissions? Account names? Install some new software, service pack, etc?...

I mentioned this earlier. DTS is easiest, BCP the fastest. I dont think you'll be disappointed with DTS.

Andy

I made a quick package and saved as VB, looks straight forward, here is a snippet:

Public goPackageOld As New DTS.Package

Public goPackage As DTS.Package2

Private Sub Main()

...

I created a view in Northwind as follows:

CREATE VIEW dbo.vTest

AS

SELECT dbo.Categories.*

FROM dbo.Categories

GO

Then ran:

sp_depends 'vtest'

Which returned:

dbo.Categoriesuser tablenoyesPicture

dbo.Categoriesuser tablenoyesrowguid

dbo.Categoriesuser tablenoyesTestCol

dbo.Categoriesuser...

Sure, take a look at ISQL and OSQL.

Andy

Redundant everything. For security, I'd say you have a couple choices. One would be grant DBO access to the client for their database, let them handle administration from there. As...

One way is to convert to a string, then truncate the extra decimal places you don't need.

Andy

I dont have 6.5 installed ANYWHERE. Let me see what I can come up with. Steve?

Andy

Verify connectivity before you start with SQL. Can you ping the remote machine successfully?

Andy

Check the licensing, maybe set to per connection. Can more than 8 connect to the server, or just not to SQL?

Andy

In simple mode/truncate on check point what happens is SQL writes the action to the log, then applies the change to the db, then removes the action from the log....

Forgot this about the costs: exams are $100, you'll need two books probably $70, I usually get one big book (Sybex, New Riders, whatever) and the Exam Cram. Transcender is...

I'd suggest pursueing the 2k track, especially since you haven't started yet. I'd also suggest that you start with the SQL exams, something you're comfortable with. Use the eval if...

Sp_spaceused would be a starting place. You could profile EM to see how its getting the info maybe, probably using DMO.

Andy