Seems like a lot of people are learning something new.

If only every one would read the question carefully it states

In SQL Server 2008 R2, can I set the model database to read only? Will new databases created default to...

A good question

Try reading this to see if helps.

http://msdn.microsoft.com/en-us/library/ms345524(v=sql.100).aspx

Here is another link to read before you decide

http://blogs.msdn.com/b/sqlcat/archive/2008/10/09/table-variable-vs-temp-table-and-estimated-vs-actual-query-plan.aspx

Gail thanks for pointing that out.

You could also use

SELECT text FROM sys.syscomments WHERE Text LIKE ('%dbo.sp_upgraddiagrams%')

Where '%dbo.sp_upgraddiagrams%' is your stored procedures name it return the text of the stored procedure which you can then examine.

Try reading this:

http://www.mssqltips.com/sqlservertip/1150/what-is-in-your-sql-server-backup-files/

First of all

CREATE TABLE #cmd_holiday (@col float ) --> i want like this dynamic (January float ,February Float)

-- should be

--CREATE TABLE #cmd_holiday (col float )

Second we have no idea...

If you can read in a large enough sample of text you might use the following to determine how a line is terminated.

DECLARE @NewLineChar AS CHAR(2)

SET @NewLineChar = CHAR(13) +...

If I understand you correctly, that is take separate DBs supporting different customers. Combine those into one DB, using SCHEMAs to keep each individual customer's data separate. Let...

David Stokes (2/20/2012)

---

Hey Linking90,

You may also want to consider a design change to your table. You should change the 3 columns other than User_ID to the bit data type...

EL Jerry (2/20/2012)

---

Hi!!! After thorough reading and searching I found and selected the right answers based on the same referenced article, just to find out they were wrong?

Looks to...

Hmm from the cited support link

Hash recursion and hash bailout cause reduced performance in your server. To eliminate or reduce the frequency of hash recursion and bailouts, do one...

Steve Jones - SSC Editor (2/19/2012)

---

I think we have some of the changes surfacing in the Recent Activity. We do create threads, and have wanted discussions for scripts, so this...