Viewing 15 posts - 7,576 through 7,590 (of 26,490 total)
Grant Fritchey (5/17/2013)
Or just turn off intelisense and get a tool that works.
I have had to turn of SQL Prompt here at work as it sometimes fails due to memory...
May 17, 2013 at 11:26 am
Lynn Pettis (5/17/2013)
After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to...
May 17, 2013 at 11:22 am
devanandiiway (5/17/2013)
Yes the next run is scheduled to 2032. How can I change things back to normal.
Using the same tool. Go through the properties of each job and reschedule...
May 17, 2013 at 11:22 am
I'm not sure what you mean by duplicate. If there is a one to many relationship between table a and table b (your inner join), then yes, you will...
May 17, 2013 at 11:15 am
And we have another winner:
After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the...
May 17, 2013 at 11:13 am
devanandiiway (5/17/2013)
After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?
In the...
May 17, 2013 at 11:09 am
devanandiiway (5/17/2013)
All the jobs were running fine except for the past two days. I don't know what happened. Two days before my server date was changed automatically(from 2013 to...
May 17, 2013 at 10:58 am
m.rajesh.uk (5/17/2013)
...
1. what type of pages are used in bulk log recovery model.
Same kind of pages used in Simple and Full recovery models. Transaction log doesn't use pages, uses...
May 17, 2013 at 10:53 am
amar_kaur16 (5/17/2013)
Now this table contains decision column
If decision has been made, then decision=’yes’/’No’
If decision hasn’t been made decision=’none’
Now the tables gets...
May 17, 2013 at 10:13 am
You may want to look up SQLCMD in BOL as that would be a good place to start: http://msdn.microsoft.com/en-us/library/ms162773(v=sql.90).aspx.
May 17, 2013 at 10:07 am
Eugene Elutin (5/17/2013)
T.Ashish (5/17/2013)
So should I say that it is the old way of INNER JOINing tables, that will not be supported in future versions !!
No, that's incorrect. The older...
May 17, 2013 at 9:46 am
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
Hmm, recall seeing that somewhere before....
Is that from the same person who thinks that NOLOCK makes queries...
May 17, 2013 at 8:33 am
jcrawf02 (5/17/2013)
Brandie Tarvin (5/17/2013)
Lynn Pettis (5/16/2013)
Second PM:no, they derail my posts. The post is first and foremost for me, secondly for all others having same problem.
The post is for him?
That...
May 17, 2013 at 8:31 am
And I will just have to disagree with you. I would find it more difficult to work with, The current syntax is just fine.
May 17, 2013 at 5:56 am
opc.three (5/16/2013)
Kold Koffee. We're volunteers so the lack of a response within a few minutes ir even hours just means we may have had to...
May 16, 2013 at 6:54 pm
Viewing 15 posts - 7,576 through 7,590 (of 26,490 total)