Is it safe to rebuild indexes on master and msdb databases using a maintenance plan? and how often should this be done?
Is there a way to reduce log buffer wait? Is there some setting or settings that I can change?
If not, how can I find the database and queries which...
found the solution
I would like to generate a report that lists each database in both sql 2000 and 2005 instance alongwith their size. suggestions?
dont know. how do I tell?
I am getting following error when bringing up VSTS:
Package Load Failure
Package 'Visual Studio XML Editor Package' has failed to load properly (...
is it possible to automatically identify a block situation and kill one of the spids after a certain time? and which spids should be killed? and how...
Infact that doucument does not offer any solution to my question. It only talks about how you can use reporting services with essbase.
is it possible to use integration services to extract data from essbase?
is it possible to use 'Microsoft .NET Data Provider for Hyperion Essbase' outside of reporting services?
I am experiencing issues when connecting to AS from SSMS. I get the following error:
Cannot connect to InstanceName
A connection cannot be made....
I am tasked to move a database from sql 2000 to sql 2005. Though my research suggests that I can backup a sql 2000 db from enterprise manager and...
I will be log shipping from a 64 bit cluster to a 32 bit server. Hope that answers your question.
does anyone know of any potential issues of log shipping from a 64 bit sql 2005 cluster to a 32 bit sql server 2005 instance?
Can someone share an example of how to schedule a trace? I have seen some stuff online that used xp_trace extended procedures however examples are...
if you generate a new snapshot at the publisher and reinitialize and resynchronize at the subscriber the error goes away.
I am running replication from a clustered sql server to an instance of sql on a diff. box. When I performed failover on the source cluster...
I am getting the following error when querying the remote db using linked server
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user...
are you saying that by using replication I am deactivating my failover capibility?
what happens to replication in case sql server fails over to another node? does it break? or does it get moved to the other node as well?
Separate names with a comma.