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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 SP_ExportData gone

Author  Topic 

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 17:02:57
I was using SQL server 2000 with remote desktop as administrator login to windows server 2012 and everything just fine. after that I logon directly to my windows with administrator login and I found SP_ExportData is gone. Could u explain why?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 17:05:15
You either don't have access to it, or somebody deleted it. There's no magic.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 17:16:14
quote:
Originally posted by tkizer

You either don't have access to it, or somebody deleted it. There's no magic.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



don't have acces? using Remote desktop gave me authorization to acces as administrator,I can do anything with it. deleted?that's out of my concern
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 17:27:52
Using Remote Desktop does NOT necessarily give you sysadmin to the SQL Server. It depends how it was setup. By default in SQL 2000, local administrators were members of the sysadmin role. However, DBAs/admins could have changed it because of best security practices. You'll need to verify what your access is on that instance.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 17:39:49
So how to anticipate this problem?could u give me a detail?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 17:41:32
I don't have SQL Server 2000 anymore, but you should be able to double check your access in Enterprise Manager through Security\Logins. Double click on your login. What server roles does it have? In the user mapping page, what access to each database do you have? Do you have db_owner?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 18:01:15
My SQL server authentication is server login and windows account.Should I change audit level?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 18:04:55
No. We need to know what your permissions are. "server login and windows account" does not answer that.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 18:11:56
the permission is public
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 18:12:59
Then you almost certainly don't have permissions to that stored procedure.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 18:24:16
so that's why SP_ExportData's gone?or there something I did it wrong?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 18:26:42
If you only have public access, then you can't see it due to permissions. I have no idea if you did something wrong. I can only go by what you are telling us in this topic.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

doniebach
Starting Member

7 Posts

Posted - 2014-10-13 : 18:40:13
I was using a custom software to export import from database, but somehow SP_ExportData and SP_ImportData is missing. Is it possible that Remote Desktop causes this?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-13 : 19:12:37
Remote Desktop definitely did not cause it. I would imagine that the export/import did cause it though. But that's only if this is not a permissions problem.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -