I have a VPN set up which allows me to access files on my office server. However I have Outlook set up to recieve pop3 emails and when I am connected to my vpn I cant send emails. I get a message bouncing back with the error code 550 relay not permitted. The reason for this is the smtp server my...
I have an exchange server which pulls down all emails from a catchall pop box and distributes it to users with matching email aliases. However I also have two users external to the office who both use seperate pop3 boxes on the same domain. When I try to send an email from an account on the...
Hi guys hope you can help me with this one.
I am using GetDate() in one of my stored procedures, but I need to add one hour onto whatever date/time GetDate() returns. How can I do this?
Thanks for any help in advance.
"It's so much easier to suggest solutions when you don't know too much...
I have an exchange server which pulls down all emails from a catchall pop box and distributes it to users with matching email aliases. However I also have two users external to the office who both use seperate pop3 boxes on the same domain. When I try to send an email from an account on the...
Hi guys, hope you can help shed some light on this problem.
I am trying to create a public folder in Exchange system manager. It allows me to enter the name of the public folder i want to create but when I click ok i get the following message:
Exchange System Manager
Facilty: Win32
ID No...
Hi guys, hope you can help shed some light on this problem.
I am trying to create a public folder in Exchange system manager. It allows me to enter the name of the public folder i want to create but when I click ok i get the following message:
Exchange System Manager
Facilty: Win32
ID No...
I have 5 pcs that are currently running Windows XP. I am going to format all 5 and install windows XP Pro on them. Before I do I was wondering is there a simple way I can back up all the drivers that the machines are currently using so that when I install xp pro on them I can quickly and easily...
The company I work for currently runs an SBS 2000 server which using exchange pops a pop3 mailbox and distributes the email to users every 15 mins. This is the shortest setting this can be set to using SBS 2000.
Another company I am involved with are interested in using SBS 2003 and want to...
This may be easier than I realise but if anybody could help me with this I would appreciate it.
I want to build a stored procedure which takes a date and some details about a user. I want it to compare the date with the current date/time and if it is not passes the current date/time insert the...
Ok could somebody tell me if the following is possible and how I could go about achieving it?
I have two querys the first simply returns a column of IDs and another column which is the related names to these IDs. The second query takes an ID (ones from the previous table) and returns the number...
Hi hope I can explain this well enough.
I have a datagrid which displays the results of a query (i.e. they are bound to this datagrid). And that works fine. However I have another query which returns 1 column and 5 rows. I want the text in each of the 5 rows to be the heading of each of the...
I have several Windows XP machines on a domain, they all have service pack 2 installed with the exception of one test box.
At some point after the installation of service pack 2 i noticed some problems with the machines. The following problems are ones that all win xp sp2 machines on my...
Hi I have a variable which is of type string, it contains the value 1.676432. I was wondering how can I convert this to a decimal number rounded up to 2 decimal places?
Any help with this would be really appreciated.
Aaron
"It's so much easier to suggest solutions when you don't know...
Hi guys, bit of a weird one this but wondering if anyone can provide some further information on something i have been thinking about.
Im currently building a website which allows users to register accounts. Now I was thinking about how I could, using ASP.NET, create some kind of IP banning...
Ive been looking at some example case statement syntax on a few websites, but every example i have seen has the case statement directly after the SELECT of a query. I wish to use CASE after the WHERE section of a query, is this possible? or is it not possible to do this and that is why i have...
I have a table which contains a column which is a datetime column, and contains dates in the format dd/mm/yy hh:mm:ss.
I am using a stored procedure to select the dates from this table. However i wish to format them differently. I want the stored procedure to change the formatting of the dates...
Hi all, hopefully I can explain this clearly enough. If anyone can shed some light on this i would be very greatful.
I have a javascript countdown timer in one of my .aspx pages which countsdown to a particular date time. The datetime to be counted down to is retrieved from a database. This is...
Hi guys I have a string which contains the html for a table, here is an example row:
<tr class="r2">
<td class="c1">1</td>
<td class="c2">12<td>
<td class="c3">29</td>
<td class="c4">40</td>
<td class="c5">75</td>
</tr>
what I wish to do is replace all the <td class="c1"> with just...
Ok this may be a bit of a newbie question but here goes anyway:
I have a field in a database which contains 5000 characters, I want to display a particular amount of these characters (say 100) in a template column of a datagrid. Then after them provide a link which when clicked loads a new page...
Ok guys bear with me as i attempt to explain this one.
I have successfully created some rollover buttons with css for the navigation of my website. However when the link is clicked and the new page is loaded the buttons are all the default un-hovered colour. I would like to keep the button i...
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.