In TSQL on SQL Server 2005, how do you get the time part from a datetime field?
SELECT CONVERT (VARCHAR (8), YourDatetimeField, 108)
If you change the recovery model for a SQL Server database from Simple to Full, log shipping will not kick in automatically. Continue reading
In SQL Server Management Studio, how do you export database diagrams into another application like Microsoft Excel?
Creating database diagrams in SQL Server Management Studio can be a useful exercise. It allows you to visually see the structure of your database tables and the relationships that have been created between the database tables.
While it is useful to see these database diagrams, people often ask How can I export my database diagram from SQL Server Management Studio to another program like Microsoft Excel? Continue reading