I'd use something like Lowell has to generate a script. Be sure it's hitting the tables that you really need. Last thing you want to do is update something you...

You should be able to install components with Express there. Are you getting an error?

Nice one, Peter.

The extension doesn't matter to SQL Server. Usually .bak is used for organizational purposes, but it can be anything.

It's probably faster. Haven't done enough testing to know, but they usually tweak the process with each version to run a bit smoother.

Some better options with filegroup backup / restore,...

Sorry, being an ID-10-T here today. Or for sure today, possibly other days as well 🙂

Save as a VB file (.bas). You should be able to open in notepad and...

You'd have to include a SET for every column

update xx

set colA = null

where colA = ''

update xx

set colB = null

where colB = ''

etc.

You could...

Dan,

If you can get the funds, I'd call PSS. Sounds like something is very strange on your system.

No idea, but I had issues on my workstation as well.

I removed the directories, the SQL reg keys, and deleted the SQLSTP.log (?) in the Windows folder. Then I re-downloaded...

You have until Jan 30, so go quickly!

We moved to a paid posting service. They're supposed to backfill some jobs. I'll check on that.

I'd talk to a few recruiters. They don't cost you anything and they might...

There's a DTS 2000 runtime for SQL Server 2005 so you can run them. Otherwise, rewrite them in SSIS.

#1 above doesn't matter. It's in his example. You'd just put phone number in your query. SQL will find the field.

Look for the max date for which you have things...

If you're in the US, let me know where. I can recommend a few people as well. Or you can work remotely with Colin.

However you should hire someone. There's too...

A rebuild of the indexes usually requires 1.5x the space of the largest table for data, depending on fragmentation it might require more in the log. That's likely what is.

Andras...