Viewing 15 posts - 4,921 through 4,935 (of 9,715 total)
GilaMonster (1/6/2012)
Brandie Tarvin (1/6/2012)
First of all, Jason, you spelled "review" wrong.What, you believe databases should be spelt correctly? How quaint.
Yeah, I'm kinda old fashioned that way.
Just got my copy...
January 6, 2012 at 11:38 am
crookj (1/6/2012)
SQLRNNR (1/6/2012)
crookj (1/6/2012)
Ninja's_RGR'us (1/6/2012)
crookj (1/6/2012)
WOTD - TMI(Heard it in the office 3 times already today...)
So stop giving TMI 😛
Been suffering from NEI
Not Enough Info. Can't make a good...
January 6, 2012 at 11:33 am
PaulB-TheOneAndOnly (1/6/2012)
Brandie Tarvin (1/6/2012)
Delario (1/6/2012)
sql developer in fact I just copy the syntax, i know that the quataion marks are not allow
It's more than just the quotations. NUMBER is an...
January 6, 2012 at 11:31 am
SQLRNNR (1/6/2012)
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
That sounds a lot like some...
January 6, 2012 at 11:28 am
MysteryJimbo (1/6/2012)
Brandie Tarvin (1/6/2012)
Is...
January 6, 2012 at 11:24 am
azdzn (1/6/2012)
The step must have "Go to the next step" as "On failure Action".See advanced tab in Job STep properties to set up this option.
There's no must about it. You...
January 6, 2012 at 11:20 am
Ninja's_RGR'us (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
Since inception, here are the postsWith yearly rollup please?
Picky, picky, picky.
You sound just like an end user.
January 6, 2012 at 9:14 am
Delario (1/6/2012)
sql developer in fact I just copy the syntax, i know that the quataion marks are not allow
It's more than just the quotations. NUMBER is an invalid data type...
January 6, 2012 at 8:58 am
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...
January 6, 2012 at 8:32 am
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
January 6, 2012 at 8:26 am
Here's a link to Books Online for creating tables in SQL Server:
January 6, 2012 at 8:23 am
Delario (1/6/2012)
CREATE TABLE "DIM_TIME"
(
"TIME_KEY" NUMBER,
...
January 6, 2012 at 8:21 am
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,...
January 6, 2012 at 8:19 am
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...
January 6, 2012 at 6:49 am
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...
January 6, 2012 at 5:50 am
Viewing 15 posts - 4,921 through 4,935 (of 9,715 total)