looks like licensing:

licensed for cores on the hardware, or optionally with client cal licenses:

http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx

SET QUOTED_IDENTIFIER OFF

USE "SandBox";

select * from sys.tables

--above shows a syntax error

GO

SET QUOTED_IDENTIFIER ON

USE "SandBox";

select * from sys.tables

--above works just fine

Charmer (3/30/2012)

---

Lowell (3/30/2012)

---

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you wanted...

anthony.green (3/30/2012)

---

another way would be to create a custom DDL trigger for the CREATE_PROCEDURE event which reads in the XML details of the procedure creation and checks the schema XML...

i think that syntax was valid for 2000, but not 2005 and above;

as i remermber it the solution is simple...

include the sd.SalesOrderId in the select, and

i believe...

both answers help me visualize this a lot, thanks guys;

The Coupon/Discount table's the way I'm thinking as well...it's like Sean said, the discounts apply to the order, not the individual...

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you wanted a table...

the error 'cannot assign a default variable' shows the script is for 2008+, and you are running it on 2005;

it'll need a couple of minor tweaks.

i would prefer to track the cost price and the retail price, and calcuate the percentage of markup myself.

so often the retail price is going to end in "9", to...

if this helps anyone, or generate suggestions for my process, great!

this is exactly how i do it.

in my case, i need an individualized email for each recipient...no emails with mulitple...

pragyan.banerjee (3/29/2012)

---

Hello All,

I have all the credentials handy but still I couldn't connect to a database from enterprise manager,

its giving the reason :"Sql server not exist or access denied".

My question...

i'm already leaning towards a not null constraint violation; every column in the table is defined as not null, so if the entity framework creates a command with a null...

how about adding another server side trace that captures all errors and warnings , and limit it to just the database in question.

http://support.microsoft.com/kb/199037

then you might see that some basic error,...

ok two questiosn for you:

you are getting TOP 10 from each database with no ORDER BY...were you trying to get slow running queries? ie the ones with a long elapsed...

another issue to consider: is there a trigger on the table in quesiton? if the trigger fails, the insert fails, and the data "disappears" like you seem to be identifying.

could...