Search results for query: *

All I have to pick one of the many solutions on offer for measuring the number of hits to a site, originating IP address, time on a page etc. etc. I am hoping some one can recommend the market leader. The system is all .Net based. all help is appreciated, thanks !

All I am running a custom built C# executable on a Windows NT platform, it runs fine with up to 3 simultaneous instances (this constitutes up to 12 threads). However re-platforming onto Windows XP is proving problematic. I run out of memory very quickly !!! The XP box however has twice the ram...

All Is it possible to lock an single row in a table in access - if so how ????? thanks old goat

All Hopefully you can advise on this, I have a series of asp pages that I have not been responsible for developing, in numerous cases connections are opened and not closed. I am wondering if this could be the root cause of the memory spiralling out of control and the server crashing about once...

Anyone have any suggestions for a good dll to read the event log, some pseudo code would be nice if you have that too ????? hope someone help old duffer

All Has anyone any tips or good quality pseudo code for reading the NT event log into a recordset. I would ideally like to specifiy a server name (UNC format) and have the code pull back the records from the specified log (e.g. application) and dump this into a recordset I'm expecting to have...

Use your code behind the form to output a message box with the contents of the combo box immediately before your query MsgBox("CP-" & [forms]![frmRep]![cboRep] & "*") I expect it is just returning "CP-*" and therefore selecting all records, have a look and see if...

All I have a small database of just 400Mb -the log file has been allowed to grow constantly over the past year and has now reached 4500Mb!!! I have therefore performed a backup of all the files and executed a checkpoint. I then ran DBCC SHRINKDATABASE (With Truncate Only). The log file has just...

If you log in to your live database as administrator (sa) then all stored procedures will be created with an owener of dbo unless you have specifically specified this in the procedure code. The fact that the ownership is not dbo could easily cause the problems you are experiencing

Dear All Any suggestions for the resolution of the following error: Error 720: The connection attempt failed because your computer and the remote computer could not agree on PPP control properties. I am trying to dial into a local ISP from a machine I have just built from scratch using backup...

All Does anyonw know if it is possible to convert the data type of a field from within a query. I have a char field (on the MSSQL7 database at the other end) and want to convert this into a numeric. Access wont allow me to perform a CONVERT(numeric, <fieldname>) as this is apparently not a...

All Hope you can help with this one; Over the past few weeks I've been receiving too many errors for both the checkdb and shrinkfile commands. Last night for example the DBCC checkdb failed because it could not access a data page, I think an earlier failure with the shrinkfile may have been...

All Hope you can help with this one; Over the past few weeks I've been receiving too many errors for both the checkdb and shrinkfile commands. Last night for example the DBCC checkdb failed because it could not access a data page, I think an earlier failure with the shrinkfile may have been...

You can concatenate two fields using the plus symbol and collect the correct footnote using a simple where clause, try the following: SELECT Part.VID, Part.MFG, Part.DESCRIPTION + Foot.Footnote FROM tblPart as Part, tblFoot as Foot WHERE Part.FN1 = Foot.FootNoteID OR Part.FN2 = Foot.FootNoteID...

Your code is probably correct, access likes to grumble a lot about which line the code is on, the following should be fine, have as many ELSEIF's as you like, keep this line structure, let me know how it goes dim maxvalue as int IF [text1] = 'Apples' THEN @maxvalue = 13 ELSEIF [text1] =...

Hod Paste your query and it'll be fixed in a jiffy, it sounds like you are checking against a return date or return from repair date in your where clause problem is these will all be blank if the equipment has never been on loan or has been repaired. If you set all the blank date fields to...

Michael In your SQL statement that returns your information you want to have a where clause like that below: ******** SELECT birthdays FROM mydiary WHERE birthday > dateadd(d, -7, getdate()) AND birthday < dateadd(d, 7, getdate()) ******** -getdate() will return today's date from the...

sorry wrong code in the above message use the following Create YourProcedure @parameter1 char(20), @parameter2 char(20) as set rowcount @parameter1 update tablename set in_use = 'true' WHERE some_condition = @parameter2 select * from tablename WHERE some_condition = @parameter2 thats better

Mr Haddock There are something called DBCC's which have a lot of in-built management functionality, use the following to shrink the size of a database or log file. Look in books on line for more information hope this helps Checkpoint go DBCC SHRINKfile (yourfile)

MadJock Need a bit more information to solve that one explicitly but look at the example below, this sets your in_use field first and then returns the same set of rows, the number of rows returned is based on parameter one and restricted by parameter 2, update this as necessary (and dont worry...