use master

go

drop database 'adv...dw'

check if dist.. database exist in system database or not?

If in sql server 2005 or higher, check activity monitor. Might get some clue what process still running

are you restoring with correct version...

what i mean is...

lets say if the backup was taken by litespeed and you trying to restore from management studio or by sql server restore...

open cmd and run

sqlcmd -L

if you want output of this in text file, lets say in c drive then :-

sqlcmd -L >c:\serverlist.txt

cant stop my laugh.... when I read the first article in this post that people submitting the query like anything....

and then last update we still helping people.....

I think we should...

if you have similar data and want only one record then why not take the distinct record to temp table and then delete all those record which are not in...

windows authentication is for security purpose only. The access still need to be given from sql server either to the group the id belongs or login id itself

it depends how updated your indexes and tables are.

Clustered indexed columns are always preferrable in joins and then non clustered

As well what type of join you using.

your graphical execution plan will give the better idea which join is worse and which join is good.

Its hard to decide without knowing the query that which join will...

setup the restoration job again and make sure it change the database status to standby or readonly mode

good to hear it worked.

have you looked into errorlog. there must be some details.

is database4 the only database which have the problem OR there are other database as well.

Just try to rename the mdf and ldf file of the database. Are you...

sp_helptext......deleting your SP. strange.......never had such experience.....

i just executed it on ss2008 and able to see the code

have you tried sp_helptext to read the code.

It should diplay you code if you have permission to run SPs

sp_helptext 'objectname'

not sure but try with no lock

or

define your select queries so that it not goes uptill the inserted record.