Viewing 15 posts - 151 through 165 (of 220 total)
bugg (3/14/2013)
ScottPletcher (3/14/2013)
It's almost certainly applying the default value that is...
March 14, 2013 at 2:00 pm
ScottPletcher (3/14/2013)
It's almost certainly applying the default value that is taking...
March 14, 2013 at 1:58 pm
opc.three (3/14/2013)
bugg (3/14/2013)
GilaMonster (3/14/2013)
bugg (3/14/2013)
That is why I was looking into creating a new table with the addtional column then moving the data etc and finally doing a table rename
You...
March 14, 2013 at 1:52 pm
GilaMonster (3/14/2013)
bugg (3/14/2013)
That is why I was looking into creating a new table with the addtional column then moving the data etc and finally doing a table rename
You can do...
March 14, 2013 at 9:11 am
GilaMonster (3/14/2013)
Yes.
ALTER TABLE <table name> ADD <column name> BIT NOT NULL DEFAULT 0;
I'm probably not being very clear, apologies, above is the way i'm currently doing it, but for a...
March 14, 2013 at 8:49 am
I know it will, I was just giving an alternative approach.
March 13, 2013 at 7:54 am
Sean Lange (3/12/2013)
bugg (3/11/2013)
If you do just...
March 13, 2013 at 2:33 am
This is the info captured from redgates SQL Monitor. Both these jobs are done using maintenance plans with one step to do the backup, no custom scripts here.
Process ID:84
Database:XXXX
Host:XXXX
User:xxxxx
Start time:4:00...
March 12, 2013 at 5:27 am
Nothing else is running. Its just a standard log backup and diff backup.
March 12, 2013 at 4:10 am
Without using a tally table and using a loop. However not sure why want to show Dates from Jan 2012 when there is no data?
If you do just change the...
March 11, 2013 at 4:54 pm
Okay i'm with you guys, was just a thought.
February 6, 2013 at 9:21 am
Steve Jones - SSC Editor (2/5/2013)
February 6, 2013 at 8:05 am
Leo.Miller (2/4/2013)
If the readable replica is 100% only reporting I'd consider using Standard and per-server/CAL licenses with custom built Replication rather than AO. Benifits are: You only replicate the data...
February 5, 2013 at 2:34 am
anthony.green (2/4/2013)
Out of interest what have the re-sellers quoted you for and how much roughly?
Okay I've just spoken with Microsoft directly in the UK and they don't give any license...
February 4, 2013 at 9:10 am
Viewing 15 posts - 151 through 165 (of 220 total)