SQL 2000 = sp3a and SQL 2008 = sp2
SQL Server 2000 = service pack 3a and on sql server 2008 i have service pack 2
yes its transactional replication. I am replicating from sql server 2000 to sql server 2008. My distributer db and subscriber is on sql 2008. And my...
Hello I am replcating data (tables only) from SQL Server 2000 (SP3a) to SQL Server 2008 (SP2). Everything work fine I dont get any error copies the...
HiI have SQL Server 2005 enterprise edition running on Xeon CPU (4 processors) with 8GB ram. Antivirus Symantec also running on the same box as SQL...
I am trying to connect to crystal report 9 I get this errorLogon FailedDetails: ADO Error Code: 0x80004005Source: Microsoft OLE DB Provider for SQL...
I imported dts from SQL Server 2000 to 2005 and they run fine without any problems. I want to find out if there is a way I can schedule sql 2000 dts...
Hi Is there anything like Slow and Fast bulk copy in SQL Server 2005 (ENT edition)? I am using DataMirror software to replicate data from DB2 to SQL...
Hi I am running SQL Server 2000 (ent edition) on windows 2003. My server is running slow but task manager shows that cpu performance is low, like...
Execution plans shows sorting takes the longest. Can you or anyone else please answer my question#2
I have 2 questions1) One big index performs better then 2 small indexes or the opposite?2) I have table with 17242772 rows and I have index1 and...
Hi Can anyone tell me how can I find how many indexes I have in my database and what's their size? I am using SQL Server 2000 (Ent Edition). Thanks
well it is running kind of slow. I think it can do a little better. I will do the audit and put my result here. Thanks for your help.
Hi guysJust want to ask, my SQL box task manger showing that SQLservr.exe is using 1.3gb of memory and its CPU time is 24:15:27. System idle process...
I am searching if transactional replication can be setup from DB2/AS400 (as publisher) to SQL Server enterprise edition (as a subscriber) without...
Here is the article I like about SQL replication. http://www.sql-server-performance.com/articles/dba/sql_server_2005_replication_gui_p1.aspx
Sorry Satya even after reading the article 2nd time. I did not understand how to configure publisher on AS400/DB2. Article does talk about...
Ok guys I am connected to DB2. I can query the db2 tables and see its data. Now the question is do I have to install something else to see DB2...
I already installed the native DB2 drivers. Now I have to get some info from DB2 DBA. And have to explanin him what every information means becasue...
I have to replicate data from IBM DB2 on AS/400 to SQL Server 2005. Is that doable? Currently we are replicating data from DB2 to SQL Server 2000...
Separate names with a comma.