Search Results: sp_configure

• 
  Run SSIS Package through Store Procedure

  Hi guys, I am kinda old question. I want to run my ssis package through Store Procedure. Please anyone can guide me. Here what i am doing and getting error/problems. First Step USE master GO EXEC sp_configure ' show advanced options' , 1 GO RECONFIGURE WI

  Author:  Mike     Date: 10/10/2011     Section: Forum
• 
  Stored Proc: xp_cmdshell to exec dtexec utility

  Depending on the environment, you may not be able to execute the xp_cmdshell from a proc, dts or any other way. I believe by default, this setting is disabled in the SQL Server Surface Area Configuration tool for SQL 2005. I can't remember right now how t

  Author:  briankmcdonald     Date: 7/29/2010     Section: Forum
• 
  Problem installing Adventureworks

  I am trying to load the Adventureworks databases. I am using Adventureworks Community Sample Databases SR4. It says it can't load Adventureworks OLTP because Filestream is not enabled. I executed EXEC sp_configure filestream_access_level, 2 RECONFIGURE It

  Author:  dr2706     Date: 1/18/2010     Section: Blog
• 
  Two Digit Year Cutoff

  I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link from SQL Share regarding converting and the two digit year cutoff . It has been a long time since I had heard about this potentially critical issue w

  Author:  briankmcdonald     Date: 12/15/2010     Section: Blog

  tags : Andy Warren, Brian K McDonald, sp_configure, SQL Share, Converting Two Digit Year