URGENT! SQL WON'T RECOGNIZE A DATABASE

[Guest_imported]

I have a database that sql won't reconize. I need to connect the database and sql...

due to spacing issues on the server, I have deleted the transaction log...............


PLEASE HELP MMMMMMMMMMMMMMMMMMMEEEEEEEEE

 

[tlbroadbent]

Which database are you using?

If MS SQL Server 7 and above use sp_attach_single_file_db.

Syntax:

sp_attach_single_file_db [@dbname =] 'dbname',
[@physname =] 'physical_name'
Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[Tim1]

Hiya,

What error message do you get? Are you sure that the user name that you are using has privilages into that database?

Tim