Search results for query: *

Thanks for the reply. Ideally when somebody logs on they would only see their own directory and sub directory so they would not see all the directories on the root directory but otherwise if that is not straightforward then stopping them from viewing directories would be fine so for eg if my...

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...

Hi, Thanks v much for this. However when i try to query this table with a query like select * from sys.dm_exec_connections i get a message invalid oblect name so looking this up i think i need to give myself rights to view the table so i tried grant view server state to adminstrators but...

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...

Hi, Thanks for the reply. I'm using ASP pages with SQL Server 2003. My customers are using generic logons so many people could use the same logon. I appreciate this is deeply flawed but this is the way the customer wants it. In order to identify the individual doing the transaction the customer...

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 have Microsoft SQL Server Management Studio version 9.00.1399.00 but can't see how to tell if that is express or not. Do you know? Thanks again mike

I've run a query on the SSMS and it is telling me i have the standard edition but is it posssible that management plans could have been disabled at installation? It was me who did the installation so i certainly didn't mean to not install them. 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...

Thanks for the security advice above, i've changed the way i do it and will read up more about the ideas above. i appreciate your time mike

no by default it is sorting by descending balance so balance desc is right, thanks for trying though! mike

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...

ok i'll look at this but it looks like you should only need authentication for a remote smtp server whereas mine should be local. I'll give it a go though, thanks mike

Yep, i think so, on IIS there is a default SMTP virtual server running and all the properties seem the same as on my old server. thanks for the interest, any other ideas? mike

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...