the link is not working, it brings up the same forum page.

i dont' thing there is a way to control cpu through stored proc and more over i would not suggest doing this. At the most you can check the...

select ServerProperty('LicenseType'), ServerProperty('NumLicenses')

works out for SQL 2000 but return

Disable and Null for SQL 2005 and higher versions.

Not sure why microsoft revoked these things.

thanks a lot . I will try this out.

enable the deadlock traces and send the information in logs. Then somebody can tell whats happening.

apart from Rateesh

it could be

some other processes are running in SQL consuming most of the mem and cpu cylcles

it could be other than sql application making the box crumble.

It...

this is such a generic that you could have done 1 hrs easy timepass with them.;-)

a whole book can be written on this.

create a batch file and then try calling it in the job

SQLCMD -S srv -U usr -P pwd -Q "BACKUP DATABASE master TO DISK = 'E:\MSSQL10.INSTANCE_02\BACKUP\SystemDB\master.bak'

WITH NOFORMAT, NOINIT,...

is your database on separate server or it host everything ?

probably SQL compare is not intelligent enough and uses char by char comparison and hence you are getting a difference b/w

CREATE VIEW [dbo].[vwCustDetails]

and

CREATE VIEW dbo.vwCustDetails

Use SSIS , its simple and you can do a lot of transformation.

If its high OLTP then you definitely will have slight performance issue.

It also depends how many errors are generated per min, if this is high then there will be i/o...

that was good information. I was not aware the the snap cannot be restored on another system.

Since this is quiet fast I guess than we can use this of DR...

check below if this is helpfull

http://www.sqlservercentral.com/articles/Administration/2605/

http://support.microsoft.com/kb/224071

any luck :crying: