Viewing 15 posts - 301 through 315 (of 418 total)
Tnx again for your info, Allen.
On I/O problem: that surely is the case. The server in question is configured with RAID 5, not the best config for bulk data actions....
May 19, 2005 at 12:14 am
Hey Allen,
Tnx for your response. This process is running on SQL Server 2000 Standard Edition sp3A with 3Gb internal RAM. SQL Server takes as much as it needs, max...
May 18, 2005 at 8:38 am
You were right, it was. For some strange reason the SQLServerAgent was running under another than usual account...
Tnx,
Hansje
April 27, 2005 at 7:53 am
"[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters\NullSessionShares]"
This may help if you, the DBA, are allowed to do such thing on a remote server. I can think of plenty of reasons(and have experienced them) why you are...
March 4, 2005 at 12:28 am
Tnx for the info, ppl. I am aware of the several RAID configs and their pro's and con's. I'm still not sure how to physically distinguish between diskarrays. I'm not...
March 1, 2005 at 11:12 pm
Actually the reply was ment for Ishaan99. Take a look at the results. For 1 run of the INSERT statement you get double entries exactkly the same. Imagine you run...
February 10, 2005 at 9:19 am
"MS SQL Server 2000 Standard Edition server component is not supported on this operating system. Only client components will be available for installation."
I see this message only when using a...
February 10, 2005 at 9:14 am
"The Microsoft Way is to told you that SQL 2000 on Windows 2003 is not supported"
Michael,
don't know why you say that:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
If we're talking Standard Edition, then, W2003 does support it....
February 10, 2005 at 6:11 am
Why don't you try it yourself?
CREATE TABLE [AA] (
[A1] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER InsertTest ON dbo.AA
FOR INSERT
AS
Insert into...
February 10, 2005 at 12:31 am
Differences may occur and might be legal, if the subscribertables can be updated on the subscriver itself. I'm guessing from you posting this is not the case.
On comparing: with inner...
February 10, 2005 at 12:12 am
If you can connect to the backupfile on server1 from server2, you can choose this backup with the task RESTORE FROM DEVICE in EM. Alternatively you can use the TSQL...
February 9, 2005 at 11:04 pm
Are you sure you're installing on W2003 SERVER?!
February 9, 2005 at 10:59 pm
Tnx for the response Paul. As I said in my first posting I am not allowed to work on the W2003 server directly, which poses some problem.
I did some further...
January 27, 2005 at 4:31 am
It runs fine on a SQL Server 7 Standard Edition. Haven't a SQL2K setup available right now. What release are you using?
October 22, 2004 at 2:43 am
Tnx for the info all. I will sure keep them in mind.
October 22, 2004 at 2:11 am
Viewing 15 posts - 301 through 315 (of 418 total)