hi sasidhar,

your code is correct.

have you configured database mail in sql server.

EXEC msdb.dbo.sp_send_dbmail

@recipients='avinash@abc.com', ---where abc is the domain

@profile_name ='avinash', --avinash is...

hi,

execute as user='guest'

select * from dbo.guesttable

This will show that the select permission is denied for the user guest.

one option is to take the profiler output to tables directly while creating a trace file

and if suppose you have taken the trace output to a .trc file you can...

hi shanila,

i think you are using the sql server default instance, right. if so,

your system administrators might have changed the server name after installing the sql server.

you can check it...

when you use sp_detach_db your database will be shutdown cleanly by the sql server. or else you can use shutdown transact sql to shutdown the database.

yeah glia,

you are right, we need to use create database statement to attach a file instead of sp_attach_db but i just gave this option as an option for now. any...

hi,

you have a suspect database, right.

1. the prefered way is to restore it from backup you have taken,

2. if you have taken the ldf and mdf files backup while the...