Hi

The error message shows that there was a deadlock and transaction id (spid) 59 was killed by sql server to resolve the deadlock.

You need to traceout where/why the deadlock...

You can integrate VSS to SQL Server (SSMS). Thats how i do it.

Welcome 🙂

You need sql 2008 client tools to connect to ur db server from another m/c. Client tools can be installed from your sql server installation CD.

Hi

Do you mean to say that user requests are stored in the 3rd table? If so What sort of info is stored in the table.

What do you mean by the...

Your question is not clear. Pls give more details.

check the sys.foreign_keys table.

update mandiflex.dbo.TABATOPCO set U_NCONSUMO = 1

FROM mandiflex.dbo.tabat.st_tabatphc,mandiflex.dbo.tabat.cod_art,prodiflex.dbo.st.ref from

mandiflex.dbo.tabat inner join ,prodiflex.dbo.st on mandiflex.dbo.tabat.cod_art=prodiflex.dbo.st.prodiflex.dbo.st.ref and S.prodiflex.dbo.st.familia='MP208'

One common method is to move the data into another table (same structure as emp table)and drop the original emp table and rename the new table.

Create table NewEmp.....

SELECT DISTINCT EmpID,Empname...

Yes.. you are right.

Hi

I dont think you can view the procedure contents of an encrypted procedure. Do you have the proc saved as SQL file?

Yes, use a column with default GETDATE() to group the records according to datetime.

BTW why do you need this data on a hourly basis.

U can check the activity monitory in SSMS. Other than that you have DMV's like SYS.DM_EXEC_SESSIONS, SYS.DM_EXEC_REQUESTS to see what is being executed inside SQL .

sysdepends is not always accurate. check out this topic.

http://www.sqlservercentral.com/Forums/Topic571247-338-1.aspx. Although this relates to SQL 2005 it applies to SQL 2000 as well.

Congratulations!! Probably the best SQL Server site. Lot of members have made some very very good contributons (thru articles, forum questions...) to make this a great site. Steve deserves...