Found this doing a search:

If you will assign user as db_backupoperator you will discover error when you will try to create a backup..

When trying to specify location, you will see...

Try explaining why it should. Looking at the data, you are getting just what you asked for, the data where post_id = 2810. If there is more to...

mw112009 (4/25/2016)

---

Luis C:

Here you go ( See attached )

The attached DDL will create a table and has INSERT statements to cover member data for 2 members. That should be sufficient.

Hope...

something like this? Sorry, but with nothing to really work with or test against, this is best I could come up.

declare @WorkingDate varchar(6) = '201605';

with Prev9 as (

select

...

mw112009 (4/25/2016)

---

Sorry, please used the SQL below,

The effectivemonth is in the format YYYYMM

So please use this syntax

Declare @monthyear as varchar(4) --yyyymm

@monthyear = '201605'

Select distinct MemberNbr

FROM

MHPDW.edw.[MEMBER].[MemberMonthHistory]

WHERE...

Wayne West (4/25/2016)

---

Lynn Pettis (4/22/2016)

---

Wayne West (4/22/2016)

---

I have a number of files from 20+ years ago that I'd like to recover that were written in a long-gone word processor, Borland's...

David.Poole (4/23/2016)

---

I went to an interesting talk given by a guy from NASA. One of the problems NASA face is that they may have a scientist whose lifes work...

TheSQLGuru (4/22/2016)

---

Lynn Pettis (4/22/2016)

---

TheSQLGuru (4/22/2016)

---

Great thinking for autoclose being a cause of the repeated long initial run times! Actually it is hard to think of a situation where autoclose should...

Lynn Pettis (4/22/2016)

---

jeff.mason (4/22/2016)

---

Sean Lange (4/22/2016)

---

Phil Parkin (4/22/2016)

---

Yikes. That thread is already following a familiar pattern.

I expect two more pages of fumbling, followed by:...

TheSQLGuru (4/22/2016)

---

Great thinking for autoclose being a cause of the repeated long initial run times! Actually it is hard to think of a situation where autoclose should be turned on...

Wayne West (4/22/2016)

---

I have a number of files from 20+ years ago that I'd like to recover that were written in a long-gone word processor, Borland's Sprint. But they...

jeff.mason (4/22/2016)

---

Sean Lange (4/22/2016)

---

Phil Parkin (4/22/2016)

---

Yikes. That thread is already following a familiar pattern.

I expect two more pages of fumbling, followed by: "It's OK....

I would also look at the current size of your database, the amount of free space in the database, the automatic growth factor set for the database.

You should not rely...

jpgillum (4/20/2016)

---

Hello,

I have an event process routine that creates a work table with one record in it with multiple columns that are to be used to update a production table....

Here: https://msdn.microsoft.com/en-us/library/ms188398.aspx