https://msdn.microsoft.com/en-us/library/ms187348.aspx

If you choose not to "Enforce Password Policy", then the password can be anything including blank. I would strongly advise against this.

You can read more here: https://msdn.microsoft.com/en-us/library/aa337562.aspx#SSMSProcedure

From the error, it sounds like an issue with the publisher database's owner (missing, invalid, etc.).

Check to see if the publisher database has a valid owner by running the following:

SELECT...

Sounds like sys.dm_tran_database_transactions is what you are looking for.

https://msdn.microsoft.com/en-us/library/ms186957.aspx%5B/url%5D

Possible firewall blocking the traffic (software or hardware)? You could narrow it down to a SQL Browser issue if users cannot connect using SERVERNAME\INSTANCE but can connect using SERVERNAME,PORTNUMBER. If...

Have you tried adding the index on S_CLIENT_ACCOUNT_ASSOCIATION_SHARED that SQL suggests? The query is currently doing a clustered index scan against that 80M row table. I would start there in...

You can run the following with the results to text and it will generate the statements for you.

SELECT 'ALTER DATABASE ['+d.name+'] MODIFY FILE (NAME=N'''+mf.name+''', FILEGROWTH = 10000KB)'+CHAR(13)+'GO'

FROM sys.master_files mf

JOIN...

You could build something around sp_help_revlogin.

https://support.microsoft.com/en-us/kb/918992

It will generate the SID and password for SQL logins.

In your modified query, you are not using the #temp table to insert any data. It's being inserted into the dba.dbo.inventory_server table. You would need to select from dba.dbo.inventory_server.

create table #SVer(ID int, Name sysname, Internal_Value int, Value nvarchar(512))

insert #SVer exec master.dbo.xp_msver

select Internal_Value AS [PhysicalMemory_MB] from #SVer where Name...

Ola's scripts create sub-folders by default.

From the documentation: https://ola.hallengren.com/sql-server-backup.html

DatabaseBackup creates a directory structure with server name, instance name, database name, and backup type under the backup root directory.

Read both the blog posts below. It's everything you need to know about VLFs.

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/[/url]

http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/[/url]

Welsh Corgi (10/5/2015)

---

JeremyE (10/2/2015)

---

There are 2 options that need to be set to false for the publication in order to add an article and only snapshot that article vs the...

Have you tried sp_removedbreplication?

https://technet.microsoft.com/en-us/library/aa239336(v=sql.80).aspx

There are 2 options that need to be set to false for the publication in order to add an article and only snapshot that article vs the entire publication.

immediate_sync and...