Recent content by BootMeUp

Depending on the uptime required for your systems, you could just shutdown sqlserver service(say 7:00 PM once a week) and run your antivirus on the mdf/ldf files. I would assume hackers can get into these files just like any others - so this would provide some security without a lot of coding.

I typed this from my notes and saved it. It is exactly what I used. I decided to do this in case someone else might need to do the same procedure. I had to do this for a production server, so I had to learn quickly and make no mistakes. I would recommend testing an easily recoverable folder...

Mark, Thanks for responding. I have been able to successfully remove the "special" permissions from the User group in all folders. I felt since that was the real problem, why unplug something else. I did also discover that desktop windows xp machines have the same special permissions, except...

We have a pair of Dell Windows 2003 Servers (identical). The other day an experienced user discovered he could copy files to folders, copy files in folders, and delete them, in an area where he had no explicit permission to do other that read/execute. I found a new group in the tree of folders...

We have installed 64 bit Dell/windows 2003/dual 3.7ghz dual core/16gb ram/sql2k 32 bit. In a controlled sql query retrieving 200k rows, this setup takes 1.8 avg seconds compared to same query on HP/windows 2000/4 700mhz/8gb ram/sql2k 32 bit, which runs in 6.38 seconds avg. Both use 10k rpm...

We are planning to install 64bit servers, running Windows 2003 server 64bit, using SQLServer 2000 32bit edition. Has anyone been able to do this successfully? If so, were any adjustments/tuning necessary when and after installing SQLServer 2000 32bit on a 64bit server? Additionally, was there...

If you haven't already found a solution, check to see if you have a firewall on any of the machines which blocks non-trusted IP addresses. Turn off firewall to see if can connect. If so, then allow the IP addresses of your machines in the firewall(s) trusted zone. I just had this experience...

If your main problem is query speed, and you're comfortable with Access, I'd consider adding as much RAM as you can. It's as cheap as it will ever be. A computer will put as much program in RAM as there is RAM, and runs about 100 times faster than disk. What it can't put in RAM, it leaves on...

If you're considering Desktop SQL Server for your own use, I'm not sure how much that would help with file size. You'd be using same platform. The advantage of SQLServer on a server system, is primarily to provide many live connections to multiple databases for multiple users. Typically a...

Perhaps I should start a new thread but will start here. We're running scheduled SQL Maint jobs which submit a batch file (.bat) using 'xp_cmdshell'. The batch contains a command line, which runs an application to load data to a table. Periodically (every 3 to 10 successful runs) the command...

We're having intermittent failure of 'sqlmaint' on an Advanced W2K server (4 processors, 8GB RAM). This occurs in jobs run in the wee hours to load data, backup db's, etc. To my knowledge, this hadn't happened until recently when I installed two MS security patches, 'MS01-060' and 'MS02-007' ...

In order to automatically provide "last update" date for several tables, I need to find a system table or other source which reflects the last date/time the table had any changes (ok), but preferably only "update". I tried to use a trigger on the table, however, because of...

mahdood, I downloaded the patch. Thanks Steve A.

After several years of running this server, with the usual number of reboots, we are getting a message about "hpgate". The message primarily refers to "The desrciption for Event ID 22 in Source (hpgate) could not be found... Contains the following insertion string: MPS 1.4 APIC...

1)How do you safely change the limit (or amount) of dynamic memory available to SQLServer (I have heard that more than just changing the server properties is necessary with W2K Advanced)? 2)What is the safe max amount of dynamic memory alloc for SQL on a server with 8 GB RAM? 3)Is there a...