Viewing 15 posts - 1,351 through 1,365 (of 7,168 total)
The issue of whether to use it or not also seems to go a bit beyond security, spilling into application design. If we break this down into two areas where...
April 2, 2013 at 11:31 am
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...
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...
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...
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...
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...
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...
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...
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?
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...
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...
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...
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?
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?
April 1, 2013 at 11:41 am
Anytime. Thanks for posting back the nature of the problem and solution so others may benefit.
April 1, 2013 at 11:39 am
Viewing 15 posts - 1,351 through 1,365 (of 7,168 total)