SQL Server

Combining Date and Time in DTS To Make a DT_DBTIMESTAMP datetime

less than 1 minute read

I was recently dealing with importing a DBISAM (Btrieve) database to SQL Server, which had separate date and time columns where I wanted to import a DateTime...

Creating GUID Derived Column in DTS

less than 1 minute read

If you want to add a constant GUID to a table during a DTS transformation, it’s a little tricky. Here’s the solution.

Extracting The Date From a SQL DateTime In SQL Queries

less than 1 minute read

Ever wondered how to quickly and easily get the date portion of a datetime field in a SQL query? Seems like it should be easy, right? Unfortunately, it isn’t...

SQL Server 2005 Service Broker Error Code 25 (Event ID 28054)

less than 1 minute read

Another issue I’ve run into with the service broker and moving databases between servers is this error message:

SQL Server 2005 Service Broker Error 15517

less than 1 minute read

Sometimes I’ve run into the following error in the event log when using the service broker to do SQL command notifications with SQL 2005: