Viewing 15 posts - 4,876 through 4,890 (of 9,715 total)
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
SQLKnowItAll (1/12/2012)
January 12, 2012 at 9:39 am
Stefan Krzywicki (1/12/2012)
I don't have the time I'd like to answer more questions, so I tend to answer in batches, but I learn every time I do.
That's me. Too...
January 12, 2012 at 9:36 am
SQLKnowItAll (1/12/2012)
Brandie Tarvin (1/12/2012)
SQLKnowItAll (1/12/2012)
January 12, 2012 at 9:30 am
Dev (1/12/2012)
Query on view will hit main database every time. Will it not consume the bandwidth? I believe that’s the main issues here.
Bandwidth is network. I don't believe...
January 12, 2012 at 9:12 am
Paul,
The rest of the discussion is happening here: http://www.sqlservercentral.com/Forums/Topic1234678-391-1.aspx
January 12, 2012 at 9:05 am
All,
This is not quite a double post. There is other advice happening in a different thread on this same topic.
http://www.sqlservercentral.com/Forums/Topic1234687-391-1.aspx#bm1234904
I think Paul has it right that the OP should consider...
January 12, 2012 at 9:04 am
I'm glad you figured it out. Thank you for posting the solution so others can find it.
January 12, 2012 at 7:22 am
Viewing 15 posts - 4,876 through 4,890 (of 9,715 total)