Viewing 15 posts - 9,766 through 9,780 (of 11,676 total)
Brandie Tarvin (3/15/2011)
Aren't you guys sad you can't see that article yet and jealous that I got to read it before you did! @=)
Well, I wasn't until just now, thank...
March 15, 2011 at 7:34 am
Great! Glad that you finally resolved your problem. And thanks for posting back.
March 15, 2011 at 6:43 am
Chris Houghton (3/15/2011)
Tested select * from ::fn_virtualservernodes() on both 2005 and 2008 clusters and it returned correct results for both.
So apparently all the three answers are correct?
Everybody wins! 😎
March 15, 2011 at 3:35 am
subramani.rudrappa 78855 (3/15/2011)
Thanks for the great support!
No problem, glad to help.
March 15, 2011 at 2:27 am
I would use the script task rather than the script component.
The FileInfo class should be sufficient:
http://msdn.microsoft.com/en-us/library/system.io.fileinfo.aspx
March 15, 2011 at 2:16 am
Are you 100% sure you have correct emailaddresses for all the fields?
Maybe one of variables is empty, leading to the use of NULL in a field.
You can set a breakpoint...
March 15, 2011 at 1:18 am
Phil Parkin (3/14/2011)
Yeah, I saw you were new so I went easy on you;-)
Ah keithlangleymba, you're in luck! Phil is notorious for making people cry in this forum 😉
March 15, 2011 at 1:14 am
Craig Farrell (3/14/2011)
bruce.b.allen (3/14/2011)
Yes, that is all correct. I want to be able to save the new value to the variable I set in the DTS.Variables("Vname").Value and to have...
March 15, 2011 at 1:11 am
There is no right or wrong answer on this one.
SQL --> easy to search for something specific using queries and useful to build reports on
Flat file --> better write performance,...
March 15, 2011 at 1:07 am
You can use a script task. Inside the script task, use the FileInfo class. It will contain the information that you need.
March 15, 2011 at 1:04 am
What is the error?
So the table uses unicode data types, but you want OLE DB to extract non-unicode data types?
Either set the data types in the advanced editor of the...
March 15, 2011 at 1:03 am
A tutorial:
http://www.isqa.unomaha.edu/wolcott/tutorials/erwin/ERwin.html
You would be surprised what results you'll get when you search google with "erwin tutorial".
Furthermore, I don't think you can download the software for free. At least not legally.
March 15, 2011 at 12:59 am
I think Brent Ozar has some blog posts on how to blog. (Or on how to become a SQL Rockstar)
A good start:
http://www.brentozar.com/archive/2010/04/rock-stars-normal-people-and-you/
I remember reading a blog post from someone telling...
March 15, 2011 at 12:56 am
When I run "select * from ::fn_virtualservernodes()", this returns no error but an empty resultset (I don't run any failover cluster, so that is to be expected).
What is the difference...
March 15, 2011 at 12:36 am
Viewing 15 posts - 9,766 through 9,780 (of 11,676 total)