Viewing 15 posts - 4,321 through 4,335 (of 6,679 total)
Gift Peddie (12/31/2009)I am saying I am running a development configuration of Windows 7 which is not the same, so accounts added are based on what is running in the...
December 31, 2009 at 12:06 pm
Gift Peddie (12/31/2009)I am running VS2008 Team Suites and it was installed before I installed any SQL Server because my BIDs are labeled BIDs by Windows 7.
What does this have...
December 31, 2009 at 11:50 am
Gift Peddie (12/31/2009)
SQLServer2005DTSUser${instance name}
SQLServer2005MSSQLServerADHelperUser${instance name}
You may be in a domain and running an upgrade I don't have these accounts and the ones I have are not Windows account because I...
December 31, 2009 at 11:37 am
You don't import the package - you add it as an existing item to the new project. To do that, right-click on the Projects folder and select Add Existing...
December 31, 2009 at 11:22 am
No - you are right, you cannot have a single solution in VS2010 that includes SSIS packages for a previous version of SQL Server.
December 31, 2009 at 11:17 am
Gift - SQL Server 2005 and 2008 (I have both on this machine which is running Windows 7) create Windows Groups as in:
SQLServer2005DTSUser${instance name}
SQLServer2005MSFTEUser${instance name}
SQLServer2005MSSQLServerADHelperUser${instance name}
SQLServer2005MSSQLUser${instance name}
SQLServer2005SQLAgentUser${instance name}
And, you will...
December 31, 2009 at 11:15 am
The SSIS tools (BIDS) are specific to the version of SQL Server you are developing for.
SQL Server 2005 SSIS packages must be built in VS2005.
SQL Server 2008 SSIS packages can...
December 31, 2009 at 10:43 am
Nope - no concerns. Your client software won't know (and shouldn't) or care whether or not the database engine is running x64 or x86.
December 31, 2009 at 10:32 am
How are you changing the username/password for SQL Server Agent? If you are not using SQL Server Configuration Manager - all necessary rights/permissions are not being set for this...
December 31, 2009 at 10:19 am
You cannot use the standard backup database task provided by Microsoft to do what you want. You are going to have to create a script that does this for...
December 31, 2009 at 10:07 am
Sorry - but you can no longer make changes to system tables like that. How did you make this change and why is it causing problems?
December 30, 2009 at 3:38 pm
ToddJames (12/30/2009)
What about the new objects that get created?
Not sure I understand your question - but with a comparison tool, you run the comparison and new objects are identified which...
December 30, 2009 at 3:37 pm
ToddJames (12/30/2009)
I would like to use SQL and not a third party tool. Is scripting objects possible in SSIS?
Yes - scripting objects is possible in SSMS (not SSIS). ...
December 30, 2009 at 3:26 pm
You cannot upgrade the OS from 32-bit to 64-bit. You have to install a clean version of the OS, which means you have to re-install SQL Server also.
With that...
December 30, 2009 at 3:14 pm
Viewing 15 posts - 4,321 through 4,335 (of 6,679 total)