97 reputation
bio website davidwing.pro
location Guelph, Canada
age 46
visits member for 3 years, 11 months
seen Feb 22 at 14:43

Professional Engineer & SQL Server Technical Specialist

comment Could not allocate space for object 'dbo.History' in database '[path to mdf]' because the 'PRIMARY' filegroup is full
@brother -- out of curiosity unrelated to your question, does dbo.History contain two ntext fields?
comment Connect to SQL Server 2012 Database from 2008 Agent Job containing 2008 SSIS Package
Mike, Thank you. I'll mark this as the answer once I try this (and it works).
comment How do I merge two XML variables in SQL Server (2005/2008)?
Mikael, your solution produces the desired result. Thank you.
comment Alerting on Database Mirroring Events
Update from Microsoft "... the underlined issue was identified as a core Engine issue ... will not be classified as a hotfix required for the SQL 2008 or SQL 2008 R2. We will try to address this issue in our current release for SQL 2011 ... the risk for breaking existing functionality by changing the output format (the message format) is fairly high. We decided therefore that we cannot make this change ... workaround is to create your own alert that includes the complete message. See also technet.microsoft.com/en-us/library/cc966392.aspx";
comment Alerting on Database Mirroring Events
Thank you Brent. I do hope that the Microsoft Connect team addresses this issue in a future update.