Viewing 15 posts - 16 through 30 (of 501 total)
January 11, 2016 at 3:12 pm
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
January 7, 2016 at 3:23 pm
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...
December 29, 2015 at 3:26 pm
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
December 21, 2015 at 2:31 pm
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...
November 19, 2015 at 2:47 pm
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...
November 19, 2015 at 2:40 pm
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...
November 6, 2015 at 2:49 pm
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.
November 4, 2015 at 1:56 pm
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.
October 22, 2015 at 2:13 pm
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...
October 21, 2015 at 4:16 pm
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.
October 16, 2015 at 2:38 pm
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]
October 14, 2015 at 2:48 pm
Welsh Corgi (10/5/2015)
JeremyE (10/2/2015)
October 5, 2015 at 3:13 pm
Have you tried sp_removedbreplication?
https://technet.microsoft.com/en-us/library/aa239336(v=sql.80).aspx
October 5, 2015 at 2:36 pm
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...
October 2, 2015 at 2:10 pm
Viewing 15 posts - 16 through 30 (of 501 total)