Viewing 15 posts - 676 through 690 (of 4,272 total)
Well darn Koen, you didn't leave me anything else to ask..
CEWII
December 16, 2011 at 8:39 am
I could go with that..
CEWII
December 15, 2011 at 10:17 am
My google-foo is strong..
Google Search terms:
SQL 2008 compare editions
On the first page:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
CEWII
December 15, 2011 at 10:04 am
I have never ever seen that done.. I don't think it can. While it is possible to export the list from SSMS I've never seen an option to...
December 15, 2011 at 8:51 am
Koen Verbeeck (12/14/2011)
Ah, good point. I'm used to work with DontSaveSensitive and Windows Authentication, so lucky me 🙂
That is what I push for too, and it has saved me a...
December 15, 2011 at 8:44 am
tmitera (12/14/2011)
•sp_configure
•Alerts
•Operators
•Jobs
•SQL Agent config
•Database Mail config
•Trace Flags
•Linked Servers
•Replication publications or subscriptions
Of the above, it looks like (based off of my test environment) a restore of the MSDB database covers the...
December 14, 2011 at 3:08 pm
Thats 3 nays and no yays, the motion fails..
Not allowed.. Sorry.
CEWII
December 14, 2011 at 2:03 pm
You are very welcome. I wish I could tell you what you want to hear but it just isn't possible that way yet. Truly the best option is to...
December 14, 2011 at 1:12 pm
I don't believe that is supported, only one destination for Mirroring.. It IS possible for Log Shipping though..
CEWII
December 14, 2011 at 1:09 pm
I would generally say yes on technical blog and articles. But keep in mind who all of those present you. you might mention your activity on SSC or...
December 14, 2011 at 1:03 pm
Ok, 2 data-flows, first one imports the CSV to DB, second one takes the DB to CSV. probably an EXEC SQL task to clear the DB table and voila..
CEWII
December 14, 2011 at 12:53 pm
I have thoroughly enjoyed using the red-gate tools from the GUI, never from the CLI. But I love them, been using them since like 2002-2003.. My demo of...
December 14, 2011 at 12:47 pm
AER (12/14/2011)
The problem is that a SQL DBA not always a member of AD Admin Group.
I don't see why this is such a problem.. The most common way to...
December 14, 2011 at 12:45 pm
Absolutely right, we can just pick that data up as we go with a lookup.. No need to actually write it to the DB..
CEWII
December 14, 2011 at 11:40 am
I think that is a common resistance. Tools are hard to get money to buy, especially small tools. A fair amount of the stuff I do on those...
December 14, 2011 at 11:38 am
Viewing 15 posts - 676 through 690 (of 4,272 total)