Dear

you have to create another account like Vendor user

and make DBO of the particular database that you wana share with

the vendor.

Regards

Syed muhammad naveed

database Administrator

Dear Steve

what i understand that you want to give a very limited rights to your developers ok and also you dont want lose winows authentication mode

because your most of...

if you have deleted your log file LDF dont worry

through this software you can get back your LDF file

1) file Scevenger

2) Get data back

when you get LDF file...

actually i m sharing you my personal experience you know the database is totally depend on the operating system if the problem occur in OS then database will not enter...

dear

just login your system with local admin

and start sql server properties.

it will work

but if will not work then

login your database to SA acount

it will work

but...

Dear CJR

dont worry its happened

any ways i am giving you some techenique if you follow you will get rid off this issue

For example your Database name is...

ok dear dont worry

just apply this techenique

right click on your corrupted LDF file and mar read only option

and then attached it again inshallah it resolved.

Regards

Syed Muhammad Naveed...

dear Eric

i have one techenique for you just apply may be your problems will resolve.

i am sure that you still have LDF and MDF file in your hard drive.

just rigt...

i have execute the DBCC command for db and table as well but result is same also i have execute the select query of paritcular table it was run fine...

i have done it to execute DBCC for database and DBCC for table as per your instruction but there is no change i am facing a same problem what should...

thanks for assistance i got the result positive.

now i have another issue when i make the mirroring between 2 instance it shows the message.

"  Database mirroring is disabled by default....

i think the problem is in ur link or LAN just check it out

and another think is that u have to check domain connection with client and server because most...

ohhh sir your great

i got the actual result

Thanks

we have another way to rebuit a new log file

you just detach the database and attached with new log file option through enterprise manager attached and deattached utility option .

it...

select max(a.sal),max(b.sal),max(c.sal) from emp a , emp b, emp c

where a.sal>b.sal and b.sal>c.sal

Dear Newbie. inshallah this query will give u a accurate result.

Reagrds

Syed Muhammad Naveed

Database Administrator

Saudi Pak Bank Karachi ,Pakistan...