I can wish....

So the catalogues will be stored internal to the database file then?

Have they...

Coolroof (7/1/2011)

---

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Test',

@recipients = 'xx@abc.com',

@subject = 'Work Order Count',

@file_attachments='R:\test\test.csv'

its executing properly but...

Koen Verbeeck (7/1/2011)

---

Iulian -207023 (7/1/2011)

---

Thanks for the question

Interesting area, but why would someone usually use trace flags in practice;

I have not used them yet so I did not had the...

JimTheWhip (6/30/2011)

---

I question the value of technique "Usually a still better solution (better by far) is to introduce a new table OfficeFax that has a name column and a FaxNumber...

I was totally lost

TDE and Filestream

If you enable TDE on a database that has FILESTREAM and the FILESTREAM data is stored locally on the instance (not a remote BLOB store),...

MysteryJimbo (6/27/2011)

---

Thats true but why would you want no recovery? You want to edit the data?

Also, you can logship a replicated db. You only apply the KEEP REPLICATION...

MysteryJimbo (6/25/2011)

---

in theory, provided you disable the log reader agent and allow the distribution agent(s) to complete its run before disabling them you could get away with this.

4. Restore database...

I'll have to look for that book now.

The two I have (titles corrected from above)

Professional SQL Server Analysis Services 2005 with MDX is by Sivakumar Harinath & Stephen R. Quinn

Microsoft...

mtassin (6/21/2011)

---

I've made some progress by creating a new measures group on my clients. It does math, and actually seems to roll-up and do division correctly... still testing it....

stevefromOZ (6/21/2011)

---

Hey Mark,

No, I was more hoping you could create a new calc measure derived from the attribute values (which you can) but it appears to do the same thing...

And of course those of us with SQL 2008 can pass tables as stored procedure parametes now 🙂

Steve,

I'm not sure I follow. ...

I see this and I start to cry

SET @v_DateCond=' AND PatientEventRecordedDate BETWEEN ''' + @StartDate +

''' AND ''' + @EndDate + ''''

SET @Action = @Action + ' With search...

OCTom (6/10/2011)

---

mtassin (6/10/2011)

---

GilaMonster (6/10/2011)

---

This is MCM level...

GilaMonster (6/10/2011)

---

This is MCM level material. Planning...