Viewing 15 posts - 1,576 through 1,590 (of 6,395 total)
Excellent thanks John, greatly appreciated as always.
February 21, 2017 at 9:15 am
Yeah its the series group that causes the issue.
February 16, 2017 at 7:25 am
Does your target get its DB's from multiple sources?
If so do any of the sources share the same SQL Login names?
If not and its a 1...
February 2, 2017 at 8:56 am
Could just keep it simple and do
CD C:\MyScripts\
COPY *.sql > BigScript.sql
February 2, 2017 at 1:57 am
Good script, I would however change sp_change_users_login to ALTER LOGIN instead as the former is marked for depreciation in a later release of the product, just to ensure continued support...
January 26, 2017 at 2:05 am
Sorry the reply email went into my Junk folder.
The step is just a simple execute an exe from a network location \\Server\Share\app.exe, running this via CMD as the domain...
February 22, 2016 at 2:08 am
No, doing a full backup will not affect the LSN chain so LogShipping will continue to function as needed.
December 23, 2015 at 7:04 am
GilaMonster (12/23/2015)
anthony.green (12/23/2015)
The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx
Which is an Enterprise edition feature.
With Standard edition, you'll need a 3rd party backup...
December 23, 2015 at 2:04 am
whereisSQL? (12/22/2015)
Ed Wagner (12/22/2015)
djj (12/22/2015)
Ed Wagner (12/22/2015)
djj (12/22/2015)
Ed Wagner (12/22/2015)
Revenant (12/22/2015)
DonlSimpson (12/22/2015)
Ed Wagner (12/22/2015)
Grumpy DBA (12/22/2015)
Ed Wagner (12/22/2015)
anthony.green (12/22/2015)
Ed Wagner (12/21/2015)
CardinalityStatistics
Probability
Predictability
Anomaly
Teratology
Creature
Wild
Girls
Daughter
Mother
Grandmother
Stories
Bedtime
December 23, 2015 at 1:33 am
Backup encryption without TDE is a 2014 or above feature. https://msdn.microsoft.com/en-us/library/dn449489(v=sql.120).aspx
The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx
December 23, 2015 at 1:30 am
Ed Wagner (12/21/2015)
whereisSQL? (12/21/2015)
Revenant (12/21/2015)
eccentricDBA (12/21/2015)
djj (12/21/2015)
Ed Wagner (12/21/2015)
DonlSimpson (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
Eirikur Eiriksson (12/21/2015)
djj (12/21/2015)
anthony.green (12/21/2015)
Ed Wagner (12/21/2015)
Grumpy DBA (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
whereisSQL? (12/20/2015)
AwesomeEverything
Something
Nothing
NULL
Unknown
Knowledge
Useless
Chocolate Fireguard
Melt
Felt
Craft
Project
Phoenix
Arizona
Cardinals
Cardinality
Statistics
December 22, 2015 at 3:19 am
Will be exactly how you call the CONCAT function and how you have already discribed it
CREATE FUNCTION dbo.my_func (@string1 varchar(10), @string2 varchar(10),............, @stringn varchar(10)
...
...
...
dbo.my_func ('string1','string2',.....,'stringn')
December 21, 2015 at 6:22 am
Eirikur Eiriksson (12/21/2015)
djj (12/21/2015)
anthony.green (12/21/2015)
Ed Wagner (12/21/2015)
Grumpy DBA (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
whereisSQL? (12/20/2015)
AwesomeEverything
Something
Nothing
NULL
Unknown
Knowledge
Useless
Chocolate Fireguard
December 21, 2015 at 5:51 am
Ed Wagner (12/21/2015)
Grumpy DBA (12/21/2015)
Ed Wagner (12/21/2015)
anthony.green (12/21/2015)
whereisSQL? (12/20/2015)
AwesomeEverything
Something
Nothing
NULL
Unknown
December 21, 2015 at 5:30 am
Viewing 15 posts - 1,576 through 1,590 (of 6,395 total)