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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.