Viewing 15 posts - 17,116 through 17,130 (of 39,957 total)
Shared components are client tools and non-instance aware services. Not all SQL Server services are multi-instance.
January 15, 2011 at 11:19 am
says that passive nodes don't need licensing. this assumes the passive node has <= number of CPU sockets as the active node.
When you say you...
January 15, 2011 at 11:18 am
1. Is this the same server name?
2. sp_help_revlogin
3. permissions move. Or are you talking at a server level? You'll need to script these out.
4. script them out
5. save to...
January 15, 2011 at 11:16 am
I tend to like scripts for this, instead of a separate program. Especially as you'll start to have multiple versions of things quickly since SQL Server changes rapidly. Scripts seem...
January 15, 2011 at 11:15 am
If you have a lot of schema changes, then replication can be a hassle. However, have you considered instead using SSIS and building more of a reporting warehouse? It's...
January 14, 2011 at 12:24 pm
Are you connecting with SSMS? You might be using that one connection in the Object Explorer
Use SQLCMD for your one connection from a different command like window.
January 14, 2011 at 11:01 am
Brian is correct. The tool is using credentials (current or RUNAS ones) so there is no need for a login.
January 14, 2011 at 9:45 am
This should depend on how the SAN vendor has implemented the snapshot. They may be integrating with SQL Server.
However I'd let them know if they are marking the snapshot as...
January 14, 2011 at 9:44 am
I believe this is because the OR clause doesn't mean you are selecting how many rows out of tablA match, but rather you are making two comparisons. The 3 rows...
January 14, 2011 at 9:43 am
Yes, most people don't read discussions. I have tried to add a note to controversial articles to point people to the articles, but haven't typically pointed to new articles.
January 14, 2011 at 9:32 am
Could there be some backup job that's writing to tape or the NULL device? If the diff is going down in size, you have something that is resetting the diff...
January 14, 2011 at 9:00 am
andycao (1/14/2011)
...recovery times never require a cot at work.
An excellent metric to use.
January 14, 2011 at 8:46 am
I like you talking about posters. Tells me where to go look (or where not to go)
January 14, 2011 at 8:43 am
Yep, that makes sense. I'd like to get a standard section/piece of text at the top and bottom of each article to do the forward/back pointers.
January 14, 2011 at 8:42 am
Viewing 15 posts - 17,116 through 17,130 (of 39,957 total)