SQL server 2000 SP4 is running on active/passive clustered nodes. Every node is Windows 2003 64bit 4 CPUs and 8GB Ram.
Pagefile.sys on C:...
My Situation is
sql server 2000 EE Sp4
windows 2003 EE. 4CPU 8G RAM
Dedicated Server, running Fulltext index.
Sp_Configure: Min Server...
Hi,<br /><br />when I use gthrlog.vbs to read the fulltext log files, I got "Could not create object named "MSSearch.GatherLog.1"<br /><br /><br...
Thanks for reply.
Yes, I checked the following things, all is no problem.
1. MSDTC is running on both server.
2. Select @@Servername
3. network name...
I met one problem about distributed tranaction.
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was...
I got same situation. Do you get solution?
I am new guy to SQL 2000 AS. Right now I met a problem about how to populate dimension table.
My situation is:
Fact table structure:...
Hi,<br /><br />I have fixed this problem.<br /><br />under : ServerA->Security->linked server->ServerB-><img...
quote:Originally posted by MohammedU
Login to ServerA as SA and run the "select * from ServerB.report.Dbo.events" statement...
and see what you get?...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Hi all,<br /><br />Thanks for all your help.<br /><br />I created one job to run stored procedure on server A.<br />this Stored procedure will access...
What I am doing :
select action_id, website_id, channel_id, session_id, capture_date
from MyTable with (nolock)
where capture_date >...
One table has around 100 million rows.two indexes: one is clustered index and another is non clustered index on datetime...
Through EM, Only one TABLE in database could not open. Other tables in same database have no this problem.
When I right click the table,...
This is Second time that SQL Server Stoped in this week(It happened since I updated Server from Sp3 to Sp4). I checked the Event log in...
I need to create one report using Reporting Service.
Dataset like this:
ActionDate ,ActionName , ActionData
Jan-06Number of Page...
quote:Originally posted by HankS
How about SELECT sum(a1), sum(a2), avg(a3) FROM XXXX
FieldName is column name. A1, A2 A3 is data
Datatype is varchar. I already convert into int and float.
I need to create a SQL query to get summary data.
Data like this:
Separate names with a comma.