Viewing 15 posts - 3,466 through 3,480 (of 6,216 total)
No problem. Let us know if you have more questions!
Andy
August 15, 2002 at 7:30 am
August 15, 2002 at 7:00 am
Thats correct - once you detach SQL doesnt know anything about it.
Andy
August 14, 2002 at 6:31 pm
Unless its a big club you might find Access to be a more cost effective solution. If you're having the db hosted by someone else, they will have the licenses...
August 14, 2002 at 6:00 pm
August 14, 2002 at 5:58 pm
Nothing that I know of. One way would be to pull the list of mdf's, then query against (sysfiles? have to look) to see if its listed. Or you could...
August 14, 2002 at 5:57 pm
See if any of this helps:
http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp
Andy
August 14, 2002 at 11:50 am
I there is a clean up proc that will get rid of them, been a long while since I looked.
Andy
August 14, 2002 at 10:51 am
Pretty strange. One thing you might try is killing them from task manager. One theory is that you're getting some kind of error that you're not seeing since it runs...
August 14, 2002 at 10:48 am
I've had times with both versions where it wouldnt open the port for some reason, a restart always fixed it.
Andy
August 14, 2002 at 10:45 am
August 14, 2002 at 10:44 am
Not that I know of. You could write to the table directly, or just log it into another table.
Andy
August 14, 2002 at 6:29 am
You can use sp_oacreate to run the filesystemobject, put the results in a table and export using DTS. Thats two to start with.
Andy
August 14, 2002 at 5:50 am
What version of SQL and what service pack? Running the distribution agent continuously?
Andy
August 13, 2002 at 5:53 pm
You can detach, then reattach using sp_attach_single_file_db which will create the log file for you. If you had multiple log files it's harder, I've got an article posted that has...
August 13, 2002 at 5:35 pm
Viewing 15 posts - 3,466 through 3,480 (of 6,216 total)