the expression isnt complete, its missing 2 closing brackets

this is just my personal preference but i like to format brackets like this so I can see how many (...

if its just a page then its controlled locally and GP will not override any settings that you add in manually unless the folders in the tree are locked like...

sorry i ment at the root level

the last screen before the import runs is a screen which says, run immediatly or save package as, you simply save the package, and then create an agent job to...

a few ways then, take a look at the import export data wizard which will create you an SSIS package which you can schedule, also take a look at creating...

is the txt file going to be the same structure everytime it is imported or is it going to change?

if you have not already, please install books online from the SQL installation media, it will help you in the long run and will give you the same information we...

as an add on to this, yesterdays headline was about adding a monitor to an existing LS plan, so you could add one now without waiting for the failover

http://www.sqlservercentral.com/articles/Log+Shipping/77295/

in secpol, when you look at the log on as a service section, what is the icon showing at the begining? is it a page with 10010 or is...

backups and databases on the same drive?

got other processes which are running around the same time which could cause file growth and shrinking? Index rebuild for example or if tempdb...

we decided against scom as it didn't monitor everything we wanted from SQL

is there a reason it needs to be in scom? Could you nit create a custom stored...

depends on the throughput of the server and how fast it can write to the disks. As to how long it takes. You could look at 3rd party tools...

can you do everything you can do in SSMS in the TeraData app?

stuff like creat logins/alerts/jobs/linked servers/policy based management as well as everything else that you can do in SSMS?...

has SQL agent been restarted after it was configured to use the mail profile in the SQL agent alert settings?

looks like the account has been removed from logon as a service,

run secpol.msc on the server and add in the accounts for the engine and agent to the logon...