Viewing 15 posts - 14,836 through 14,850 (of 19,564 total)
Though you can set model to READ_ONLY. However, when you create a new database with READ-ONLY set on the Model DB - the setting does not propagate to the...
April 15, 2010 at 10:25 am
jcrawf02 (4/15/2010)
croberts 36762 (4/15/2010)
As already noted, the model database can be set to read-only. Before posting a question, how about actually trying it out?
lol and if it didn't work, you'd...
April 15, 2010 at 10:09 am
crookj (4/15/2010)
tosscrosby (4/15/2010)
SadisticPolitician and IRS!
Joe
Liars and Cheats?
April 15, 2010 at 10:04 am
P Jones (4/15/2010)
I keep up by looking at the active postings in the daily newsletter. And keeping a post-it note of which page I'm up to in The Thread:-D
Dedicated Threadizen.
April 15, 2010 at 8:40 am
Steve Jones - Editor (4/15/2010)
Happy Tax Day, and behave children. I'm going skiing, so no one will be here to moderate bad jokes and subtract points.
Which mtn / slope /...
April 15, 2010 at 8:39 am
Steve-3_5_7_9 (4/15/2010)
This book has a pretty decent section on disk configuration.SQL Server 2005 Performance Tuning
WROX
ISBN: 978-0-470-17639-9
Nice suggestion. I will have to check into that one too.
April 15, 2010 at 8:37 am
Tom Brown (4/15/2010)
Anyone having difficulty posting/previewing with IFCodeI'm getting in IE 'cannot display webpage'
and Firefox 'the Connection was reset'
I can post without IFCode fine
Haven't seen that issue.
April 15, 2010 at 8:37 am
Tom.Thomson (4/15/2010)
CirquedeSQLeil (4/15/2010)
PlyometricsMyostatic
Ballistic
April 15, 2010 at 8:36 am
Mister Ken (4/14/2010)
I've seen that "(select blah bah)" within the field list before, but never really used it. Now I know the power of...
April 14, 2010 at 8:10 pm
That makes plenty of sense.
Thanks for posting back.
CTEs cannot be used (as Lutz said) prior to SQL 2005 (new feature).
April 14, 2010 at 5:25 pm
In addition to the version, try executing the commands in separate batches (or eliminate the use db statement altogether).
April 14, 2010 at 5:18 pm
In your use cu_hds statement, follow it up with a GO
Then you can add the semi-colon, then run your CTE.
April 14, 2010 at 4:48 pm
Viewing 15 posts - 14,836 through 14,850 (of 19,564 total)