dbTalk Databases Forums  

??? SSMS 2008 Cannot Open *.sql Files ???

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss ??? SSMS 2008 Cannot Open *.sql Files ??? in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Baxter
 
Posts: n/a

Default ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:02 PM






This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?


Reply With Quote
  #2  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM






On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #3  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #4  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #5  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #6  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #7  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #8  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #9  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
  #10  
Old   
Roy Harvey (SQL Server MVP)
 
Posts: n/a

Default Re: ??? SSMS 2008 Cannot Open *.sql Files ??? - 10-01-2008 , 03:12 PM



On Wed, 1 Oct 2008 15:02:07 -0500, "Tom Baxter" <tlbaxter99 (AT) yahoo (DOT) com>
wrote:

Quote:
This is depressing. I'm using Vista Business Ed.

I have SQL Server 2008 Standard Ed. installed along with SS Management
Studio. When I double-click a *.sql file in Windows Explorer I receive this
dialog message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
There is no editor available for 'C:\Users\tbaxter\Desktop\SQL Server
Sample Scripts\Tools\Samples\AdventureWorks 2008 OLTP\instawdb.sql'.

Make sure the application for the file type (.sql) is installed.

In my file associations I have checked that *.sql files are associated with
SSMS. Just for the heck of it I dis-associated and then re-associated *.sql
files with SSMS but still I get this error.

For now I have to open my *.sql files in notepad and copy their contents to
the clipboard and then paste into a query window.

Has anyone else seen this behavior?
I have not had that problem, but then I never double-clock on .sql
files. Management Studio is working fine? If so you should be able
to start it and then use File / Open.

Roy Harvey
Beacon Falls, CT


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.