Viewing 15 posts - 841 through 855 (of 4,272 total)
And in most cases SQLCLR is probably a bad path and even that could be decompiled. albeit with more work..
CEWII
October 31, 2011 at 3:09 pm
I have seen it happen much more when "My Documents" was not on a local drive but instead of on a network or offline folder. The other times have...
October 31, 2011 at 2:45 pm
I'm largely going along with Perry on this one.. I would wipe the node and rebuild it, I think trying to re-add it is simply asking for trouble.
CEWII
October 31, 2011 at 10:10 am
Perry Whittle (10/31/2011)
Elliott Whitlow (10/27/2011)
I would mount the new drives in as different drive letters.
I would add the new drives to the resource...
October 31, 2011 at 9:57 am
I see two things wrong with this approach.
1. You use xp_cmdshell, which we have been having quite a raging discussion on in another thread.
2. It implies that you know that...
October 31, 2011 at 9:13 am
Connecting to SQL will be no problem but SSIS will be, unless they have fixed it. SQL 2008 SSMS would not connect to SSIS 2005, and per MS Connect...
October 28, 2011 at 8:53 pm
While I generally like the idea it is important to also think about what happens when that server becomes bogged down and starts performing poorly. Are you going to...
October 28, 2011 at 1:37 pm
There are a couple. One I wrote and sell commerically unfortunately doesn't play well with Vista or Windows 7 (yet). But it allows you to view the history...
October 28, 2011 at 1:23 pm
As I read what you are asking, you want to effectively search for SQL Servers. A sql script is not likely to get you there since you have to...
October 28, 2011 at 1:17 pm
A bit senior..
Sir, not to be too unpleasant, but you don't even qualify for "a bit junior". Honestly you aren't doing anybody any favors by trying to get a...
October 28, 2011 at 9:53 am
Not a particular fan of the backup restore method in this case, it seems like a lot of wasted effort and risk.
Using the process I outlined above you have BOTH...
October 28, 2011 at 9:45 am
Its ok man... It happens..
CEWII
October 28, 2011 at 9:26 am
I would take SQL Offline leaving the disk resources online.
I would mount the new drives in as different drive letters.
I would add the new drives to the resource group.
Then...
October 27, 2011 at 9:55 pm
No, as I remember and my formula suggests a day would be represented as 1000000, this is handled by ((jh.run_duration/1000000)*86400).
I never tested a case where a year had passed and...
October 27, 2011 at 2:48 pm
Viewing 15 posts - 841 through 855 (of 4,272 total)