Viewing 15 posts - 7,051 through 7,065 (of 7,164 total)
Assuming I correctly understand this, the error msg is saying I can't use a Stored procedure to call another Stored Procedure.
No, that is not what it is telling...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 3:12 pm
You may not want to remove all of them, please see this post: http://www.sqlservercentral.com/Forums/FindPost541758.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 2:28 pm
You have a nice file with escaped text delimiters but SSIS still does not care 🙂 This in my opinion is a *glaring* deficiency in SSIS and one that I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 2:17 pm
Sure, get out of SSMS and go to a cmd prompt on your local machine...then run the BCP command your T-SQL outputs directly:
bcp "SELECT APPLICATION_NAME FROM PARTI.dbo.applications FOR XML...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 2:11 pm
This looks like homework 😉
I'll give you a hint though, refer to the error message and then look at the definition for your table named @vool, it's PRIMARY KEY and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 2:07 pm
Do you have an XSD for your XML?
If not you can derive one using SSMS. Open your XML document in SSMS and from the XML menu (only shows when in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 1:56 pm
Can you please provide the DML to populate your tables with the data you're using in your examples?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 1:50 pm
I hope I am missing something and someone shows me the way on this one, it is why I jumped onto this thread, but from all my reading and experience...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 1:45 pm
I don't have a concrete solution for you but I do have some random thoughts on the matter. If it sparks additional conversation or evokes a solution from another, then...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 11:43 am
This may help you get started:
http://www.sqlservercentral.com/scripts/foreign+keys/69110/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 10:09 am
...and will be created under some different user.
The requirement that schemas be strictly linked to database users of the same name last existed in SQL 2000. Some folks still use...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 9:45 am
You're very welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 2, 2011 at 7:46 am
Jeffery Williams (3/1/2011)
I have one more issue. Now I create an export that is 0 bytes with an...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2011 at 10:16 pm
Not that you won't receive help here...but there are dedicated SSRS forums on SSC:
http://www.sqlservercentral.com/Forums/Group416.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2011 at 4:20 pm
You'll want to provide the "server\instance" name after -S.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2011 at 3:28 pm
Viewing 15 posts - 7,051 through 7,065 (of 7,164 total)