SSMS -> File -> Open: gives Notepad rather than Query Editor

Question

Post reply

SSMS -> File -> Open: gives Notepad rather than Query Editor

Tom3w

Default port

Points: 1417
More actions
June 8, 2011 at 12:40 pm

#251470

:crazy: Stumped on this;
started yesterday after >10 years using SQL, but figure best chance of quick reply is in Newbie category.
using SQL Management Studio 10.0 .
Tried http://www.sqlservercentral.com/articles/SSMS/72871/
& various changes to File extensions in Windows,
& reboot of my PC.
Only happens when open files created (or edited) yesterday or today.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

So if you try to open files more than 2 days old it opens them just fine?

What OS and SP?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Tom3w Default port Points: 1417 More actions · Answer 2

Tom3w

Default port

Points: 1417

June 8, 2011 at 1:34 pm

#1335912

Windows XP Pro v2002, SP3

SSMS 10.0.1600.22

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

See if this helps at all

https://www.arcomit.co.uk/support/kb.aspx?kbid=000057

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Tom3w Default port Points: 1417 More actions · Answer 4

Tom3w

Default port

Points: 1417

June 8, 2011 at 2:03 pm

#1335938

tried suggested link ... no help.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

can you d-click the files and have them open in SSMS properly?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Tom3w Default port Points: 1417 More actions · Answer 6

when double-click,

they open SSMS ... but the file itself opens in Notepad.

Lowell SSC Guru Points: 323518 More actions · Answer 7

i think you answered this in your first post...but just in case...

can you go to this spot and put sql files in there? does that make any difference?

i know on my windows 7 laptop, files fromt he internet get marked as untrusted ro something, and i have to jump thru extra hoops asking me if I trust the source of the file...I wonder if it's somethign like that that happeend since the reboot...

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Tom3w Default port Points: 1417 More actions · Answer 8

tried that, but for *.sql extension.

Thanks for trying.

p.s.

supposedly Win XP has some kind of extension default in the Registry, but can't spot it.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Can you screenshot your options screen for us?

I currently have nothing listed in my extensions mapping screen and don't have an issue with sql files opening up in SSMS.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Tom3w Default port Points: 1417 More actions · Answer 10

image wants URL but don't have ability to do that, sorry.

it is same as your screen except `sql` instead of `txt`.

Added this today well after the trouble began.

Tom3w Default port Points: 1417 More actions · Answer 11

correction, same as Lowell's post except 'sql' instead of 'txt' as extension.

Not able to post screenshot, sorry.

Tom3w Default port Points: 1417 More actions · Answer 12

seems to be something in next section of file, where unprintable boxes are ASCII 16's.

Stuff between /* ... */ is not SQL, so treat as text rather than trying to interpret it.

---------------------------------

SET NOCOUNT ON

/* ...

ECBQ-1 for process FOC_AG-ALL-0_Xfer (db = t6fdb, Thread 0xFEC)

Buf=`{CALL mt_fc88888882 (DEV,yyyyyyyyyz,xxxxxxxxxxxxxxxxxxxxx,NULL,NULL,NULL,NULL,NULL,B)}`

at 07Day, 10H 47M 44S 718i (Day, hour, minute, seconds, milliseconds)

ECBQ Thread 0xFEC.

m_b08S01=0, m_bOdbcTimeoutFatal=1 at 07Day, 10H 47M 44S 718i

about to BeginTrans at 07Day, 10H 47M 44S 718iTrans back at 07Day, 10H 47M 44S 718i

in cSQL::Execute override with m_bOpen 1, slot 0 to 5,

pSql `{CALL mt_fc77777774 ('DEV','yyyyyyyyyz','xxxxxxxxxxxxxxxxxxxxx',NULL,NULL,NULL,NULL,NULL,'B')}`.

at 07Day, 10H 47M 44S 718i

Exit ECBQ, fatal flag 0, state flag 0, at 07Day, 10H 47M 44S 734i

Unknown code 0 in CTask::ProcessTask for process FOC_AG-ALL-0_Xfer (db = t6fdb) at 07Day, 10H 47M 44S 734i

*/

SELECT ...

-----------------

Tom3w Default port Points: 1417 More actions · Answer 13

yup, it was the unprintable ASCII 16.

thanks everyone.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

That's good to know.

At least we know now one more thing to look for.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events