I am running SQL 2000 SP4.<br /><br />Here's my table:<br />CREATE TABLE [BIGHUH] (<br />[LOGIN_ID] [char] (10) NULL ,<br />[NAME] [char] (40) NULL...
Windows 2000 Advanced Server (latest service pack) SQL Server 2000 Enterprise Edition (8.00.2187) 1. Server can see other machines in network...
Over the last 24hrs my backup speed has went from about 20-30 MB/sec to 2-5 MB/sec. The backup job is the only thing running on the server at this...
I am having trouble getting this script working in my ActiveX task: Dim iConf As New CDO.Configuration Dim Flds As ADODB.Fields Set Flds =...
Does anyone have any reason for me to not goto version 8.00.2187? I am talking about the hotfix in this link:...
Before I start poking around in the system tables, I figured that I would ask around on some forums first. What I want to do it two things: 1....
Ok, I am frustrated. I specify my active X object to use VB Script as the language for my code. Half of the VB code that I write won't work in the...
I have stored procedure that I don't want 2 copies of it running at the same time. How do I check if the stored procedure is already running in...
Here is the command that I need to run INSERT INTO #B SELECT TOP @TOPCNT FROM #A My first problem is that I can't use a variable as the parameter...
Here is my query: SELECT LTRIM(RTRIM('')) If I run this in one of my databases it returns NULL, in another one it returns a blank line. What...
ERR is a column of char(255) How can I speed up this reference? LEN(RTRIM(LTRIM(ERR))) > 0 I need to find out if there is anything in ERR that is...
What is the use Alias tab of this utility? I have found little info on the web and the help files only tell how to modify this tab. What...
I have 2040 installed on all my servers and I have been having some memory problems on the main production server during high utilization. What is...
This past weekend we added 2gb of memory to our server, bring it to 8gb. We are running Win2000 Advanced Server with SQL Server 2000 Enterprise...
(SQL Server 2000 Client tools on a XP Pro Workstation accessing a SQL Server 2000 Enterprise with Windows 200 Advanced Server.) I try to go in and...
Two of my jobs got errors last night. One was at 9pm and the other was at 6am this morning. Both jobs had the server to themselves. Here's the two...
I know that I could cmd_shell out and run the FTP command. Does anyone know how I could FTP in TSQL without using the cmd_shell? I have looked...
I need to change text inside a text file. The order needs to stay the same. The file name won't be known until I pull a directory list. Attempt...
Is there a way to check if a procedure is running through TSQL? I know that I can just pull up current activity and look. I need to write a...
30gig database 5gig trans log I am looking in Enterprise Manager in 2000 and when I pull up properties for the database says that my database size...
Separate names with a comma.
