IT and business subjects
10-Nov-1010 Leave a comment
At top of frm.designer.vb there is following code.
If get really stuck then rem out System.Diagnostics…. and put a breakpoint here
You may want a try catch block around code that opens the form
09-Nov-1010 Leave a comment
Useful
Would encourage more use of List(of )
08-Nov-1010 Leave a comment
Aggh
Laptop Win7 SQL Server 2008 R2 SSMS has worked for a couple of months. Suddenly stopped working. SQL Server was still working becase VS-TFS still present.
Log file lookups on Web search suggested all sorts of possible directions to solve including:
Permissions on Network Service, Reinstall SQL Server performance monitors using unlodctr sqlctr.ini or something
Reinstalling SSMS did not work
Anyway what did work was Restoring back two weeks.
08-Nov-1010 Leave a comment
Do not use default setttings. See
http://support.microsoft.com/kb/315512
You can view the current settings through the database properties in SQL Enterprise Manager (SEM). Or, you can run the following Transact-SQL command:
sp_helpdb [ [ @dbname= ] 'name' ]
Stephen Shakespeare 