| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 KizerSQL Server MVP since 2007http://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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
doniebach
Starting Member
7 Posts |
Posted - 2014-10-13 : 17:39:49
|
| So how to anticipate this problem?could u give me a detail? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
doniebach
Starting Member
7 Posts |
Posted - 2014-10-13 : 18:11:56
|
| the permission is public |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
SP_ExportData gone