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...

Thanx Mohan, I know, BUT - I need that list generated to be importable as a registered server list.

I dont want to build a manual registered server list.

Are you using SQL authentication?

then enable the password policy for that account,(but remove the tick from "user must change password..... and password expiration....")

and also see if its locked under status.