Viewing 15 posts - 121 through 135 (of 278 total)
And here's the other two.
System1 = SQL2008 RTM Enterprise
System2 = SQL2005 SP3 Standard
Both on Win Server 2003 R2 Standard, one dual core CPU, 3.75GB RAM
When I get home I'll...
September 20, 2010 at 10:27 am
Apologies for the delayed response - my PC died!
I'm currently re-running the script (from the OP) on a SQL2005 and a SQL2008 on the same machine
In the meantime here is...
September 20, 2010 at 10:01 am
Hi Jeff
I'm unable to run the second script as the servers I can use here do not have AdventureWorks installed. I will run the second one from my home machine...
September 20, 2010 at 6:42 am
Jeff Moden (9/20/2010)
Paul White NZ (9/20/2010)
mazzz (9/20/2010)
I would like to help - is the latest code that Jeff would like us to run in the original post?
My understanding is that...
September 20, 2010 at 6:11 am
I would like to help - is the latest code that Jeff would like us to run in the original post?
September 20, 2010 at 5:18 am
Hear hear!
I have lost count of the amount of times that I haven't even had to ask a question because it's been exhaustively answered here! Thank you all.
September 17, 2010 at 7:11 am
I use 2 on a standard edition SQL2008. IIRC 3 is also supported, only High Performance isn't.
One thing to note is that Standard doesn't support database snapshots, so you can't...
September 8, 2010 at 3:54 am
HowardW (8/3/2010)
Things I usually check on a client site are:Tempdb and other system databases on the C: drive - these can (and should) be moved away from the system partition
All...
August 3, 2010 at 5:27 am
Thank you Pradeep.
Still no joy though - over 600MB free when I started the SP1, and it still ran out of space! Back to the drawing board...
August 3, 2010 at 4:44 am
Jeff Moden (7/14/2010)
3000 tables? Would it by any chance be SAP?
No, it's a ticket/incident/change management application - Remedy.
July 15, 2010 at 12:17 am
Thank you for your responses, Jeff and Todd.
Even using the wizard to create the initial package I would still have to go in and manually edit about 2000 of the...
July 14, 2010 at 10:39 am
Thanks Tod.
It's as I feared then - I will at any rate have 1000 distinct OLE DB Sources/Destinations to put together.
I counted the tables, there are actually 3000 of them!!
July 13, 2010 at 9:12 am
Yes. To clarify:
All source tables are in the same Oracle schema.
All destination tables will be in one SQL Server database.
July 13, 2010 at 6:52 am
I see. Odd that it won't even let you uninstall.
I got through SP1 and CU8 fine after that. It was the inital setting the same locations through the GUI that...
July 2, 2010 at 5:22 am
I got the same error yesterday, and solved it by running setup from the command line:
setup.exe /INSTALLSHAREDWOWDIR="D:\Program Files(x86)\Microsoft SQL Server" /INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server" /ACTION=install
It appears to be a known...
July 2, 2010 at 4:26 am
Viewing 15 posts - 121 through 135 (of 278 total)