Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asuni
Yak Posting Veteran
55 Posts |
 Posted - 2010-05-21 : 03:29:51
|
| Hi All,I have created one user named as user1 using the commands:EXEC sp_addlogin 'user1', 'user1' EXEC sp_adduser 'user1'EXEC sp_addsrvrolemember 'user1', 'sysadmin'then i logged in with that user and running one option from my application.In that application i creating one temp table named as 'Z' and using it and dropping at the end using applicaiotn only.But at my place no error i am getting, but at client place they are getting the following error.I am connecting to my application using ODBC drivers.Microsoft SQl Server:3701[Microsoft]ODBC SQL Server Driver][SQL Server]Cannot drop the table 'Z',because it does not exist or you do not have permission.Error No :200050what to do any help please?thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-21 : 04:19:15
|
Since the name Z says that it is not a temp table then maybe another session has already dropped it?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
asuni
Yak Posting Veteran
55 Posts |
Posted - 2010-05-21 : 04:36:25
|
| ok, i will check in this waythanks |
|
|
|
|
|
|
Drop table error