I have already uninstalled and installed a new copy of SQL Server.

When the backup AND data disk went down, it corrupted ALL my backups and mdf/ldf files.

There was nothing Microsoft...

Thanks for all the help -

Here's the output of the dbcc command , I've already opened a ticket with microsoft

Server: Msg 8948, Level 16, State 3, Line 1

Database error:...

Yes, read that article and already tried the backup and the dbcc checkdb (art, REPAIR_REBUILD)

but still received the same error message.

Time to call Microsoft.

Well it gets worse before it gets better.

I ended up reinstalling SQL Server and tried to attach the mdf/ldf file.

However, now I get this error message when accessing the...

Here's the data - Thanks in advance for your help.

The forum etiqutte page helped quite a bit...

----Lead and LeadContact schema

/****** Object: Table [dbo].[Lead] Script Date:...

That's what I started with before I tried the distinct, I tried it again but still got duplicates.

I think the issue maybe this join -

from ...

Thanks, I was under the impression that the brackets represented the distinct.

If there are multiple emails, I want the one with the highest leadid.

How do I remove carriage returns (double squares) from a file before importing it into the db?

Your right... I was able to use ## in the column delimiter field during import.

I was able to split the data into different fields, but now there are special...

I actually just figured out my issue.

I installed sp2 for reporting services and then gave write access to the 'network' user.

This then allowed me to run the 'upgrade' from...

I'm getting the exact same error messages.

Where you able to resolve the issues? If so how?

Thanks

Susan

I'm getting the same error message. I've verified that remote connections are setup and ISS is running.

Did you ever find a solution?

Thanks

Susan

I had created a UserDSN (and it tested fine) for the linked server.

When I created a systemDSN it worked.

So yes, you can connect from SQL Server to Postgres.

Thanks for...

Thanks...

The convert worked and I was able to create the view in a different database than the source table.

Thanks for your help

Yes, I was trying to create the views in a separate database.

We don't want them to have direct access to the production database and limit what fields they can...