you could create an ssis package and give it a script task which will execute VB.net or C# code and then schedule the package as a job

wrap the ? in [] then test it, looks ok to me

are you talking about the SA account?

if so SQL will not allow you to continue the installation without a windows user all so being a sysadmin, if you know this...

take a look at an undocumented function called sp_msforeachdb, this will allow you to execute the same query in all databases including master model msdb and tempdb so you will...

they dont have any special ports in logshipping, they use file copy ports and whatever port SQL is running on, usually 1433 unless you have changed it or installed a...

you will need to build in a link to the system catalogs for schemas and users as they will be different in each do and then pass the values in...

Ok so you can do PIT restores.

Ok what is your backup routine? Full daily/weekly/monthly? Diffs daily/weekly/monthly TXLogs 5mins/15mins/Hourly/Daily etc

If you dont do TXLog backups then you cant do...

take a look through the url above and also backupset table and build a sp_send_dbmail query to send you the mail

you just need to grant execute on the schema in question

so if everything is in the DBO schema you would do

GRANT EXECUTE ON SCHEMA::dbo TO ixxxxxx

you could also create a...

to enable file stream, you need to first logon to the server and open up SQL Server Configuration Manager.

in the SQL Server Services section, right click the SQL Server (MSSQL.......)...

you need to have atleast one server in the scale out deployment box, so put the name of the new server back in that box.

as you did a backup and...

LowFatSpread (2/25/2012)

---

Hi There,

For the recovery model. Given that i'm no sql server guru. Recovery

page verify - checksum.

How can I back up everything logs, database from a procedure? Do you have...

best to check what that role can do and then tie it back to people who are db_denydatawriter and db_executors.

in SQL a deny is higher than a grant, but in...

what port are you trying to find out? the port which SQL is running on? you can use the SQL Server Configuration Manager to find that out, if...

you should have some alert jobs for log shipping, these will tell you in your in sync or out of sync as they will either succeed of fail, you could...