Recent content by mikelawrence

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