| Author |
Cannot create a temp table
|
|
| MNDiver 2005-07-19, 1:23 pm |
| I am unable to create a temp table in DTS using the Execute SQL Task.
I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))
The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create the
table.
Does anyone have any suggestions?
| |
| Rick Gittins 2005-07-19, 8:24 pm |
| Can you run this statement with the same user in Query Analyzer? It looks
like a security issue.
Rick
"MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
news:582FB8B0-1750-49AF-9DAF- AAEE610AE8D5@microso
ft.com...
>I am unable to create a temp table in DTS using the Execute SQL Task.
>
> I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
> and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))
>
> The connection is pointed to Tempdb on the server I am using.
> When I click execute I get a success dialog box but it does not create the
> table.
> Does anyone have any suggestions?
>
| |
| MNDiver 2005-07-19, 8:24 pm |
| Thanks for the reply Rick. I tried it on a server where I have sa rights and
still no good. I can create the table in Query Analyzer on either server with
no problem. Is there a bug in DTS or EM that would cause this?
"Rick Gittins" wrote:
> Can you run this statement with the same user in Query Analyzer? It looks
> like a security issue.
>
> Rick
>
> "MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
> news:582FB8B0-1750-49AF-9DAF- AAEE610AE8D5@microso
ft.com...
>
>
>
| |
| Rick Gittins 2005-07-19, 8:24 pm |
| It's not a bug because I have been able to do it.
Is the user that is logged into Query Analyzer the same that you are logging
into EM?
Rick
"MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
news:9DAD4ED2-5FCF-416A-BDF2- 76DBD013D003@microso
ft.com...[color=darkred]
> Thanks for the reply Rick. I tried it on a server where I have sa rights
> and
> still no good. I can create the table in Query Analyzer on either server
> with
> no problem. Is there a bug in DTS or EM that would cause this?
>
> "Rick Gittins" wrote:
>
| |
| MNDiver 2005-07-20, 7:23 am |
| Yes, I am logged into both EM and QA as the same user.
"Rick Gittins" wrote:
> It's not a bug because I have been able to do it.
>
> Is the user that is logged into Query Analyzer the same that you are logging
> into EM?
>
> Rick
>
> "MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
> news:9DAD4ED2-5FCF-416A-BDF2- 76DBD013D003@microso
ft.com...
>
>
>
| |
| MNDiver 2005-07-20, 9:23 am |
| New day, new eyes. Found my error... referenced conneciton was to same db in
different server. Thanks for the assistance.
"Rick Gittins" wrote:
> It's not a bug because I have been able to do it.
>
> Is the user that is logged into Query Analyzer the same that you are logging
> into EM?
>
> Rick
>
> "MNDiver" <MNDiver@discussions.microsoft.com> wrote in message
> news:9DAD4ED2-5FCF-416A-BDF2- 76DBD013D003@microso
ft.com...
>
>
>
|
|
|
|