Autogrow is realtime, but specify it to grow by MB and not %, and use realistic values - which only you will know after determining the growth over a week...

Set up notifications and alert?

never shrink it to a size that's less than the current size.

Read up on shrinking here for more info:

http://msdn.microsoft.com/en-us/library/aa174524%28SQL.80%29.aspx

CASE 'January' when 1 etc?

5 Years is intermediate, and there are still loads to experience from SQL Server, contribute and develop.

Next on your agenda I would say is to go for MVP status.

Because the sql user account needs to be created on sql server level as well, not only db level.

drop the account from the DB, recreate it on sql server level,...

sp_helpdb master or the database name

what type of account are you using to start the service?

This should point you in the right direction...

http://msdn.microsoft.com/en-us/library/ms190737.aspx

You can run 2, to separate folders, one for backup purposes, and one for shipping to a remote instance.

BUT: when you need to do a restore, you'll need to use...

Hi Steve, I think "abandoning" VBS and PWS might be a bit harsh.

Moving on to new technologies is a definite yes, but still using your "legacy" knowledge is never...

You could use the same backup, although log shipping configuration deletes old logs after a set amount of time/days, just use caution.

something like this?

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',

'SELECT GroupName, Name, DepartmentID

FROM AdventureWorks.HumanResources.Department

ORDER BY GroupName, Name')...

try:

USE yourdatabasename

exec stp_yourspname

sounds like you are not focused on the correct DB where the proc was created.

you said it 😀

Are you trying to write multiple mark's into a single column, but not overwrite, just append next to each other?

or

Are you trying to write multiple rows for each student for...