I click on the Enterprise Manager on the start menu >> programs >>MS SQL >> Enterprise Manager and I receive this message "MMC cannot open the selected file" Any ideas on how to fix this, I reinstalled the tool and I receive the same message.
source : http://groups.google.com/groups?selm=%23GL56wc2CHA.2332%40TK2MSFTNGP10.phx.gbl&output=gplain
This is usually due to a problem with the SQL ODBC driver (C:\WINNT\sqlsrv32.dll).
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…