Search results for query: *

I want to restrict a particular user to only see one particular directory when they log on. They will be logging on through Remote Desktop. Now when they logon they see the root directory and can go into any folder. I know i sound gormless but i think it is because there is a group of everyone...

My customers are concerned with fraud happening on their system and want to record the IP address of machines accessing their system. I'm using ASP pages with SQL Server 2003. My customers are using generic admin logons so many people could use the same logon. I appreciate this is deeply flawed...

My customers are have problems with fraud and want to store the ip address of the computer doing certain tasks and storing it with the task details in the db. The aim being to identify which PC has done things which are suspicious. Assumming fixed IP addresses is this possible? thanks mike

I'm trying to automate backups through the SSMS using Maintenance Plans. However when i click on Management i get SQL Server Logs, Activity Monitor, Distributed Transaction Coord and Legacy as options whereas I am expecting Managemnt Plans and then have a wizard or new option. Under Legacy there...

I've just moved from sql server 2000 to 2005 and the following procedure no longer works. The only way i can get the sort to be passed as a parameter is to create a sql string as sorting by a parameter, e.g. sort by @sort does not work. The stored procedure works if i exec it from Management...

I've just moved server and am having problems with a timeout accessing through Remote Desktop. Firstly and it's not a big deal is when i have an active session but have not done anything for a few minutes it times out and stops any programmes i might be running. Is it in my control to change the...

I'm using sql server 2005 and need to alter permissions on a particular table. The table is in use supporting a website so when i go into server management studio, right click on the table and try to change permissions in table properties i get a time out as the table is in use. What is the best...

I'm moving from one windows 2003 server to another, on my old one i can send emails using a script but the exact same script fails on my new server. When i look in the bad mail folder the error message is Diagnostic-Code: smtp;503 This mail server requires authentication when attempting to...

I am struggling to get different FTP logins to access different directories on my windows 2003 server. I only have 1 IP address so what I am doing is creating virtual directories under my default ftp site. Now whenever i create a new ftp site and i try to logon i go to the directory set up in...

I have set up a new FTP site on my server fine but cannot set up a second, when i try i get a message saying a duplicate name exists so cannot be started. When i try to start it i get a message saying that i can only have 1 FTP siteper IP address and port value so how do i set up multiple FTP...

I've just got a server from WebFusion which has just a C drive with 160 gb space. I've been trying to find a way to create a D drive with most of 160gb as my data drive. I'm running Sql Server applications with data of about 10gb. Can I do this and if so is it worth doing? I can't rebuild the...

I want to update 3 fields in a table of summarised data derived from another table. The update below works fine if i update just one field but any ideas how i can update more than 1 field at a time? update top100 set jantotaltransactions = (select count(t.memberid) from pts_transactions t...

I can open a window in a javascript function as function poptastic(name,widthy,heightx) { url="images/locations/"+name ; newwindow=window.open(url,'name','height='+heightx+',width='+widthy); if (window.focus) {newwindow.focus()} } but how do i prompt the user to close the popup? I know...

I had Perl 5.6 installed and then i updated it to 5.8.8. Now when I run a program that uses the DBI module it fails with an error of "This application has failed to start because Perl56.dll was not found". When i look in the bin directory there is no perl56.dll file but there is a perl58.dll so...

I've inherited some code that parses some pages on a website, a new version of that website went up and now my code no longer downloads a simple home page. I think i've narrowed the problem to 2 lines of code which are $cjar=HTTP::Cookies->new (file=>"../cookies/cookies.txt", autosave=>1...

I'm worried about the size of a transaction log filling up my whole server so have read up on truncating the log but it appears to remain the same size after all the things i read are recommended. My .mdf file is about 2gb and my logfile is about 14gb so what i've tried is: 1) I do daily full...

I do backups of several databases everynight and have used them to repopulate test databases on a regular basis. However i just want to make sure that if i set up an entirely new server and load up sql server will i be able to restore a backup file and it will contain all information necessary...

I currently have a sql server 2000 db and several websites on the same physical server. I now want to be able to access the db from web pages on another server. I want to restrict access to just stored procedures so there is no access to the data tables or to sql analyser etc. What is the best...

I'm using SQLServer 2000. Sometimes when I want to do a restore it fails as I cannot get exclusive access. Is there anyway to force the backup through? I am just doing it manually through EM at the moment but I would also like to know how to do it if i set up a scheduled job. As an entirely...

I've been running a maintenenace plan backup and individual jobs backing up individual databases and want to know if this is necessary. The way i'm doing it now is partly down to ignorance and partly wanting to cover all bases with the downside of using up a lot of diskspace. The downside to...