Comments
Sort by recent activity
Lionel
I think that's a goo idea, but your idea and hints aren't mutually exclusive - they could co-exist.
Crispin / comments
Lionel
I think that's a goo idea, but your idea and hints aren't mutually exclusive - they could co-exist.
Crispin
I've now worked out how to do it - it was a combination of the suggestions above.
The SQL Server Browser Service has to be running and then a Firewall exception created for sqlbrowser.exe.
Presumably the service status could be detected as the application starts. Under no circumstances should there be a modal dialogue box, maybe just something on the project dialogue to start the service if local SQL Server Express instances are required. It's on this box that one's eye will be concentrating, so that's probably the best place for it (rather than the toolbar).
The firewall could be modified on installation (with the approval of the user of course).
Crispin / comments
I've now worked out how to do it - it was a combination of the suggestions above.
The SQL Server Browser Service has to be running and then a Firewall exception created for sqlbrowser.exe.
Presumab...
Neil, Mike
I had a go at disabling the Windows Firewall and it made no difference to the listing (ie the local SQL Express was absent and remote instances of SQL Server 2000 were present).
Crispin / comments
Neil, Mike
I had a go at disabling the Windows Firewall and it made no difference to the listing (ie the local SQL Express was absent and remote instances of SQL Server 2000 were present).
Crispin
Neil
Typed the name in without problems. Instant list of databases.
Thanks.
Crispin / comments
Neil
Typed the name in without problems. Instant list of databases.
Thanks.
Crispin
It prevented the activity log from functioning effectively ie the activity log started but because of the error, I had to close VS2010.
The reason that I kicked off the activity log in the first place was that one of the (many) VS extensions I have installed was causing instability and I wanted to find out which one. I suspect that the instability is not being caused by SQL Prompt but something else, but I haven't yet established which something else. / comments
It prevented the activity log from functioning effectively ie the activity log started but because of the error, I had to close VS2010.
The reason that I kicked off the activity log in the first pl...
Hi David
Objects that no longer exist or have been renamed pretty much sums it up.
Glad to hear that SQL Prompt will fix it in the future. However, it would also be useful to be able to run a check from SQL Compare because that's where the problem will be mercilessly exposed.
Crispin / comments
Hi David
Objects that no longer exist or have been renamed pretty much sums it up.
Glad to hear that SQL Prompt will fix it in the future. However, it would also be useful to be able to run a chec...