Tag Info

Hot answers tagged

2

Once you realize that SSMS is using SMO (Server Management Objects) to do the scripting, and that you can use SMO yourself directly through something like powershell, this sort of thing gets easy. For instance, here's scripting out all the jobs on your server (written in powershell): pushd; import-module sqlps -disablenamechecking; popd; $s = new-object ...


2

The block size should be 64kb for MSSql Server, for optimal performance, as described by an easy Google search. In regards to drives, RAID 10 requires an absolute minimum of 4 drives (look at the image you linked yourself) and then you can expand to your hearts content in pairs of 2 (again look at the image you linked). But remember that once the system is ...


1

Login failed for user 'DOMAIN\WEBAPPS-PROD$'.[Client: IP_ADDRESS] This is the computer object attempting to authenticate. This tells me that there is something running as a non-domain account attempting to access SQL Server. Since it's a web server, most likely it's an webapp running in a pool using windows authentication and not properly setup with a ...


1

The script is loosely based on this one in the accepted answer. It has been updated for SQL 2014, with exception handling, atomic transactions, and a few other improvements. -- Script for SQL 2014 DECLARE @JobID UNIQUEIDENTIFIER declare @servername sysname set @servername = @@SERVERNAME SELECT @JobID = job_id FROM msdb_old.dbo.sysjobs WHERE name='My ...


1

do the following it will make your work easy: open SQL Server as SA account click on create new query and past blow queries and click on execute! done. alter authorization on schema::[db_datareader] to [dbo] alter authorization on schema::[db_datareader] to [db_datareader] alter authorization on schema::[db_datawriter] to [dbo] alter authorization on ...


1

Run "SQL Server Configuration Manager" Select "SQL Server Services" Right Click "SQL Server Agent" and choose properties On the "log on " tab ,choose "this account". Click "Browse" button , then Click "Advanced" button. Click "find now" button . Now find your account in the below table and select it. When you selected proper account (With sufficient ...



Only top voted, non community-wiki answers of a minimum length are eligible