Viewing 15 posts - 1,351 through 1,365 (of 7,164 total)
I am not able to recreate your issue using the ExecuteNonReader. One thing that looks odd is this line:
$db.Create()
Why are you trying to create a new database? Maybe this is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 5:48 pm
mister.magoo (4/1/2013)
Lynn, Nope that pretty much sucks too! :hehe:
Lynn's numbers seem off to me. I got ~10s for your method and ~50ms for Lynns. But Lynn's numbers make it look...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 5:03 pm
I'll give you the @objtype change as something to be corrected, and the second as I just reread ap_rename. Now, how to deal with multiple schemas??
Without testing, does the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 5:02 pm
mister.magoo (4/1/2013)
I don't have a suitably large database to test on , but I am sure you will see some improvement if you test it that way...
You have done it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 4:49 pm
That seems to be a function of continually updating an NVARCHAR(MAX) which does not scale linearly. It gets truncated so it's worthless to use it but if you run the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 4:43 pm
Dave Pendleton (4/1/2013)
If I copy the file "manually" to the drop folder it will work every time. When...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 3:05 pm
I use a slightly different method to avoid some of the entitization problems FOR XML brings with it. Technically it is an undocumented method that I know of but I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 2:37 pm
Lynn Pettis (4/1/2013)
And yes, I have created dynamic code that actually exceeds 8000 bytes and does multiple commands.
Mind if I ask what made you break them into multiple commands?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 2:34 pm
I am with Andrew on this one. I would probably use SSIS for this as well. This would allow you to get rid of the stored procedure that calls BULK...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 1:51 pm
nihal9200_kwada (4/1/2013)
Open ssis package in BIDSPackage properties
creator name is old DBA
creator name is different than owner name?
No, different. I thought that might be what you were looking at. The value...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 1:25 pm
Grant Fritchey (4/1/2013)
Glad to hear it's fixed.Just curious though, why not use a PowerShell type of step in SQL Agent for a PowerShell script?
Depending on what your script does sometimes...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 1:10 pm
Where are you seeing the previous DBA listed as the owner? In the properties of the SSIS package or somewhere else? Maybe in the SQL Agent jobs?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 12:32 pm
It depends on the requirement. What are you trying to do? How fresh does the data need to stay? Is there a fast network link between the involved databases?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 11:41 am
Anytime. Thanks for posting back the nature of the problem and solution so others may benefit.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 11:39 am
greeshatu (3/29/2013)
I have scenario where I need to Call an Storeprocedure in SQL task
Eg: Procedure Name Like Usp_ABCDEF 'Param1',Param2'
Part of Stored Procedure name is coming from Varible
Eg:...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 1, 2013 at 11:37 am
Viewing 15 posts - 1,351 through 1,365 (of 7,164 total)