SQLRNNR (1/6/2012)

---

That sounds a lot like some...

MysteryJimbo (1/6/2012)

---

Brandie Tarvin (1/6/2012)

---

Does anyone know why a Transact-SQL job step that executes a stored procedure and returns a "Query timeout" response continues on as if the job step succeeded?

Is...

There's no must about it. You...

Picky, picky, picky.

You sound just like an end user.

It's more than just the quotations. NUMBER is an invalid data type...

At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.

I shall now run away and hide before anyone...

AHA! Try using square brackets around the login name:

http://blog.sqlauthority.com/2008/12/24/sql-server-disable-and-enable-user-sa/%5B/url%5D

Here's a link to Books Online for creating tables in SQL Server:

http://msdn.microsoft.com/en-us/library/ms174979.aspx

Delario (1/6/2012)

---

so far I have created the table base on your advice, and my time table looks likes this:

CREATE TABLE "DIM_TIME"

(

"TIME_KEY" NUMBER,

...

Are you logged in as a local admin / sysadmin when trying to make this change? If you read the entry, it says "local admin" must grant normal users permissions,...

You create it the same way you would create a normal table, only you populate it with dates and date parts, depending on your needs.

Do you need to keep...

What authentication are you using? Mixed Mode or Windows?

SQL Express has a default of disabling the SA account in Windows authentication mode per MS: http://msdn.microsoft.com/en-US/library/ms345154(v=SQL.90).aspx

...

The SA or System Admin account...

Paranoia

Evil Kraig F (1/5/2012)

---

One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss...

Stefan Krzywicki (1/5/2012)

---

Speaking of venting vaguely, don't you just love when there's a third party tool (maybe even made by another group in your company) with a database you can't...