Enable and start that service first. Then try connecting to MAINPC\SqlExpress using SSMS 2012.

That still does not resolve the issue of someone having a job_id parked in some code somewhere and that job_id ceasing to exist when a job is dropped and recreated....

MyDoggieJessie (12/21/2012)

---

John Mitchell-245523 (12/21/2012)

---

I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could...

Sanity check before you change anything. You are trying to connect to MAINPC\SQLExpress through SSMS 2012, corrrect? Have you verified SQL Browser service is running?

For $ I would recommend an exact numeric data type with the scale you need to satisfy your accounting requirements.

well...2000 function calls x 13 months of data per report, while not the typical abuse-pattern, in some circles it...

What exactly does your .tbl file contain and by "execute" do you mean "import"?

No worries. You're doing fine with the use of Scalar UDFs. The way you are using them is actually the only way I support their use. I just do not...

Not unless you can deserialize the object using a SQLCLR object to review its properties, which I highly doubt. There is no native Java capability in SQL Server that would...

Comparing FLOAT and REAL to DECIMAL and NUMERIC is not really fair. The former are approximate numeric data types and the latter are exact numeric data types. I am leaving...

32-bit? Did you enable AWE?

The CTE syntax itself does not require a leading semi-colon. Rather the preceding statement must be terminated with a semi-colon.

Did you install Express Edition?

BenWard (12/17/2012)

---

Hello,

I have a database used for reports that has a bunch of scalar functions on it that generate assorted record counts etc. Scalar functions we know are inefficient but...

Regular views offer nothing from a performance standpoint. Views are simply replaced by their definition in the query submitted for execution and then optimized as if the query submittor had...