Viewing 15 posts - 6,676 through 6,690 (of 7,164 total)
That's great news! Windows Scheduler calling a batch file would work. SQL Agent doing the same, or calling bcp.exe directly would also work. SQL Agent jobs have a step type...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 1:39 pm
CirquedeSQLeil (4/12/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 1:35 pm
Sorry, double post...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 11:25 am
CirquedeSQLeil (4/12/2011)
you could look into doing an nslookup in combination with xp_cmdshell
That implies turning on xp_cmdshell which is off by default...for good reason.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 11:25 am
From T-SQL you'd have to read the registry or run a WMI script. I would recommend inverting your design and developing a SQL PowerShell script that can grab the host...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 10:59 am
You are in an area that not a lot of people go. With all due respect, this scenario is exactly why DBAs who do not have close working relationships with,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 12, 2011 at 7:42 am
Jeff Moden (4/8/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 11, 2011 at 5:26 pm
aqsluck (4/11/2011)
I want to insert this value into table two where I want to insert only time and it should not take date.
SQL 2005 (the forum you posted in) does...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 11, 2011 at 10:25 am
Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1091056-391-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2011 at 2:46 pm
Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1089813-364-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2011 at 2:38 pm
steve smith-401573 (4/8/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 4:10 pm
Lamprey13 (4/8/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 3:11 pm
steve smith-401573 (4/8/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 2:57 pm
I have not tried it within SSIS but the OUTPUT clause will generate a resultset for you with your ID that you may be able to pipe into a variable...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 2:34 pm
I thought so too so I figured I would share it. The performance benefits are enough reason to add it to the toolkit. The fact that it reads a bit...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 8, 2011 at 2:29 pm
Viewing 15 posts - 6,676 through 6,690 (of 7,164 total)