IT and business subjects
28-Nov-1010 Leave a comment
Triangle where each side represents a constraint
Time – Cost – Scope
Changing anyone of these is likely to have an effect on the other two
“Scope creep”
Quality could be represented somewhere. I have seen it in the middle of the triangle
28-Nov-1010 Leave a comment
Accountancy term that means PO match Advice Note match Invoice, or something of that nature
24-Nov-1010 Leave a comment
http://www.go4answers.com/Example/possible-restore-deployed-reports-68366.aspx
Yes, you can restore .rdl file from Report Manger. View your report, Click on Properties now click on Edit, This would create report defination file and would provide it for download. You can create a new report project and add this report to your report project.
11-Nov-1010 Leave a comment
Start with SQL 2005 server > Create database >
SQL 2008 server > Generate Scripts > Choose Advanced options > Script to SQL 2005 > Options of Script Schema and Data, Schema, Data > Generate
Go to SQL 2005 database > Import Data > Import from 2008 database
A useful function to consider is
SQl Server 2005 SP3 will go upto 611 where as you are retiring a SQL 2008 db which is version 655.
Do your self a favour before migrating DBs’ between different versions do a [select * from sysdatabases] and check the column VERSION. Most of us believe CMPTLEVEL if 90 will go good for version 9.0 but its the database internal version that matters.
11-Nov-1010 Leave a comment
Other ways of doing this. See other blog entries
Save version as SQL Server 2005
Type of data to script. Could use Schema and Data
10-Nov-1010 Leave a comment
ALTER TABLE [Production].[TimeSheet] WITH CHECK ADD CONSTRAINT [CK_TimeSheet_TimeEndLaterThanStart] CHECK (([TimeEnd] IS NULL) OR [TimeEnd]>=[TimeStart])
10-Nov-1010 Leave a comment
rowTS = CType(TimeSheetBindingSource.Current, DataRowView.Row, dsMyCo.TimeSheetRow
A first chance exception of type ‘System.InvalidCastException’ occurred in MyCompany.exe
[A]TimeSheetRow cannot be cast to [B]TimeSheetRow. Type A originates from ‘ProjectName, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’ in the context ‘Default’ at location ‘Project…\bin\Debug\ProjectName.exe’. Type B originates from ‘ProjectName, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’ in the context ‘Default’ at location Project…\bin\Debug\ProjectName.exe’.
Check you are converting from Rows in the same dataset. So if a table appears in more than one dataset check you are using the correct one.
10-Nov-1010 Leave a comment
Position is important. Needs to be before EndEdit
Me.TimeSheetBindingSource.EndEdit
If Me.TimeEndDateTimePicker.Checked = False Then
rowTS = CType(CType(Me.TimeSheetBindingSource.Current, DataRowView).Row, dsMyCo.TimeSheetRow)
rowTS.SetTimeEndNull()
End
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 )
Stephen Shakespeare 
