Is it safe to rebuild indexes on master and msdb databases using a maintenance plan? and how often should this be done? thanks
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...
I would like to generate a report that lists each database in both sql 2000 and 2005 instance alongwith their size. suggestions? thanks
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...
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...
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? thanks
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...
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...
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? thanks...
I see following entry in the trace exec sp_execute 6, NULL what does it mean? anyone? thanks
Is it possible to capture DML statements (i.e. Delta) executed against specific objects so that delta can be shipped for OLAP processing? thanks
Is there a way to find out which table in a database has xml data type columns? and also is it possible to search these fields for a string? thanks
well I have a interesting scenario. I need to search for a specific value in the database. However I dont have a tablename or columnname. Is there...
Well here is the scenario I restored a database from server A to Server B. this database on the server A had a sql user called 'moon'. Well after I...
In our prod environment I have the following setting checked for SQL Server Agent under job system tab Only users with SysAdmin privileges can...
Separate names with a comma.
