Ohhh my bad, second time, i dint think abt the primary key set on it!!!

However I could not see any difference between the foreign key and without foreign keys...

Just a later thought, how your manager would have thought of the same....you may explain to us about the context too....

I was just thinking something a tree structure...

1

1 10

1...

Is your table related with heirarchy mode of operations???

I do not aware of something at database level.

Also you can post the same in SQL server 2000 forum for a quick response as the question is on SQL server...

Is it something you are looking for?

Declare @int decimal

Set @int = 123345.524

Select ROUND(@int,0)

little crazy....

try with this...changed as dynamic...for the number considering the word SUM

declare @Find1 varchar(20)

declare @Find2 varchar(20)

declare @search varchar(50)

select @Find1='SUM', @search='nhtinhfsgjesrtyrtywqeqweqwalgjdmexSUM=192340SUMdsfsdfsdfsdsdsdf'

select @Find2='SUM='

Select SUBSTRING(@Search,

case charindex(reverse(@Find2),reverse(@search)) when 0 then 0 else len(@search) -...

Is this something you are looking for?

declare @Find1 varchar(20)

declare @Find2 varchar(20)

declare @search varchar(50)

select @Find1='SUM', @search='nSUM=123123190SUMdsfsdfsdfsdsdsdf'

select @Find2='SUM='

Select SUBSTRING(@Search,

case charindex(reverse(@Find2),reverse(@search)) when 0 then 0 else len(@search) - (...

I found adding an integer is getting changed. Is there any conversion to an int and make it unique?

Refer the below link:

http://sqlzealot.blogspot.com/2010/12/cxpacket-parallellism.html

Use DDL Trigger instead...

Please refer the following link:

http://sqlzealot.blogspot.com/search/label/System%20Functions

Server->Security->Server Roles->Sysadmin and look at the account name...

few more things, If you do not wanna complicate things,

make use of either of things:

1. Trigger on the tables

2. Use OUTPUT clause on transactions to push the table name to...

if both are in same server just use complete path. if those are in two different server, create a linked server and use the join.

Shaiju, it was a good article. However I did not get an answer. My specific question is "Can I be changed Optimize adhoc for workload" setting to true for an...