quote: Like counter logs, in Performance snap in? I wonder how can this help... This time I just seen it in System monitor, Processor Time counter... If you have setup the performance counter logs properly, you will be able to see which processes eat CPU time. It might not the SQL Server. If you are […]
2003-07-23
Thank you both for your response. The script of mccork combined with the explanation of teh general formula by a5xo3z1 has helped me a lot! Gerry.
2003-07-23
1 reads
Did you use same authentication mode to register SQL Server in EM in both servers?
2003-07-21
1 reads
Hi, I found the answer to the question You dim a sqldmo.sqlserver2 and dim a sqldmo.registry2. Only then can you use registry2.backupdirectory. Regards
2003-07-21
1 reads
Hi amira, quote: What other alternatives do I have (now that is installed and working)? depending on your OS you can remove BUILTIN\Administrators and add back, if wanted, the single accounts. Although a trivial thing to do, this step should be considered carefully. You might search on this site for similar threads. Cheers, Frank
2003-07-15
I would suspect the user does not have access to these two dbs. Is MDAC version same in these two servers?
2003-07-10
You can use the Errors Collection of the ADODB.Connection object to obtain error information returned from SQL Server. Be sure, however, that you stored procedures properly issue a RAISERROR statement if they are doing their own error-checking. For instance, if your procedure contained the following: -- Do some update stuff here IF @@ERROR <> 0 […]
2003-07-02
Additional. If your are producing a proc and don't mind using a temp table then this a possible solution. create table TABLEA ([ID] int) create table TABLEB ([ID] int,[Name] varchar(10)) insert into TABLEA values (1) insert into TABLEA values (2) insert into TABLEA values (3) insert into TABLEB values (1,'Jack') insert into TABLEB values (1,'Jill') […]
2003-06-26
1 reads
In the event log there arn't other errors and the account wich sql runs is the administrator of the destination server. Anyway there are not restrictions for sql account. I was thinking if the origin of the operating system error 1130 is generated by some hardware changes after istalling sp3 windows 2000. So the solution […]
2003-06-23
From SQL BOL quote: sp_lock Reports information about locks. Syntax sp_lock [[@spid1 =] 'spid1'] [,[@spid2 =] 'spid2'] Arguments [@spid1 =] 'spid1' Is the Microsoft® SQL Server™ process ID number from master.dbo.sysprocesses. spid1 is int, with a default of NULL. Execute sp_who to obtain process information about the lock. If spid1 is not specified, information about […]
2003-05-30
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers