Search results for query: *

I have a SQL Server 2000 sp 3a server and recieved this error on a transaction log restore. Any ideas on what caused this? Executed as user: USTRESCHIRES1\SQLDBADMIN. Processed 30488 pages for database 'dlsn1_tilt', file 'TILT_Log' on file 1. [SQLSTATE 01000] (Message 4035) Deleting...

I am setting up the permissions for a Production Support staff to be able to monitor SQL Agent tasks, what do they need permission to to have the status field updated in EM? Thanks Jim Lepp

This morning when I was trying to view all of the scheduled jobs on a SQL Server 7.0 box via Enterprise Manager I recieved this error Error 22023: SQLServerAgent eceeded the allowed timeout for creating the shared job list. The jobs cannot be enumerated. After bouncing the SQL Server Agent...

Does anyone know how to encrypt all of the data in a column in a table in SQL Server 7.0/2000? Later jimmY

Does anyone know how to use paramters in a select statement. I thought is was something like this SELECT 'Drive %s has %d space free', @drive_letter, @space_free but all i get back is Drive %s has %d space free C 2000 what I want is Drive C has 2000 space free Thanks for your...

For a specific job that logs onto another server I get the error Executed as user: USTRESACC\cccsqladmin. Login failed for user 'USTRESACC\cccsqladmin'. [SQLSTATE 28000] (Error 18456). The step failed. which means I need to change who the SQL Agent is running under, but I can't, seems that...

Hi, I am trying to pull data from a remote SQL Server database on a regular schedue. When I run the procedure in QA it work great, when I try and run the job from a scheduled task it fails with this error : Msg 18456, Sev 14: Login failed for user '\'. [SQLSTATE 28000] Seems like SQL Agent...

I have created a script that will check out CPU information on another computer vi WMI. When I run the script from my computer (windows 2000 sp 3) and to check the CPU on my own computer I get this error c:\work\autocheck\checkCPU\test2.vbs(40, 1) (null): 0x80041013 there is only one NT...

I have two SQL Server 7.0, one is the primary app server (machine A) and the other is A's warm standby (machine B). Currently today all of my warm standby jobs fail when they are trying to copy the transaction file from A to B. Here is the complete error : OLE DB provider 'STREAM' reported an...

Has anyone seen this.... On one of my SQL 7.0 sp 4-ish (version 7.00.1021) server's I have been seeing a 100+ failed logins within one minute. After running a sniffer on the machine we found that the attacker appears to be opening a connection to port 1433 (SQL Server's Port) and then running...

I have setup four mainteance plans for a SQL Server 2000, since the server is only used as a Warm Standby I setup the maintenance plan for the system datatabases only. The problem is that the plan's executed without problem until two weeks ago and now they are failing with the error, Memory...

Is there any way for SQL Server 7.0 to be able to trace where failed login came from. It seems that I have some program that is runnning through all of the sql logins trying to gain entry into the database server. I have over 100 failed logins within one second. I am going to start a sniffer on...

Is there a way to get the current CPU Utilization out of SQL Server Query Analyzer. All I have found is SELECT @@CPU_BUSY which seems to show how much time the CPU has spent processing SQL Server requests, but what I want is something like current % total used, and current % used by just sql...

I am trying to get the CPU utilization from remote Server's and place that data into a table via a script. What would be the best way/tool that would allow me to get the CPU utilization from the remote machine, keep in mind that it could be Winows NT or Windows 2000. jimmY [pacman]

I work at a remote location where I locally support central developed systems. Currently, I am testing the fail over for one of the systems. The biggest portions of this fail over is restoring the SQL Server Databases from the Primary Server to the Backup Server. The central office folk want me...

Currently I have a server printing reports to an offsight location throughout the day. Right now I am stuck on trying to create a WBS script on NT 4.0 that will check how many jobs are in the print queue. I have found how to get info about everything for the printer but how many jobs are in it's...

Using WBS on an NT 4.0 server, I am trying to create a script that will check for new error events every ten minutes. How would I access the NT Event Viewer, the population file seems to be encrypted. Thanks jimmY [lightsaber]