May be syntactically it works but from business perspective child table should contains any records associated or...

e1785 (12/13/2010)

---

OK. But I take it there's no way to keep it as a "disabled" constraint, as you can with FK checks? The goal is to have the same sort...

http://blog.sqlauthority.com/2009/08/03/sql-server-introduction-to-sql-server-2008-profiler-2/

daveriya (12/13/2010)

---

Hi,

Can anybody provide me the actual real time project example.

for example,in company how many databases r there,how many reports r generated per day,

and how the front end application r...

you can use sql profiler trace use "sp:stmtcompleted" event class

brindaam (12/13/2010)

---

Hi,

I have two queries, say for example

Select distinct 0 parent_id, ROW_NUMBER() OVER(

ORDER BY Column2_Desc ) AS 'ID', Column2_Desc

From table1

Union

Select distinct 0 parent_id, ROW_NUMBER() OVER(

ORDER BY Column2_Desc ) AS 'ID',...

How did you resolve ? Always post resolution so that other can get the benefits.

use sp_lock then find the spid associated with concerned DB and kill them ( but first you can check them whats running behind them by DBCC inputbuffer(spid))

Heavy DML operation/migration ?

Helpful links

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic23785.aspx

You need...

Post your complete trigger script

declare @t table ( ID int , TERM varchar(20), CLASS nvarchar(20))

insert into @t

select 304 ,20103, 'EE2'

union select 156 ,20104, 'CS3'

union select 167,20144,'MC1'

union select 167 ,20144,'SE3'

select distinct final.id,final.TERM,substring(final.results,2,len(final.results))

from...

You can simply restore...

create a user with databaseRole :SQLAgentOperatorRole