Thats a good Start, but as IAN mentioned.. Whats your Question... Also if possible Pl include Table Scripts and SAMPLE inserts... Pl 🙂

Can u post your Table(s) Structure here, with sample inserts

Use can use a cursor(nested) to perform the Following operation.

I did not understand one thing: how can column2=column3 as the values do not match, unless you have a Criteria set...

Group Mapping was always a Problem in Linked Server, you can use a SQL Login?

Index Id 0 relates to HEAP Tables.

so, it is not possible to Rebuild the HEAP Table.. and there will be no effect of your DEFRAG Statements on a HEAP TABLE.

Create a New User and assign it as sysadmin. Or Add your Windows ID in sysadmin Role. After you change the Original SA PAssword, you can undo the user Priviliges.

SQL 7.. then you need to go with Sanjays Answers...

Also include sysprocesses.

This should solve your issue:

https://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3455278&SiteID=1

Just enable IIS Service(if installed) and it will be good to go.

Else goto Control Panel-> Add Remove Programs-> Add Remove Windows component Tab on Left Side check Internet Information Services...

select * from master.dbo.sysprocesses

select * from master.sys.sysprocesses

select * from sys.dm_exec_sessions

I am not sure if you applicaiton will show up in the Program_name column.

Try Filter by username,hostname,dbid etc.

This is Just a Floop Code, might need some corrections.. But check to see if this is what you need.

Declare @size1 int

Declare @size2 int

set @size2 = 100

Declare @name1 sysname

Declare db_cur...

Check the SQL Server 2005 Default TRACE File... it might show you something... if you know the time... of Happenings.

Can you post the results of DBCC CHECKDB (database name) WITH ALL_ERRORMSGS

Which Database has Status= Recovery Pending?

is it the system Database or the User Database.

This issues relates to a Database not Shut Down properly or a transaction Log active and uncommitted...

Have you run the Upgrade Advisor against your packages?

A worked around is by saving the packing to a file with a new name.

Also Check for Package Name with SPecial...