Search results for query: *

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

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

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

Has anyone done or read of benchmarks on SQL7/8 use of four processors in executing queries? Are four twice as fast as two?

We have nightly scheduled jobs which cook along fine for several weeks, then without any known cause, SqlAgent(NT service) shuts down. Normally, MS SqlServer(NT service) continues to run (except over this last weekend, when it also stopped.) This has happened on two servers, although only once...

My code is running command line DOS from a batch file and producing text file output. The command needs be done before the text file is rewritten (else, user gets old message). I'm using GetNumTasks function to test for this. Error occurs...

My code is running command line DOS from a batch file and producing text file output. The command needs be done before the text file is rewritten (else, user gets old message). I'm using GetNumTasks function to test for this. Error occurs at "Num_Apps = GetNumTasks()". The message...

I need to create and run various command line jobs and decided to use "sp_add_job, sp_add_jobstep, sp_start_job".  Referenced in SQL Books Online with examples.  Have 3 servers.  These procedures aren't on any of them in 'master' or user...

I ran a test to force a log full situation.&nbsp;&nbsp;I created a test db with automatic expansion (1MB).&nbsp;&nbsp;The log file was created at 1MB with no expansion.&nbsp;&nbsp;I set up an alert with email to me and system operator - also net send to both.<br>I ran an insert to five (integer)...