Powershell would work.

You could read first line until crlf - that would give you the format of your file, then use some string processing in Powershell to build...

Hi Thanks for reply!

Yes there is a clustered index, this is one in vendor custom job/stored proc that rebuilds the index using...

I saw your post... though I don't think I have an answer, I did have questions?

Just wanted to confirm:

Post mentioned there was nothing in the bootstrap logs? (I'm...

Anyone know of a website "App" or app for SQL Server tech articles ..or (magazine/newspaper style?) - like they do for "news" consolidation. There are some no the iPad...

Agree with Randy they potentially could be on non default port for your SQL Servers. (e.g. named instance possibly)

Have you tried using a tool to check the ports?

Microsoft has...

Could it be that SQL Browser services needs to be active so that oSQL will see servers. Also you may want to check if your firewall settings have blocked...

I agree with Arthur, I like the magazines also. I do like SQL magazine, and really liked the print form. I guess we're saving trees now.

Someone already asked about drive differences so maybe I can ask something else:

Is the data in both environments the same or have you rebuilt indexes, refreshed everything, restarted sql server...

1. Add a clustered index to each table

2. Keep indexes narrow, especially the clustered index

3. Make sure that the columns in the clustered index aren't updated

4. Make clustered indexes monotonically...

Hello I saw your posting, but I wanted to confirm.. you stated you have installed only the client tools successfully?

Are you stating that the SQL Server engine was not...

This might not be relevant as maybe you've already tried this ... but have you looked in your add/remove programs to see if there were remnants of past SQL Server...

I removed because my suggestion was incorrect, I wasn't paying close attention - apologies Welsh Corgi... thanks for pointing out Gilamonster. 🙂

How are you determining where the Hypens will be inserted? Do you have a spec/business rule?

I'm wondering also if restoring the system dbs along with user dbs might work if using same machine? Do you have a way to test this, I'd...

Ah that's what I was missing! I was not considering those factors.

Thanks everyone

-Norman