Log backups jobs are being blocked by checkpoints and DBCC CheckDB command, sometimes checkpoint is getting blocked by dbcc checkdb.
I have a suspect database which regularly goes into suspect mode. BUt when the server restarts it comes online again and after some time it...
How to check sqlserver is not leaking memory.
Would a sql server restart if it is inshort of memory. how to check and release the...
Sql server is 2005 standard edition with sp2 and win2003 with sp2.
Note: We installed DST patches before a restart of sql server. Though...
What is the best way to shutdown a SQL server 2005 in a cluster environment.
and also to start a Sql server.
We have allocated around 30 Gb ram to SQL server, Sqlserver proccess is consuming 28 GB ( shown in task manager) is it normal or somthing is wrong?.
I want to know what is the role of the service broker in Sql server services. What SQL server dependcies on Sql servce Broker.
What is the...
We are having performance issues on our Sqlserver box. How can i check whether the slow is because of sql server.
If a sqlserve is...
I want to know where and what logs are available sql 2005.
can we use Typecast function in this issue as it won't need any extra task in package if we can
I tried to assing a integer variable value to a string variable using expressions but I got a error saying typecast mismatch.
I want to know what is the use of these services especially repoting services.
In what situvations do we use these services and how. I...
I need to implement clr for some procedures and UDFs on a cluster environment. Please suggest me how to for it. We want to make sure even...
I want to implement clr on sql cluster 2005. Is there a specific way to do this?.
Where should we copy the dlls do we need to keep them in...
In case of multiple instance how can I identify the trn file or
log file of that particular instance ( I am having sql 2000...
Is trigger the only way to know this information. is there anyway to use profiler something else you people can think of.
But how can i get the...
How can I find out which user has used ddl statement or which user has droped a table.Is this information available in sql event...
First of all thanks for the information I have tried that but my problem is i am not able to find a option which ask for creating new...
But in sql 2000 and 2005 we use remote server for backward compatibility and we can run proceduers of other servers database .
I want to create remote servers on one of my sql 2005 server instance but i could not figure out how to create them. Can any one...
Separate names with a comma.