Hello I am trying to use sqlcmd to run a set of sql statements. If I use -i switch and input a file with sql statements, it is working fine, but I am...
A table called 'Customer' is a part of publication and is being replicated via transactional replication to another server. If I have to create an...
I am trying to install SQL Server 2008 on Windows server 2003 and have a question about the stage of 'Cluster Security Policy'. We need to select 2...
I have a situation where a deadlock has occured because of keylocks being placed. I am trying to understand how keylocks work and how to resolve...
Hi I have a set of scripts that need to be executed against ahuge list of sql instances. Instead of opening a connection againsteach sql instance...
Hi I know we can configure the alerts for the transaction logfile space used using the SQL Server alerts and configuring an alertfor SQL Server...
I am planning to have a alerting system that monitors the data space usage within the physical files and I can see that 'dbcc showfilestats' can give...
Is there a way to find out which logins have been granted 'view server state' permission?
Hello I have a publication that is having 10 tables in replication. One of the tables needs a datatype changed in a column. So the table is being...
Hello I tried doing a failover in a cluster which has 2 nodes and the second node in the cluser was now able to handle the resources for some reason....
How about an option like 'My threads' like in msdn forums here too rather than the option called 'recent posts' or 'view all posts' of a perticular...
Please refer to: http://sql-server-performance.com/Community/forums/p/28149/151022.aspx#151022 I could not understand all that additional text before...
Hi I had tomigrate a d/b from sql 2K to 2005 recently and I received a complaint from theapp team saying that the queries are running really slow...
There is a job failingthat I had to research and the error logs had the below messagesloogged exactly at that time. THe below 3 messages are...
When I try to start a custom log that I have created it gives me an error message: The service was unable to add the...
I am trying to issue a simple delete statement that deletes 2 rows from a table of 444 rows and it runs forever, the wait type shows up in the...
Is dbcc freeproccache a server level or d/b level query? What I am trying to understand is when I execute a dbcc freeproccache command, does it free...
I tried using SQL 2K5 be used against the SQL 2000 servers. and it throws a message: cannot initialize tuning failed to load msxmlsql.dll I tried...
I have finished the install of SQL 2k5 in a cluster and the resources are not going online with the below message in the event viewer: Cluster...
Any idea why this error is caused? When I try to generate a new snapshot it gives me the following: Transaction (Process ID 124) was deadlocked on...
Separate names with a comma.
