Viewing 15 posts - 616 through 630 (of 3,221 total)
Seems like a lot of people are learning something new.
Incorrect answers: 70% (234)
Total attempts: 332
February 22, 2012 at 6:41 am
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...
February 22, 2012 at 6:35 am
Try reading this to see if helps.
http://msdn.microsoft.com/en-us/library/ms345524(v=sql.100).aspx
February 21, 2012 at 6:22 pm
Here is another link to read before you decide
February 21, 2012 at 4:54 pm
GilaMonster (2/21/2012)
syscomments is deprecated, should not be used, only for backward compat with SQL 2000, use sys.sql_modules instead.
Gail thanks for pointing that out.
February 21, 2012 at 3:46 pm
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.
February 21, 2012 at 3:33 pm
Try reading this:
http://www.mssqltips.com/sqlservertip/1150/what-is-in-your-sql-server-backup-files/
February 21, 2012 at 12:34 pm
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...
February 21, 2012 at 12:14 pm
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) +...
February 20, 2012 at 9:13 pm
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...
February 20, 2012 at 8:08 pm
David Stokes (2/20/2012)
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...
February 20, 2012 at 4:45 pm
EL Jerry (2/20/2012)
Looks to...
February 20, 2012 at 8:12 am
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...
February 19, 2012 at 4:35 pm
Steve Jones - SSC Editor (2/19/2012)
February 19, 2012 at 3:59 pm
Viewing 15 posts - 616 through 630 (of 3,221 total)