Viewing 15 posts - 4,441 through 4,455 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 11:09 am
No problem...happy you got it sorted.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 9:49 am
jchappell 92664 (4/18/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 9:32 am
It means there can be 32,767 user connections at any given time. This is not to say that millions of people could not use the same database server within the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 9:27 am
george sibbald (4/18/2012)
THE-FHA (4/17/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 9:18 am
Viewing 15 posts - 4,441 through 4,455 (of 7,164 total)