once the @provstr string specified, should @catalog option needs to be define on this?
once the @provstr string specified, should @catalog option needs to be define on this? DBA100
How about the option 'provstr' when adding linkedserver? it seems it is only work for mirror session, right? can we utilize this option to get ride...
Dear all DB experts, We are now doing DR drill on SQL server 2008 cluster, but after we failover we found out that some query need to use the linked...
hi, For the performance montor, you have to be the administrators. For the memory issue, please try to enalbe the AWE switch, it seems can't see the...
Yeah. Update us once you tried that, I also want to know the result. One thing, how can the author of the link create so many test and gives result?...
/3G is the PAE, has to specify in the boot.ini, SQL 2000 user has to enable AWE API also, this make sure SQL can talk to PAE memory space using this...
As SQL server use 8K per page size, please try to format the HD/Volumn using 8K, I never see 128K is better and you can see that your result is not...
Dear satya, I am ready to test the fail over and I have communicate with our developer on the client coding so that client applicatoin know how to...
Before I test the SQL Server 2005 mirror failover, I would like to know any case that after SQL Server failover to mirror server and can't fail back...
That one only transfer login and password, but not permission, I didn't try it out yet. I have tried script out the login also but that action is...
One problem I am experiencing is that I can’t restore master DB of SQL Server 2005 to another SQL Server 2005, the SQL Server seems doesn’t like...
When I am using SQL Server 2000, I just have to detach the read only DB for log shipping secondary server and the re attach it. but in this case our...
Thanks. But how about this question: Is ASP.net 2.0 is the one included in the .net framework 2.0? can I install the Microsoft .NET Framework Version...
If we intend to run SQL Server 2005 Reporting Services, we must then install IIS 6.0 and ASP .NET 2.0 on each node of the cluster. Is ASP.net 2.0 is...
I think this is very important for all DBA. My question is from the “guide to creating and configuring a server cluster in Windows server...
Hi, I think this one is a real good resource, use this one http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx...
Separate names with a comma.
