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 |
|
atemperly
Starting Member
3 Posts |
 Posted - 2011-10-25 : 11:38:00
|
| Trying to attach database to SQL 2000. Getting the following:MIcrosoft SQL-DMO (ODBC SQLStates: 42000)Error 2812: Could not find store procedure 'master.dbo.xp_fileexit'.Any suggestions to how I can the attached database? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-25 : 11:50:13
|
| are you sure it's not xp_fileexist?Have you checked to see if it does exist - see if you have it on other machines.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
akhan
Starting Member
3 Posts |
Posted - 2011-11-14 : 06:27:55
|
| Dear Sir,I am using SQL Server 2000 and the problem i am facing that my database automatically is detach and when i attach again my database after few hours its detach again. Please guide me and reply me on asif.khan1979@hotmail.com |
|
|
|
akhan
Starting Member
3 Posts |
Posted - 2011-11-14 : 06:28:23
|
Dear Sir,I am using SQL Server 2000 and the problem i am facing that my database automatically is detach and when i attach again my database after few hours its detach again. Please guide me and reply me on asif.khan1979@hotmail.comquote:
Originally posted by atemperly
Trying to attach database to SQL 2000. Getting the following:MIcrosoft SQL-DMO (ODBC SQLStates: 42000)Error 2812: Could not find store procedure 'master.dbo.xp_fileexit'.Any suggestions to how I can the attached database?
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-14 : 06:32:46
|
| SQL doesn't automatically detach databases ever. There will be a job or process running that's detaching them.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Attach database error 2812