Editor reviews are provided by professional editors who evaluate a blog based on the following criteria: Frequency of Updates, Relevance of Content, Site Design, and Writing Style.
There are a few ways to do this, but I find the easiest is to use the float version of a datetime and crop off the decimal portion (right of the decimal place is the time portion)
DECLARE @currentDate DateTime
SET @currentDate =...
So you're trying to back up your database and you get the following error:
Failed to pause full-text catalog for backup. Backup was aborted. Check to make sure Microsoft Full-text Service is running properly and SQL server service have access to...
I've come across this issue intermittently on some servers, but I haven't figured out yet why it happens. The times I've seen it happen is when the virtual folder wasn't created with all the permissions required, and then deleting it seems to leave a...
.Net gives you access the mouse via "Cursor". You can interact with the mouse position like this:
Cursor.Position = new Point(Cursor.Position.X + 10, Cursor.Position.Y + 10);
Easy peesy
Yes, as the title says, .Net DateTime Minimum does not equal Sql Servers equivalent. For whatever reason you come across this gem of an issue you have a couple of options to get around it.
1. Use a .net Nullable datetime instead. i.e. Declare your...
