Hi all, 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:...
any ideas?
Hello, 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...
Hello everyone, 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? Thanks
Hi all, 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...
Thanks Reply. What I am doing : select action_id, website_id, channel_id, session_id, capture_date from MyTable with (nolock) where capture_date >...
Hi everyone, Good morning. One table has around 100 million rows.two indexes: one is clustered index and another is non clustered index on datetime...
Hi All, 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,...
Hi all, 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...
Hi all, 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 Hank FieldName is column name. A1, A2 A3 is data
Datatype is varchar. I already convert into int and float.
Hello All, I need to create a SQL query to get summary data. Data like this: FieldName FieldData A1 10 A2 20 A3...
Separate names with a comma.
