Viewing 15 posts - 4,771 through 4,785 (of 7,187 total)
Jon
I'm afraid I don't know what you mean. Please will you post a CREATE TABLE statement along with some sample data from the table? One problem I can...
February 1, 2012 at 6:16 am
Ram
OK, I don't know why you're getting those messages, then. Sorry.
John
February 1, 2012 at 5:04 am
Flex? Never heard of it. But create a stored procedure on the SQL server and it's easy to call from any language. The code you posted looks...
February 1, 2012 at 3:55 am
I would seriously recommend that your boss read through the link I posted. It's heavy going, but rewarding. If he stills thinks dynamic SQL is the way to...
February 1, 2012 at 3:31 am
Ram
Unless there's someone here with a lot of experience with TDP, I think you'd be best off posting this question on a TSM/TDP forum, or getting support from IBM or...
February 1, 2012 at 3:01 am
I think the syntax error is because you've wrapped your parameter declarations in parantheses. However, I'm confused. You say your stored procedure creates a stored procedure, but there...
February 1, 2012 at 2:53 am
Mike
It's not seamless, I'm afraid. During a failover, the services stop on one node and start up again on another. Any open connections are therefore killed.
John
January 31, 2012 at 9:52 am
Write a formula in Excel or whatever spreadsheet package you're using. Then you can copy and paste it into your query.
John
January 31, 2012 at 9:02 am
Or right-click anywhere in the query window and choose Connection -> Disconnect. Then do the same, choosing Connection -> Connect.
John
January 31, 2012 at 6:38 am
Is this homework? What have you tried so far? Hint: use CROSS JOIN.
John
January 31, 2012 at 6:23 am
Isn't it like this:
LIKE '%''%'
I've got two single quotes in there instead of one double.
John
January 30, 2012 at 9:50 am
That's a US format date. It could be that the account that is running your package interprets it as a European format date. Make sure that the language...
January 30, 2012 at 8:01 am
Does the SQL Server agent service account have permissions on the .xls file? Also, is S a mapped drive? The service account won't be able to see it...
January 30, 2012 at 7:31 am
Does the SQL Server agent service account have permissions on the .xls file? Also, is S a mapped drive? The service account won't be able to see it...
January 30, 2012 at 7:30 am
Stewart "Arturius" Campbell (1/27/2012)
KWymore (1/27/2012)
One thing to note. Answer 2 and 3 don't match the case for columns "name" and "componentname" as declared in the example code. Since I know...
January 27, 2012 at 4:31 am
Viewing 15 posts - 4,771 through 4,785 (of 7,187 total)