Monthly Archives: September 2011

New 2008 r2 Install SSIS “Failed to retrieve data for this request.”

You might also get: “The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer.”  To resolve this…

Posted in SQL Administration, SQL Clustering, SSIS | Leave a comment

Drop user who owns a Schema

How often are you deleting users and you get the warning that this user owns a schema and the schema is going to get dropped also…and are you sure you want to do this? … And no, you’re not really … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Tagged , | Leave a comment