Tuesday, December 31, 2013
ssrs 2005
doesn't have quick totals - boo
Wednesday, December 25, 2013
Code to color all panels and tabs in a windows form
private static void setColor(Control parent,System.Drawing.Color color)
{
foreach
(Control C in
parent.Controls)
{
Debug.WriteLine(C.Name);
if
(C.GetType() == typeof(TabPage)||
C.GetType() == typeof(Panel)||
C.GetType() == typeof(SplitterPanel)
)
{C.BackColor = color;
Debug.WriteLine("writing color");
}
if(C.Controls.Count
> 0)
{
setColor(C, color);
}
}
}
Debug.Writeline
only works if the debug symbol is declared
Simple copy dtabase script in sql server 2005
BACKUP DATABASE blah
TO DISK = 'd:\blah.bak'
RESTORE DATABASE blah_blah
FROM DISK = 'd:\blah.bak'
WITH MOVE 'blah' TO 'd:\databases\blah_blah.mdf',
MOVE 'blah_log' TO 'd:\databases\blah_blah.ldf'
TO DISK = 'd:\blah.bak'
RESTORE DATABASE blah_blah
FROM DISK = 'd:\blah.bak'
WITH MOVE 'blah' TO 'd:\databases\blah_blah.mdf',
MOVE 'blah_log' TO 'd:\databases\blah_blah.ldf'
Monday, December 23, 2013
Index was outside the bounds of the array (Microsoft Sqlserver SMO)
happens when you connect 2005 ssms to 2012 DB
Subscribe to:
Comments (Atom)