Viewing 15 posts - 526 through 540 (of 956 total)
Nope. SAFE Assemblies work just fine. How much trouble you have with the EXTERNAL_ACCESS one depends on how you deployed it. IF you used a key to...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 27, 2009 at 12:48 pm
Well first you have statics that aren't readonly which is both UNSAFE and fails to guarantee valid results at any point of your execution. What exactly are you expecting...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 27, 2009 at 11:20 am
What safety level are your assemblies? That is what determines the level of headache you will have at failover and during deployments.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 27, 2009 at 11:08 am
Jonathan Kehayias (1/11/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 21, 2009 at 11:33 am
Generally, you would patch all instances at the exact same time. If you have a multi-instance server it lets you select which instances to apply the patches to.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 21, 2009 at 9:31 am
colin Leversuch-Roberts (1/21/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 21, 2009 at 8:24 am
george sibbald (1/21/2009)
the article mentioned that VM streamlines the DR process, but for that to be fully...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 21, 2009 at 7:59 am
GilaMonster (1/14/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 14, 2009 at 9:40 am
GilaMonster (1/12/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 10:04 am
Steve,
Google Reader returns "Permission Denied" if you try to subscribe to the RSS Feed on that new forum.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:34 am
If this is on SQL Server 2005, try using the blocked process report to identify the blocking statement and object and then look at the code/indexes/physical design and determine how...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:29 am
What rights/roles does your user account have on both servers?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:26 am
Thanks Steve, I'll add it to my feed reader in a minute.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:21 am
Look in the Windows Event Log and see what errors get logged if you try to restart the SQL Agent. If there aren't any, then recheck the LOG path...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:18 am
You can use the DTS Migration wizard to move to 2005. You can also save packages to the file system from both DTS and SSIS and then import them...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 11, 2009 at 5:26 pm
Viewing 15 posts - 526 through 540 (of 956 total)