you can use where dbid <> 2

For starters get some good sql server book and read from cover to cover. In my experience this will definitely help as most of the problems that DBAs face...

You can install. Be sure about the licences you have. The workstation components are the same for both the editions.

restarting the SS service will be of no use as the default DB for the logins that you are trying is not there. Do the following (this is as...

I am assuming that you are using ss2005 and snapshot replication. You can add articles to replication and ss will take care of the rest.

Please refer to the below link

http://support.microsoft.com/kb/321686

Need more inputs are there can be many reasons why the connection is not happening like

Remote connections allowed

blocked in firewall

service not running

permission issue etc etc...

if you are trying to...

Create a linked server to the excel file and then query it or insert the contents to another table.

Im sure that your db had many updates and deletes and when the above mentioned operations causes page splits to occur. when you run the dbcc shrinkfile, sql...

Even I had faced the same problem. I disabled VIA Protocol (Server) through configuration manager and reboot the server. Agree with benimposta.

I think there that you are using sub queries in your update statements. This error happens when there is a problem in your sub-queries. Check the query please.

Even I had the same problem. The problem was with WMI service (dont know exactly whats the problem was). Restarted the WMI service and I was able to...