Truly briefcase item for me.

The complex topic in such a simple way( at least for me)

Thanks Gail

Should we live our life in bulk logged or full recovery mode?:hehe:

and if anyone want to read about 2012 then Free ebook: Introducing Microsoft SQL Server 2012 (second DRAFT preview) is available here

http://blogs.msdn.com/b/microsoft_press/archive/2012/01/31/free-ebook-introducing-microsoft-sql-server-2012-second-draft-preview.aspx

Just sharing whatever I read online about 2012 features:-

1) contained database

Need to enable this at server level using sp_configure

This database as of now have option to be configured with 2...

I have read it somewhere that it will work with cluster only.

And the cluster is windows 2008 cluster which is domain independent and can be configured as global domain.

I...

without following the RDBMS concept, you can not acheive this.

You need to maintain at least one key common and unique in your sql table and excel sheet.

If its still not...

if your excel have all set of correct record then clean the table first and re-populate it with excel data every time.

else

create linked server with your source excel and then...

Modified this script a bit,

1)

to give the correct information on the sql server up time in two variable mentioned in script.

So in variable "@vOnline_Since" OR "OnlineSince" you will...

sometimes the things are quiet simple to check even without opening the query window.

Follow this :-

1) Start--run--services

2) Right click SQL Server (Instance) services and select properties

3) Go to "Log ON"...

can you paste the error you getting in replication monitor?

And

How tough it is to re-configure the replication?

how about this one

select convert(varchar(12),getdate(),106)

it gives me the result as 07 Feb 2012

does this link give you any help :-

http://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

As much I am aware, you need to re-initialise...

Yes mate, finally the cursor out of mind and scope in the query. Thanks for the code...

Here is the updated script to capture the information for all user database in the server using suggested CTE method in earlier reply (but cursor still not going out of...

Many thanks for additional codes and comments. The option to select the cursor was just easy for me to replicate and my query is not resource intensive.

I need to brush-up...