Viewing 15 posts - 4,441 through 4,455 (of 7,168 total)
Perry Whittle (4/18/2012)
opc.three (4/18/2012)
April 19, 2012 at 9:18 am
This is a shot in the dark because I cannot see what you see, but sometimes when compiling procedures additional code slips into the procedure definition if your batches are...
April 18, 2012 at 11:30 pm
C3PO's twin (4/18/2012)
Yeah I know that. But has SQL Server matured enough to be an Enterprise DBMS that can up for more than 6 months?
I would have to qualify the...
April 18, 2012 at 9:59 pm
mahinder.singh.chauhan (4/18/2012)
like one shift is start from 06:00am to 2:00pm and other shift is start...
April 18, 2012 at 3:15 pm
It's good business to provide the schema name as well to avoid any issues with scope where default schema names can get involved.
Also, do not provide square brackets in the...
April 18, 2012 at 2:54 pm
For a simple process like this you can do everything in SSIS using a variable to build the file name and then use that variable in both your Data Flow...
April 18, 2012 at 2:47 pm
patrickmcginnis59 (4/17/2012)
Eugene Elutin (4/17/2012)
zojan (4/17/2012)
If you want log steps of the SP_ you can use loging into log_table....
Not good option for SQL Server as there is no direct equivalent to...
April 18, 2012 at 2:40 pm
Lynn Pettis (4/18/2012)
opc.three (4/18/2012)
george sibbald (4/18/2012)
no thanks. despite your moral high tone you are just looking for confrontation. It would be a waste of time.
Suit yourself. You were the one...
April 18, 2012 at 11:21 am
The_Mo (4/17/2012)
By the way what does DDL stand for? what does it mean?
DDL stands for Data Definition Language
April 18, 2012 at 11:09 am
No problem...happy you got it sorted.
April 18, 2012 at 11:05 am
george sibbald (4/18/2012)
no thanks. despite your moral high tone you are just looking for confrontation. It would be a waste of time.
Suit yourself. You were the one who purported to...
April 18, 2012 at 10:59 am
You are on the right track with using dynamic sql to deal with the IN portion of the query.
The error you're receiving means the engine cannot find a column...
April 18, 2012 at 10:51 am
george sibbald (4/18/2012)
How about the thread? 🙂opc, you are still insulting me, I resent and refute your last post.
'nuff said.
I am pretty sure we have reached an impasse, you know...
April 18, 2012 at 10:30 am
That's a chicken-egg problem. If the Agent is not started your job won't start, and therefore won't be able to check and start the service 🙂
If you want to check...
April 18, 2012 at 9:49 am
jchappell 92664 (4/18/2012)
April 18, 2012 at 9:32 am
Viewing 15 posts - 4,441 through 4,455 (of 7,168 total)