Viewing 15 posts - 4,876 through 4,890 (of 9,722 total)
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
sql Anand (1/13/2012)
is there any way to do this in...
January 13, 2012 at 5:14 am
This can be translated down to a T-SQL "IN" clause. You can have 1 or multiple values in an IN clause (as opposed to an equals "=" query).
The key would...
January 13, 2012 at 5:05 am
So far as I know, and I may be working off of old knowledge, instances cannot be renamed. They have to be installed brand new with a new name.
January 13, 2012 at 4:58 am
Knowledge Hunter (1/13/2012)
My understanding is that I will ahve to get access for the SQL Server from someone who already has access to the SQL Server.
Yes, you will. Is there...
January 13, 2012 at 4:57 am
Evil Kraig F (1/12/2012)
This is more a linked server than a job issue. The proc itself won't error, so the job is clueless there was a problem.
When you put...
January 13, 2012 at 4:49 am
Evil Kraig F (1/12/2012)
January 13, 2012 at 4:45 am
Yeah, when all else fails, talk to the vendor. Maybe they can shed some light into the issues.
January 13, 2012 at 4:43 am
SQLKnowItAll (1/12/2012)
Brandie Tarvin (1/12/2012)
SQLKnowItAll (1/12/2012)
January 12, 2012 at 10:02 am
Viewing 15 posts - 4,876 through 4,890 (of 9,722 total)