Activity overview
Latest activity by Pilgram1jd
I have run the process and here are the results:
process:
1) create new project (add to source safe.)
2) script a query to clip-board.
3) Create a new query.
4) paste to new query window, change the name and check in to sourcesafe.
5) remove query (perform a local delete. Do not delete from source safe).
6) ensure that file on disk is removed/deleted.
7) create a new query.
8) paste in query, change the same to the same name used in step 4. Save.
9) click through the warning messages. overwrite(yes), (continue with change)
Errors listed below as they happen: TITLE: Microsoft SQL Server Management Studio
Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)
BUTTONS:
OK
The file does not rename, the rename process fails until the SMSS is restarted and the project gets corrupted.
Version: SqlPrompt 3.8.0RC1
John. / comments
I have run the process and here are the results:
process:
1) create new project (add to source safe.)
2) script a query to clip-board.
3) Create a new query.
4) paste to new query window, change th...
Thank you Tanya,
The way the last post read, it suggested that I was using "LoginAS" and that they were waiting on something from me.
I really appreciate the update.
Thank you.
John. / comments
Thank you Tanya,
The way the last post read, it suggested that I was using "LoginAS" and that they were waiting on something from me.
I really appreciate the update.
Thank you.
John.
Brian Donahue wrote:
Hi guys,
On certain versions of Prompt, I think the RCW error message occurs when you use RunAs to start SSMS. The error can occur when Prompt tries to save settings on the exit of SSMS. An upgrade to the latest version should fix this.
According to the tool for your product. I am running the latest version and no it has not fixed it.
John / comments
Brian Donahue wrote:
Hi guys,
On certain versions of Prompt, I think the RCW error message occurs when you use RunAs to start SSMS. The error can occur when Prompt tries to save settings on the ...
Brian Donahue wrote:
Hi guys,
On certain versions of Prompt, I think the RCW error message occurs when you use RunAs to start SSMS. The error can occur when Prompt tries to save settings on the exit of SSMS. An upgrade to the latest version should fix this.
This has nothing to do with the issue. I run as myself (not runas) and it occurs when I save a query(file) and rename it to a file that is already under source control, open the file and close it (per the steps listed above). Once the error occurs, it continues to occur until the project and SSMS is closed. It does not occur at close, but because of it, I have to close.
Version Information:
SourceSafe 6.0d
SqlPrompt 3.6.0.109
Thanks,
John. / comments
Brian Donahue wrote:
Hi guys,
On certain versions of Prompt, I think the RCW error message occurs when you use RunAs to start SSMS. The error can occur when Prompt tries to save settings on the ...
tanya wrote:
Hi,
When you say create a new stored procedure in project, do you open a query window to do it or is there some other way to do it?
Tried following the steps you have mentioned; however I tried to create a stored proc by right clicking the project - add a new query and it all seems to be working fine.
Am I missing something here?
Thanks for your time.
Regards,
Tanya
Yes. You create a new Query.
Steps to produce below error:
1) open project in SQL Management Studio.
2) Create new Stored Procedure in Project (New Query)
3) Past Existing stored procedure from SQL server into new file. <save file>
4) Change name file name in the project to an existing Visual Source safe file name.
5) click ok through all messages.
6) Save File
7) Check out file for editing by right clicking on the file in the project.
8) Double click the file in the project window to show file.
9) Save Query Window (File). Close window. (First Error Occurs)
10) try and open file again. (Second error occurs)
11) Close and reload project (without closing SMS) try an open file, still recieves error.
Thank you ,
John Smith. / comments
tanya wrote:
Hi,
When you say create a new stored procedure in project, do you open a query window to do it or is there some other way to do it?
Tried following the steps you have mentioned; how...
SQL 2005 SMS Errors when new query renamed to existing file
Steps to produce below error:
1) open project in SQL Management Studio.
2) Create new Stored Procedure in Project
3) Past Existing stored procedure form SQL server into new file. <save file>
4) Cha...