Viewing 15 posts - 5,041 through 5,055 (of 7,191 total)
Please post the whole sqlcmd command that you issued.
Thanks
John
October 5, 2011 at 8:26 am
Ghanshyam
From the few details you've provided, it sounds like you need third party log reading software. I've never used any myself, so do a quick search and see what...
October 5, 2011 at 8:04 am
branovuk (10/5/2011)
Still, I wonder is there anything can go wrong?
Brano
Unfortunately, there is, because if UPDATE...FROM causes cardinality errors then there is no error message. Consider the situation where table2...
October 5, 2011 at 7:52 am
L' Eomot Inversé (10/5/2011)
I find it quite frightening that so few people know enough about normalisation to get this one right.
I don't. This question is couched in abstract language....
October 5, 2011 at 7:29 am
branovuk (10/5/2011)
Thank you,I solved with CASE statement.
It's traditional, when people have gone to the trouble to help you, to post the solution you ended up with. This will also...
October 5, 2011 at 7:07 am
branovuk (10/5/2011)
How to use CASE statement (or similar, maybe if?),
because it is not just Update, it is based on data from table2 another values in...
October 5, 2011 at 6:58 am
Marin
A self join is the way to go - on r1.ID = r2.ID-1. Show us what you've tried, and we'll show you where you're going wrong.
John
October 5, 2011 at 3:18 am
Raymond
When I've needed to do stuff like this, I've used SSIS. The control flow allows you to handle the restore and all the associated tasks such as getting the...
October 5, 2011 at 3:14 am
A good overview of the INFORMATION_SCHEMA views, Tom, and I, like Eric, also use them where possible. For the situation you mentioned with the routine definition spanning two rows,...
October 4, 2011 at 7:22 am
This is something that's best done in the presentation layer. I don't know any way of doing it in the database layer without using some horrible dynamic SQL.
John
October 4, 2011 at 3:35 am
And is it working now? If not, you say you can open it in BIDS and run it. Have you tried saving it and running the newly saved...
October 3, 2011 at 4:41 am
Taggs
The command you posted earlier doesn't include the full path to the executable. That was my point. If you don't specify the path, then it'll use the first...
October 3, 2011 at 4:25 am
What may be happening is that the job system is running the wrong version of DTExec.exe. I take it your job step uses the SQL Server Integration Services Package...
October 3, 2011 at 4:13 am
Taggs (9/30/2011)
I have two versions of SSIS running on the server. (Ver 9 and Ver10 both 64bit)
I would start with this. Sounds like you're inadvertently trying to run a...
September 30, 2011 at 9:13 am
Viewing 15 posts - 5,041 through 5,055 (of 7,191 total)