Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

status of the database after sp_attach

Status
Not open for further replies.
eja2000

eja2000

Programmer
Nov 30, 2003
209
NG
is there a success code after sp_attach?
or is there any way i can know if the attach was successful..

thanks
 
Sort by date Sort by votes
Just try to query it, if you get a login failed/permission denied to the database it wasn't successfull.

try:
Code: 
select * from mydb..sysobjects



[bandito] [blue]DBomrrsm[/blue] [bandito]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
578
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
397
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
576
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
895
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top