Viewing 15 posts - 4,861 through 4,875 (of 9,715 total)
Jeff Moden (1/15/2012)
GilaMonster (1/14/2012)
I've seen Transcender sample tests before, they're miles from the real exams.
Then, totally switching gears, are such sample tests actually helping to learn those things necessary to...
January 16, 2012 at 4:55 am
olingerd (1/13/2012)
It looks like everything is fine and I am able to send a test email successfully but still no email job notification upon job completion (and yes I...
January 13, 2012 at 9:59 am
thotvedt (1/13/2012)
January 13, 2012 at 9:18 am
jbalbo (1/13/2012)
Wow never picked it up!!
It's probably the most common sql server mistake ever made and everyone, even the experts, make it constantly. Just remember: If everything else looks correct,...
January 13, 2012 at 9:14 am
SQL Kiwi (1/13/2012)
What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.
I was going to ask him to lock it.
January 13, 2012 at 7:14 am
Can someone who knows more about C# help out here?
He's passing code to SQL Server and not getting things to work. I'm half out of my depth and half too...
January 13, 2012 at 7:13 am
You've followed all the steps below?
January 13, 2012 at 6:46 am
HemSingh (1/13/2012)
Brandie Tarvin (1/13/2012)
I refer you back to my last response.Use IN instead of = on the stored procedure and concatenate the values together......
Hi Brandie Tarvin,
I am trying yr...
January 13, 2012 at 6:36 am
You say you set up DBMail, but did you set up Operators?
January 13, 2012 at 6:12 am
jbalbo (1/11/2012)
Hi,Getting a syntax error on the following..
INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)
SELECT TAG_NAME = 'CUST_AGE',
TAG_DATA = (SELECT FLOOR(DATEDIFF(day, BDate, CURRENT_TIMESTAMP) / 365.25))
FROM client
WHERE Client.OID =@CLIENT_OID);
To answer your original question...
January 13, 2012 at 6:10 am
I don't understand your question because it has no context. When you say "cluster" are you referring to data in a table or an actual SQL Server Cluster set up?
Please...
January 13, 2012 at 6:07 am
kwoznica (1/12/2012)
So what is the best way to enforce referential integrity? Should I add a constraint to the CaseData table?
You should be able to create a regular Foreign Key Constraint...
January 13, 2012 at 6:04 am
Let's go back to your original question.
What happened? Why do you need to read data from your log file?
And do you just want to read it or are you...
January 13, 2012 at 5:59 am
You can create a SQL Server job with a Transact SQL job step that runs your update code on a weekly schedule.
If you want more information, please post more details,...
January 13, 2012 at 5:53 am
I refer you back to my last response.
Use IN instead of = on the stored procedure and concatenate the values together. You can expand my single parameter query to...
January 13, 2012 at 5:51 am
Viewing 15 posts - 4,861 through 4,875 (of 9,715 total)