Viewing 15 posts - 16 through 30 (of 40 total)
Are you a sysadmin or in the dbm_moniotr role? It is also possible that you have both tools for 2005 and 2008 and maybe the pack for 2000 in...
May 15, 2009 at 11:35 am
Can you give me an example string before and then after the validation/formating that needs to be performed?
May 15, 2009 at 6:26 am
Sense this is SSIS I figured I'd show how I would do it as a conversion. Looking at the code I'm guessing you are preventing none email formatted strings...
May 14, 2009 at 1:04 pm
What build level is it running at?
May 14, 2009 at 10:19 am
Read that a bit fast. To unregister the db from the actual monitor just right click it and select "unregister this database" in regards to 2005 database mirroring monitor
May 14, 2009 at 9:25 am
Not sure I understand but I think you're looking for
ALTER DATABASE {db_name} SET PARTNER OFF
This removes the db from mirroring
May 14, 2009 at 9:22 am
It seems like you're pretty convinced there is no need to keep your data protected and in the best configured way possible so I don't want to start arguing about...
May 14, 2009 at 7:52 am
I don't know of any tools to do so. There are some for VB.NET to C# but most always require some "help". I may have time to post...
May 14, 2009 at 7:44 am
Apologies on not noticing your header, "Write scripts using Microsoft Visual C# 2008."
Still the same answer but wanted to correct my version inaccuracy in my last reply 🙂
May 14, 2009 at 7:35 am
Looks like you are putting vbscript into a script task. Script task is written in VB.NET in SSIS 2005. Use the ActiveX Script Task for this
May 14, 2009 at 7:33 am
Disk it far cheaper than poorly configured hardware 🙂
May 14, 2009 at 7:21 am
Have you ruled out the network card(s) on the server? This has happened a few times in the past to me and the cards needed to be replaced or...
May 14, 2009 at 6:47 am
Next I will see what I can do about the statistics
Just to throw it out there. If you are rebuilding the indexes it will also update stats with a...
May 14, 2009 at 6:37 am
Well, two drives have two times higher chance for a failure... 🙂
So, having data files on one drive and log files on another drive is definately not the solution -...
May 14, 2009 at 6:33 am
Indexes on high transactional tables that become fragmented in even hours can be normal in most OLTP configured instances. I have dozens of indexes that require maintenance every four...
May 14, 2009 at 6:21 am
Viewing 15 posts - 16 through 30 (of 40 total)