Viewing 15 posts - 3,826 through 3,840 (of 9,244 total)
Right click the table and select "Script table as" > "Create to" > "New query editor window".
Do you see the default constraint script there?
Please post results of the following query
SELECTdc.nameAS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:05 am
are you referring to database mirroring?
You cannot mirror system databases. If you have installed a failover clustered instance of sql server, the system databases will be on shared drives that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 4:33 am
when you mention filetables are you referring to filestream objects?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2013 at 5:48 am
EdVassie (12/30/2013)
It is too easy with a manual install to forget to select a given option...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2013 at 5:41 am
SELECT DATEADD(day, -1, b.MYDATE), DeliveryDate from MYTABLE b
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2013 at 3:53 am
thierry.vandurme (12/30/2013)
Hi Perry,the difference between installing an extra SQL 2008 R2 instance (about 1h) or an extra SQL 2012 instance (about 4h) is out of proportion though.
Chrz
Thierry
are downloading any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2013 at 1:32 am
smtzac (12/23/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:42 pm
niver (12/26/2013)
Do i need to Add the SYSTEM Databases the .mdf of ( Master, msdb, temp etc) to the Storage? please help me thank you masters
You can move all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:40 pm
Elliott Whitlow (12/12/2013)
The full backups should not affect the log shipped databases.CEWII
Directly, no. Indirectly for the reason listed below
george sibbald (12/23/2013)
smtzac (12/23/2013)
how about diff. backups? will this break LSN?No
It will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:37 pm
ron.grout (12/18/2013)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:34 pm
thierry.vandurme (10/24/2013)
Installation takes over 4h! GUI wait...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:22 pm
rcox 88687 (12/23/2013)
Is it possible to have two pairs of FCI's within the same Availability Group? The first FCI is the primary and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2013 at 1:20 pm
maurizio_salviato (12/23/2013)
Hello,Can I receive a copy of the VMWare Server\SQL Server 2008 install?
Best regards
here you go
http://www.stokecs.co.uk/techdocs/Creating_a_2_node_SQL_Server_2008_Cluster_Configuration.pdf
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 23, 2013 at 8:05 am
Andrew G (12/16/2013)
As I understand it, Always On Availability groups required SQL2012 enterprise edition, 'Always On' Failover Clustering is supported in SQL2012 standard edition.
Sorry, yes my bad.
Failover cluster instances support...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2013 at 12:09 am
Sagar Akhare (12/16/2013)
I want to disable the log shipping in SQL Server 2005, but in my case secondary server is no more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2013 at 7:22 am
Viewing 15 posts - 3,826 through 3,840 (of 9,244 total)