Viewing 15 posts - 991 through 1,005 (of 4,272 total)
For file functions, which was one of the reason I used to use xp_cmdshell I wrote a SQLCLR object. IT is freely available on codeplex at: http://nclsqlclrfile.codeplex.com/%5B/url%5D
Give it a...
October 13, 2011 at 11:02 am
That could build you a package that can be the basis for the rest of your work yes. But the package from it will probably not be sufficient for...
October 13, 2011 at 9:12 am
Post SQL 2000 I am fundamentally opposed to using xp_cmdshell, there really is no reason. Within the forums I see it being thrown out as a solution periodically, in...
October 12, 2011 at 12:41 pm
You can't really schedule the wizard so that probably is a no-go.
You have several options.
You could build an SSIS package that is scheduled to run every 5 minutes and copies...
October 12, 2011 at 12:26 pm
Have you looked at the BREAK keyword in BOL?
CEWII
October 12, 2011 at 12:17 pm
Whats New in SQL 2008
http://msdn.microsoft.com/en-us/library/bb500435(v=SQL.100).aspx
Whats New in SQL 2008R2
http://msdn.microsoft.com/en-us/library/bb500435.aspx
Give those a whirl..
CEWII
October 12, 2011 at 9:55 am
Firewall is where I would start as well..
Given that port and IP will be the same no matter what node it is on I doubt it would be a name...
October 11, 2011 at 11:28 pm
I don't remember whats new between 2005 and 2008, sorry.. And between 2008 and R2 I think there is really nothing different..
A list of whats different doesn't get you...
October 11, 2011 at 11:23 pm
Oh, good one Perry..
CEWII
October 11, 2011 at 8:16 pm
That would be one long expression...
CEWII
October 11, 2011 at 3:15 pm
I wasn't sure but I didn't think that the other node was added to that tab until after the install anyway..
Are both nodes either set or un-set and preferred nodes...
October 11, 2011 at 2:58 pm
My point is you can't.
You are going about this the wrong way.
It sounds like you have a list of servers that you want to run basically the same command on,...
October 11, 2011 at 2:54 pm
Duplicate post, please make all responses to http://www.sqlservercentral.com/Forums/Topic1188781-392-1.aspx
CEWII
October 11, 2011 at 2:52 pm
Not this particular behavior but where you might try and fix it I can help with.
Open the Failover Cluster Management app, connect to the cluster.
Expand "Services and Applications"
Click on the...
October 11, 2011 at 2:49 pm
Viewing 15 posts - 991 through 1,005 (of 4,272 total)