Getting a error configuring mirroring. I am a programmer with no administration or network knowledge.

Sorry, but this is a little scary at first.

Also, this may be useful:

http://www.mssqltips.com/sqlservertip/2108/identify-database-features-restricted-to-a-specific-edition-of-sql-server-2008/

If the partition function(s) and scheme(s) aren't being used, then there is no reason they couldn't be removed.

How are you doing the mirroring, between desktop systems or between two instances on the same desktop?

What port(s) are you configuring for the instances?

Is data being entered one row at a...

JeepHound (10/31/2014)

---

I am restoring a 3rd party Vendor database from SQL2008R2 Enterprise to SQL2008R2 Standard. I get an error that I can't restore because there is a partition function....

It is more than just the schema. Tell us more about the user that is calling the procedure.

1) Define "last".

2) How is the data being inserted?

kyagi.jo (10/31/2014)

---

Hi,

I am writing a stored procedure which updates a table, but when I run the stored procedure using a login that I have granted execute privileges on, then...

A lot of work to round a value to 2 decimal points....

Daniel Matthee (10/28/2014)

---

Hi

Try this way

as my prev piece of code but only change the left join between the tables.

CREATE TABLE #REV_BINDERS2

(

...

Remember ISNUMERIC simply tells you that a value may be converted to a numeric value, it just doesn't tell you what numeric value. Using your example of 1E2:

select CAST('1E2'...

Jeff Moden (10/26/2014)

---

COFFEE!!! I NEED...

selpoivre (10/26/2014)

---

CREATE TABLE [REV_BINDERS2](

[OFFICE_ID] [int] NOT NULL)

insert into REV_BINDERS2(OFFICE_ID)

select '1126' union all

select '1127' union all

select '1128' union all

select '1129' union all

select '1130' union all

select '1131' union all

select '1132' union all

select...

Actually: select sum(saletotal)/(NumberofDays+0.0) -- << Remember order of precedence for mathematics.