Archive for September, 2008

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. I’ve found a lot of solutions, but this one is the most elegant I’ve seen. CONVERT(datetime, FLOOR(CONVERT(float, DateTime))) I’ve put this into a user-defined function below: [...]

Another issue I’ve run into with the service broker and moving databases between servers is this error message: Error code:25. The master key has to exist and the service master key encryption is required. The solution that I found was the regenerate the key for the database using the following code: CREATE MASTER KEY ENCRYPTION [...]