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.

dbcc shrinkfile (dbname , targetsize)

but target size will work only upto the limit you defined for default space.

Try changing the database recovery to simple and then back to full.

Also dbcc...

is the drive where you have your userd database are alive and accessible?

Any problem with disk?

Give more information about your user database

yes, thanks for help.

It worked perfectly.

thanks for reply, but actually the data need to be updated in same table.

So lets say table a have all those data which I am able to convert using function.

But...