Impact of the Recovery Model on Backup and Restore :-

http://msdn.microsoft.com/en-us/library/ms191239.aspx

There are sevral sites who hires the codders.. like Freelancer ,Codeguru

check below link to Find Table Usage

http://www.sqlservercentral.com/scripts/Miscellaneous/31553/

watch this series.

http://learningsqlserver.wordpress.com/2011/01/31/sql-server-2005-express-for-beginners-video-series/

is "c2 Audit mode" enabled on your server?? if yes then you can find it in trace files... else try to find it out in sql error log.

Below query will give Job Frequency type.

SELECT

[sJOB].[job_id] AS [JobID]

, [sJOB].[name] AS [JobName]

, [sDBP].[name] AS [JobOwner]

...

This may help you to find your answer.

http://www.sqlmag.com/blog/sql-server-questions-answered-28/sql-server/determining-how-long-it-takes-for-dbcc-checkdb-to-run-137119

Nice blog to read.

http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376

Nice Demo of suspect DB

http://sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

check this blog.

http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

Answer-

DBCC opentran()

this article may help you.

http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

Carlos russo (2/21/2012)

---

I have succesfully linked my SQL server 2008 with an Oracle 10g server.

But when i run a simple query like:

select top 5 * from LINKEDSERVER..SCHEMA.TABLE

the result grid flashes...

you create logshipping in same server but secondry database has to be different name.

you will definitely get the answer from this blog.

http://www.sql-server-performance.com/2007/temp-tables-vs-variables/