In addition to those other great suggestions already mentioned there are a number of SQL Server DMV's that you can use to find statistics about the...
Yep that would be SQL COMPARE. I had data on the mind. I always run it with SysAdmin rights. Kind of make sense if you think about what it take to...
Sorry for the blank post. But have you tried RedGate's SQL Data Compare. If I recall correctly it can decrypt encrypted stored procedures
I took a set theory class in college. Keep in mind, that was in the the days of the dinosaurs (mainframes and punch cards). It was a math class and...
Here is a free tool from Quest Software. Haven't tried it, and it is also only in Beta. http://www.quest.com/landing/?ID=1305
I think the question here is how to find all the hidden instances on the network. Not how to connect to hidden instance.
Yes the site does require registration. It is very simiple to register, and it is FREE. Once you login then all the examples are available to you.
Here are a couple of scripts that should help you build something:...
Thanks for the thoughts. I was kind of thinking you couldn't logically name instances. I might have to look into the cluster idea a bit.
Is there a way to have two different logical instance names that point to the same physical instance name that can be used in a connection string?...
I personally don't want to get paged in the middle of the night, but first thing in the morning I want to go through and find my failed jobs. A long...
Hopefully it is an explosion of good things. I'd hate to get burned by the lava of Kilimanjaro.
Isn't Kilimanjaro a "Big", "Cold" thing in Tanzania? Wonder if the next version of SQL Server is going to be a "Big" thing, or and "Cold" thing or...
Thanks for the link. Yes it does shed more light on the subject, but does help me determine what I did to make this stop working. Hopefully with SP3...
I don't think companies will start moving toward employees bring there own hardware for two reasons:- Employees might feel that the employer should...
Our developers gain access to SQL Server and specific databases via membership in Windows Groups. They recently reported that using Management Studio...
Yes, I think email takes longer to communicate the same thing as a quick phone call. But it does provide something a phone call doesn't. That is an...
I wrote a process to monitor servers. Only problem is it request at least one SQL Server machine to be up. It could be a express edition running on...
I'm going to download it soon. We are going to start our 6 month evaluation process of the software. in reality we will probably not deploy it for...
Separate names with a comma.
