List of keyboard shortcuts for SSMS

http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

happy to help as always

always good to give the error log a good read usually contains the problem your facing

Well thats a different kettle of fish all together, as its a system database I wouldnt backup and restore it as your upgrading, yet script all the SSIS packages out...

If you want to use the default instance where you just use the servername to connect via SSMS etc then you need to uninstall 2005 first (that is if 2005...

Do you want to run 2005 and 2008R2 side by side? If so you will need to create a named instance of 2008R2.

During the install it will ask for...

problems in the error log

Error: There is insufficient free space on disk volume 'L:\' to create the database. The database requires 15587278848 additional free bytes, while only 8799973376 bytes...

Couple of things to check

Is SQL Browser started so that port numbers can be translated?

Can you connect using the port number for the named instance? SERVER\Instance,1433

Server firewall blocking the...

you want 1 query executed against 10 servers at the same time?

so going back to my original post, use a central management server or create a batch file which uses...

Hi Guru

Thats a completely different thread as you can see in the URL's.

The OP has the same question but two different SQL queries hence the two different posts.

Thanks

Ant

you could use a central management server to execute the same query across multiple servers in one go, or if you want to do it in a batch file take...

Please post your query and the actual full error message you are getting

what anti virus do you have on the server?

we had issues with mcafee and its mass mail worm not allowing to send mail and this was disabled via epo and...

Please take a look at DBCC CHECKDB in BOL or MSDN.

It will basically do consistancy checks to ensure that nothing bad happened due to the error.

it would seem like you lost the E drive (might of been for a short period of time)

do you use a SAN at all, might be worth asking your SAN...

Take a look at utility control point, its more or less the same as MDW but spans multiple servers.

Plenty of information on it in BOL and MSDN.