How do I change back what .DAT's open with?

[DawnP]

On a SQL 2000 with Windows 2000 server I accidently changed what .DAT's open with from "unknown application" to "notepad". Now all the .DAT's on the server (including all the SQL files) have the notepad icon instead of that generic Windows one. Did I mess up anything? How can I change it back?

 

[ptheriault]

You didn't mess anything up.
to change it back go to.

Start -> control panel -> folder options

Click on the file types tab.

Scoll down to .DAT, click on it and select change in the lower window.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[DawnP]

I'm glad I didn't mess anything up, but DAT is not listed under the file types tab.

 

[ptheriault]

Add it as a registered file type.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[DawnP]

Okay I was able to add it, but there was no choice for "registered file type" if that's what you meant. If that's not what you meant, I don't know what to pick. I went back to your first step now that it's added, and I don't see anything listed that applies to what it is to change it to. As it stands, it still shows as a notepad object.

 

[mrdenny]

The icon is only there to make things pretty for the person using the machine. There's really no reason to change it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DawnP]

So even though it says .DAT files will open with notepad they won't?

 

[mrdenny]

Any file can be opened in notepad.

All that means is that when you double click on the file notepad will try to open it. It will not effect SQL Server at all to have the assocation setup.


Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DawnP]

So will I never need to open .DAT's on a SQL server?

 

[ptheriault]

you usually read a .dat file with sql like bulk import. and this won't cause any problems.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

You shouldn't ever need to open one manually on the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DawnP]

Thank you both. Whe

http://wwwwwww!

 

[monksnake]

Uncle Rico??

<.