How can we help you today? How can we help you today?
davidmgray
Activity overview Badges (0) Posts (6) Comments (7)

Comments

Sort by recent activity
Anu Deshpande wrote: Thanks for your post . Answer to your question is 'Yes' you can do it! Please follow the following steps to remove SQL Prompt integration from Visual studio and still have it in SSMS: 1. In Visual Studio go to Tools --> Options --> Environment --> Add-in/Macros Security --> Remove the Add-in file Paths for SQL prompt then Press 'OK' to save the changes. 2. In Visual Studio go to Tools --> Add-in Manager --> Untick Available Add-ins for SQL prompt 3.0 then Press 'OK' to save the changes. 3. Please again open the Add-in Manager in similar way (Tools --> Add-in Manager) and check if the SQL Prompt add-in is not in the list. 4. Close Visual studio. 5. Open Visual Studio Command Prompt run command 'devenv /resetsettings' : this will reinitialise the visual studio settings. 6. Check Visual Studio having no more SQL Prompt integrated in it. 7. Check SQL prompt in SSMS it should be intact. Kindly let me know if you have any issues carrying out this steps and if that helped you to disintegrate SQL Prompt in Visual Studio. Thanks, that worked a treat. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Visual Studio 2008 integration
Anu Deshpande wrote: Thanks for your post . Answer to your question is 'Yes' you can do it! Please follow the following steps to remove SQL Prompt integration from Visual studio and still have it...
0 votes
Hi, Thanks for the info. Can you back up direct to a share, e.g,. \\server\share or do you need to back up via a mapped drive letter? Dave / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Network backup
Hi, Thanks for the info. Can you back up direct to a share, e.g,. \\server\share or do you need to back up via a mapped drive letter? Dave
0 votes
That's great, thanks. Dave / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Filter SQL2005 statistics
That's great, thanks. Dave
0 votes
james.billings wrote: I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects. That sounds like it may help with your problem, so could you install it and see how you get on? That's fixed it, many thanks. / comments
  1. Community
  2. SQL Dependency Tracker
  3. Same table in two seperate schemas
james.billings wrote: I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects. That sounds like it may help with your problem, so could you...
0 votes
james.billings wrote: I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects. That sounds like it may help with your problem, so could you install it and see how you get on? Hi, Thanks I will give that a try. However it was not just that the schemas weren't being displayed, it was that when there were duplicate objects in two different schemas, only was was showing. Dave / comments
  1. Community
  2. SQL Dependency Tracker
  3. Same table in two seperate schemas
james.billings wrote: I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects. That sounds like it may help with your problem, so could you...
0 votes
Have you tried wrapping the the table name with square brackets, e.g. [Item]? / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Promt will not work on table named "Item"
Have you tried wrapping the the table name with square brackets, e.g. [Item]?
0 votes
Hi, Yes thanks, that's got it. Dave / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Disable SQL Prompt 4 in Visual Studio
Hi, Yes thanks, that's got it. Dave
0 votes
Total activity
19
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
6