check this.

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

found nice webcast on creating linked server on ssc.

http://www.sqlservercentral.com/articles/Video/66413/

This may help you.

Declare @x varchar(100)

SELECT...

Have look on this article.

http://www.sqlmag.com/article/product-review/sql-server-backup-compression-shootout

This will resolve after Setting database option "TRUSTWORTHY" on

ALTER DATABASE <database_name> SET TRUSTWORTHY ON

no need to move system databases. is there any specific requirement? you can script out the logins , permissions and Sql jobs and deploy it to your new partition.

Please check...

Simha24 (1/25/2012)

---

--where as i am inserting very huge amount of data (40to50lacks records).

what type necessary things i need to taken care to resolve this issue.

-- My developer are not build...

good one.

you need to change DTC configuration setting. please check this link for more details.

http://sqlservermemories.blogspot.com/

Here are some queries to get memory usage details.

SELECT cntr_value/1024 as 'Memory used in mb'

from master.dbo.sysperfinfo

where object_name = 'SQLServer:Memory Manager' and

counter_name = 'Total Server Memory (KB)'

DBCC memorystatus() --this gives overall...

nice blog on this topic.

http://sqlblog.com/blogs/linchi_shea/archive/2008/03/03/is-the-8kb-page-obsolete-or-aging.aspx

its really a nice article. I will update this thing in our contingency check-list document.

welcome 🙂

Check this post.

http://serverfault.com/questions/57773/is-using-the-3gb-statup-switch-in-windows-2008-x86-only-running-sql-server-2008

Welcome 🙂