Sue_H

Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 4,477 total)

RE: Replication Snapshot scheduling

Admingod - Wednesday, September 12, 2018 4:58 PM
How often is the good practice for replication snapshot schedule in sql server transactional replication?...

September 12, 2018 at 6:18 pm

#2005532
RE: XML Workshop 26 – SELECT * FROM XML

Pagan DBA - Wednesday, September 12, 2018 2:52 PM
Sue_H - Wednesday, September 12, 2018 2:38 PM

September 12, 2018 at 2:58 pm

#2005514
RE: Details of Trace Flags

Eswin - Wednesday, September 12, 2018 1:03 AM
These flags were enabled after the install of security patch KB4293807.
Microsoft is not publicly stating what...

September 12, 2018 at 2:53 pm

#2005512
RE: update to SQL 2016 with log shipping

cphite - Wednesday, September 12, 2018 1:44 PM
We're on 2012 now so no risk of ever going back to 2008R2... 😀
When...

September 12, 2018 at 2:48 pm

#2005510
RE: XML Workshop 26 – SELECT * FROM XML

Pagan DBA - Wednesday, September 12, 2018 1:54 PM
I need the XMLTable function desperately. I tried downloading it from the link provided...

September 12, 2018 at 2:38 pm

#2005507
RE: Hide schema from all users (except people with SA access)

richardmgreen1 - Wednesday, September 12, 2018 7:38 AM
Hi Sue
Thanks for that, it's a handy bit of code.
I've just run it and got...

September 12, 2018 at 7:49 am

#2005417
RE: Hide schema from all users (except people with SA access)

richardmgreen1 - Wednesday, September 12, 2018 2:32 AM
Thanks Sue
I've just run SELECT has_perms_by_name(null, null, 'alter any linked server') for the relevant user...

September 12, 2018 at 7:10 am

#2005406
RE: Unused Indexes

Arsh - Wednesday, September 12, 2018 5:34 AM
Dear Experts,
I generated a list of unused indexes from my database by equating
September 12, 2018 at 7:10 am

#2005405
RE: Last Security Patch

Arsh - Wednesday, September 12, 2018 4:38 AM
Thanks Sue . So in the list , whatever appears above the patch level...

September 12, 2018 at 6:50 am

#2005403
RE: Database Canned Reports - Matching Up Disk Usage and Disk Usage by Table

chris.o.smith - Tuesday, September 11, 2018 4:29 PM
Hi,
I am trying to provide our IT team with a rough estimate of disk space...

September 11, 2018 at 5:17 pm

#2005352
RE: Hide schema from all users (except people with SA access)

richardmgreen1 - Tuesday, September 11, 2018 2:45 AM
Hi all
I'm making progress (I think).
I've now got a domain-level user I can use for...

September 11, 2018 at 4:59 pm

#2005351
RE: SQLCMD In Single User Mode

RonMexico - Tuesday, September 11, 2018 1:55 PM
Sue - Thank you! I was able to get it to work using both NET...

September 11, 2018 at 2:31 pm

#2005335
RE: Oracle Linked Server to call procedure or function

dmbexodus - Tuesday, September 11, 2018 2:09 PM
We were just trying to figure out if I could get the data from the...

September 11, 2018 at 2:26 pm

#2005334
RE: SQLCMD In Single User Mode

RonMexico - Tuesday, September 11, 2018 12:59 PM
This is driving me crazy because I've done it a few times with no issue...

September 11, 2018 at 1:19 pm

#2005317
RE: Grant sql assistant

kakovatos7 - Tuesday, September 11, 2018 12:16 AM
I don't mean the third party product, I am talking about the embedded intelligence to...

September 11, 2018 at 12:36 pm

#2005304

Viewing 15 posts - 1,336 through 1,350 (of 4,477 total)