Wednesday, September 4, 2013

[SQL 2012] How to tell if instance is MSDN licenced or not

[SQL 2012] How to tell if instance is MSDN licenced or not

How to tell if instance is MSDN licenced or not

Posted: 04 Sep 2013 12:27 AM PDT

Hi,I've been evaluating SQL Server 2012 for a while now and have started to use it in production. I am concerned that my evaluation install media (MSDN) has escaped into the production environment, but don't know how to check for sure. Is there a property or something to indicate which license key was used to install the instance so I can check where they've all come from?Thanks

SSIS 2012 Log Provider for SQL Server displays progress error when logging messages using shared project OLE DB connection

Posted: 20 Jun 2013 03:58 PM PDT

Hi AllI am building a SSIS project using the Project Deployment model of SSIS 2012. I am configuring package level logging using the SSIS log provider for SQL Server and using a [i]project[/i]-level connection in the configuration. The [i]project[/i]-level connection has a project.param of the connection string.The log events are being correctly logged to SQL Server however the Progress information tab indicates two duplicate errors that the project-level connection used for the log provider cannot be found."Error: The connection "xxxx_SSIS_Logging" is not found. This error is thrown by Connections collection when the specific connection element is not found."If I use a [i]package[/i]-level connection in the SSIS log provider, the log events are correctly logged and there are no connection errors in the Progress information tab.Is anyone else observing this behaviour with project-level connections in the SQL Server log provider?Has anyone had failure to log events due to a project-level connection in the SQL Server log provider?

SSIS 2005 --> SSIS 2012 (ActiveX Script gone?)

Posted: 12 Nov 2012 10:58 PM PST

Hello everybody,I need someone to point me in the right direction:We are in the process of converting SSIS packages from 2005 to 2012. Some of them have ActiveX scripts in them and when converting them over they fail. (I have no experience with SSIS yet).I see there is a Script Task in SSIS 2012 and I am thinking I have to rewrite the script in .NET? Is this the only option?My question is what options (I am sure there is more than the above mentioned one) I have to upgrade ActiveX Scripts? Time is realy tight too. :-)Thank you!

SQL Server Full to Simple to Full Recovery Model

Posted: 03 Sep 2013 05:26 AM PDT

Whenever I have a huge log file for any database with Full as its recovery modelThis is what I do to recover disk space...I change the recovery to simple..then shrink the file and change it back to full.What exactly is happening here ?Is this a recommended process?

Using WMI alert for mirroring in Sql server 2012

Posted: 03 Sep 2013 06:28 AM PDT

We are using mirroring in Sql Server 2012 and we are using WMI alerts for some of events such as Connection lost,Manual failover,...In alert definition we have set the followings:Type: WMI event alertNameSpace: \\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVERQuery: select * from DATABASE_MIRRORING_STATE_CHANGE where State = 6The alert is bing triggered correctly,but on email description instead of having meaningful explaination like 'Connection lost',We have the same query:Query: select * from DATABASE_MIRRORING_STATE_CHANGE where State = 6We have used the same implementation in our Sql Server 2008 servers and it is working fine.This mashine (Sql Server 2012) is a new mashine.I would appreciate if someone help me on this.AlsoI checked and 'Include body of e-mail in notification message' was already set.ThanksAspet
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog