Activity overview
Latest activity by davidmgray
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
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...
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
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...
Same table in two seperate schemas
Hi,
SQL 2005
I have two tables with the same name in different schemas. I would like to check the dependancies on one of them but it appears I'm unable to choose the schema.
Only one is shown in t...
Hi,
Yes thanks, that's got it.
Dave / comments
Hi,
Yes thanks, that's got it.
Dave
Have you tried wrapping the the table name with square brackets, e.g. [Item]? / comments
Have you tried wrapping the the table name with square brackets, e.g. [Item]?
Disable SQL Prompt 4 in Visual Studio
Hi all,
Can anyone please tell me how to disable Sql Prompt 4 from within Visual Studio 2008 (VS2008)?
Sql Prompt is great in SSMS but if I'm debugging a procedure from within VS2008 it just gets i...
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
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...
Visual Studio 2008 integration
Hi,
Is it possible to stop SQL Prompt integrating with VS2008? It's a great tool in SSMS but I dont see the point in VS2008.
Also I started having problems (brace matching stopped working) with VS...
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
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
Network backup
Hi,
Can Red Gate Backup software backup & restore databases over network drives?