restore master db with different name masterfromold .. run sp_hexalogin scripts ..it will generate all login script and then just execute that script on new server.

i know these option. I want default setting like this so every time when create a new job .. those settings are there.

try to use output t-sql

the application working for 1-2 years and now they don't want to change sp or tested code.

sometimes users directly inserts records in the table. check constraints not an option as...

goto drives properties and make it share and grant full access to all users. then check...

you can go with sql clustering + san clustering..

I would suggest check Disk IO ,Identify long running sp or queries and create indexes\stats for it, also make max dop equal to number of cpu core.

I would suggest peer to peer replication.

change in the string - additional comma after last number.

I need last value from string.

Declare @sss varchar(100)

Set @sss ='12,11,23,34,567,690,4,1,'

or

--- Set @sss ='45,56,89,212,121,33,14,7,101,4,22,'

or

--- Set @sss ='334,234,217,1,4,333,'

I want if last run of job failed then that date and time and same job when previously failed.

Queries

Update

SET firstname = 'XYZ' ,

lastname = 'ABC' ,

finishdate = GETDATE() ,

location = 10 ,

dept = ' PRODUCTION',

active =1

WHERE machine = 'ABCSSSS'

AND startdate < GETDATE()

Thanks for your reply

However for test i have given ID in serial number

Let us say I have data like this then wht will the query?

ID Machine ...

If it sql 2005 then you can try to use table partition.

By ur approach , I think create index on individual tables and then create view

In view use Union ALL

SELECT...

I would suggest drop the indexes and re-create again.

I ran usage query and found that IX1 total uses is 26

while others are used for 1200+

However since tuning wizard recommanded to create

IX5 - on col1,col2,col6

and we have IX1 -...