Hmm, link just tested fine.  You are right though, it won't have tabular settings, but it does have good guidance for collocating SQL with SSAS and some of the memory...

Event log settings are part of the server's group policy settings, its possible those are not configured for the quantity of audit logs you are sending.  I don't have a...

Maintenance plans are SSIS packages.  I have seen SSMS generate this error when SQL Server and SSMS are not comparable versions.  For instance, the current version 18.11 of SSMS will...

SSAS memory settings are the culprit here.  In Enterprise edition, the memory limit for SSAS is the server max, so it is very probable that SSAS is competing against SQL...

• This reply was modified 2 years, 5 months ago by  WHug.

As a hunch, the session created by xp_cmdshell is not persistent.  If you want to use mapped drives, create those directly in Windows.  Instead of mapping a drive, try using...

Brandie,

Would you post some of your scripting so we can get a better sense of how you are going about it?  Also, in case it solves the problem, you can...

SQL Server Management Studio has a wizard for scripting out replication.  While this reply doesn't satisfy your requests for a tsql method, if you are in a hurry try the...

To get this question unstuck, please clarify "local user" as that is not a technical name for a user in SQL.

Database users can be created without a login, for a...

Presuming the AWS RDS chosen engine is SQL Server, foreign keys do not work between databases.  To satisfy the stated requirement the foreign keys will need to be replaced with...

This is an old post but I had the code handy so I figured why not reply, some future DBA may find it useful.

"sp_spacedused" has a parameter to consolidate the...

xp_subdirs is an undocumented procedure, so direct use of it is unsupported.  If I review xp_cmdshell documentation I see this note that probably applies to xp_subdirs:

"The Windows process spawned by...

Andy, do you have a reference link for "Also, the encryption process does not encrypt existing data in the log file, so it's a good idea to flush the log...

Anchor Modeling addresses some of these issue with a non-destructive development approach based on agile principals. It's worth a look just to wrap your head around the approach and...

I don't think that gets you the patch level

Update:

We are reinstalling the SQL instance. I did have a go at creating the SQL Agent service manually using SC.EXE, even got it to appear in SQL Configuration Manager(!)...