Search results for query: *

Hey @SimonSellick, Yeah I get the same thing, which would explain things. How very strange. I guess that SQL Server runs it's week from Sunday through Sunday rather than Monday through Monday as I'm trying to do. Hmmmm. Robert

Hello Everyone, Thanks very much for all the discussion, I always find working with dates a bit of a mind bender so enjoy learning this stuff. It seems that when I run Select DateAdd(Week, DateDiff(Week, 0, GetDate()), 0) I do indeed seem to get Midnight on Monday of the current week. So...

Hello Guys, I have a query which looks like this: Select COUNT(SaleOrder_ID) AS ThisWeekCount From SaleOrder Where Placed IS NOT NULL And Placed >= DateAdd(Week, DateDiff(Week, 0, GetDate()), 0) I thought that this would count the number of sale orders placed in the...

Perfect! Thanks a great deal Denis. Robert

Hello Guys, I'm looking for a little advice on how to best form this query. I have three columns in a table, these are all 'int' datatypes and represent a 'state' for the record. ConfigState int EventState int MessageState int What I'm looking to achieve is a query which if the...

Hi Denny, Well, I underwent a memory upgrade on the system last night and its been running for the past 12 hours ot so and I've not yet recieved any errors from my applications or SQL Server which is an excelent sign, the server also seems much quicker and more responsive. Looks like that...

Thanks Denny, Perhaps my first port of call is to stick another GB or two of RAM in the box and see what happens, if that doesnt fix the issue then we can try again with somthing else. Cheers mate, Robert

Hello Guys, I've noticed some really slow performance on an application which is backed by a SQL Server database and it all seemed a little stange so thought I would take a look through the server logs, and it appears SQL Server is throwing a large number of error messages, all saying. This...

Hi Denny, Just to let you know, this worked great, the DB is moved accross with no problems :-D Rob

Really? Man that is sweet! I'll give it a shot over the weekend Denny and let you know how I get one. Thanks for the advice. Rob

Hello Guys, I've got a couple of remote servers, both running win2k3 and SQL 2005 Workgroup. I'm looking to migrate one of my databases from one server to the next and thought I'd come and get some advice from you on the best way to do it. The database is currently sitting at around 7GB in...

Hi Denny, Thanks for getting back to me on this. Well, the first strange occurance is that I've come into the office this morning and SQL seems to have started up just fine :-s and my system also appears to be remembering all the passwords it had forgotton yesterday too :-s Out of interest...

As a little sidenote of informaiton, I found another forum with a thread for the exact same problem as I'm having, I've followed the steps to no avail. http://forums.microsoft.com/TechNet/ShowPost.aspx?PageIndex=1&SiteID=17&PageID=1&PostID=108800 Down near the bottom of that thread a guy...

Hello Guys, I've come into the office this morning to get spme work done and for some reason when trying to access my local SQL Express databases I get an error saying that connection is refused. So, I too a look at the running services on my system and noticed that SQL Express service hadnt...

Hello Guys, I've come into the office this morning and my Outlook 2k7 seems to have decided to start playing silly buggers with me. It wont remember the passwords for any of my pop accounts. I have done some googling around and found this tech note on the knowledge base which seems to describe...

Thanks for the information mate. What would you suggest my best plan of action is? as I'm unable to boot the system into windows and run any virus or malware scans, can I just delete the DLL from the recovery console? is that likely to cause me any problems? Thanks again, Rob

Hello Chaps, I've got a system here running XP which is blue screening on boot with the following error message: I've tried all the usual F8 boot options for safe mode and last known working configuration and those kind of things but keep running into the same error. I've also tried the...

Thanks guys, I've just run the version of the code with all those modifications and its worked perfectly. Thanks for all your input, its really appreciated. Rob

Haha! Thanks guys, glad to see I've got your scrapping with one another to get the answer. @ Woddy... this is fine, I dont want to append record, I do want to INSERT them, almost like a duplicate. @ George and Rudy, thanks for your help guys, so let me be sure of this... I need to use the ISO...

Hey Rudy, Thanks for the help mate, this looks to be along the right tracks, but it now looks as if its throwing an error at me. INSERT INTO MessageLog SELECT Device_ID , LogDateTime , LogClass_ID , Media_ID , Campaign_ID , 10 FROM MessageLog WHERE Unit_ID = 4 AND...