Viewing 15 posts - 766 through 780 (of 4,272 total)
From the licensing doc:
VIRTUALIZATION AND MULTI-INSTANCING
Virtualization is defined broadly as the running of software on a “virtual environment.” A virtual environment takes place when an operating system (OS) is somehow...
December 2, 2011 at 10:06 pm
Add Existing Project? I think there is a menu item for it..
Or create a blank solution and then add all your projects..
CEWII
December 2, 2011 at 9:58 pm
No such thing..
You can create multiple SSIS projects in a solution.
What is the context?
CEWII
December 2, 2011 at 5:03 pm
My understanding was that it fixed the references internally. My process didn't require such adjustments, the SIDs were the same on both servers therefore when the restore occured I...
December 2, 2011 at 3:57 pm
I went an extra step and wrote a script to bring the logins accross and maintain their internal SID values, tis meant when the database was restored I didn't have...
December 2, 2011 at 2:22 pm
I have only seen this once and have never reproduced it..
I have fixed it by renaming the package again (then hitting yes too) and then renaming it again to what...
December 2, 2011 at 12:04 pm
I would probably use something like this SQLCLR:
http://nclsqlclrfile.codeplex.com/%5B/url%5D
Clarification: I am the author of this SQLCLR
But SSIS does have a data-flow task that can do it, but I have only had...
December 2, 2011 at 11:22 am
I doubt you will be able to combine them. The reason is that if a package doesn't have a connection or a variable you will get at least a...
December 2, 2011 at 11:10 am
george sibbald (12/2/2011)
http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-19-Misconceptions-around-index-rebuilds-(allocation-BULK_LOGGED-mode-locking).aspx
The line that I am most interested in is:
"The first few service packs of 2000 had bugs that changed the behavior of rebuilding unique clustered indexes back and...
December 2, 2011 at 9:06 am
I have on very rare occasion used a script task to read SQL data in SSIS, and in those cases only when I had to do something that was very...
December 2, 2011 at 8:36 am
GilaMonster (12/2/2011)
Elliott Whitlow (12/1/2011)
GilaMonster (12/1/2011)
Elliott Whitlow (12/1/2011)
Ok, then I was basing my perspective on SQL 2000. Good to know.
Even on SQL 2000 the 'pointers' in a nonclustered index are...
December 2, 2011 at 7:55 am
As a matter of policy CLR object source code must be submitted to me prior to deployment. With sufficient lead time to review it. And I have access...
December 1, 2011 at 7:03 pm
GilaMonster (12/1/2011)
Elliott Whitlow (12/1/2011)
Ok, then I was basing my perspective on SQL 2000. Good to know.
Even on SQL 2000 the 'pointers' in a nonclustered index are the clustered index...
December 1, 2011 at 6:52 pm
Ok, then I was basing my perspective on SQL 2000. Good to know.
CEWII
December 1, 2011 at 3:55 pm
Gila is that correct. If the record moves at all doesn't the pointer change as well? It was my understanding that this was true and the underlying cause...
December 1, 2011 at 1:55 pm
Viewing 15 posts - 766 through 780 (of 4,272 total)