I followed this link[/url] on a SQL 2000 server that had the same issue. It holds true to SQL 2005 as well.

sysdbmaintplans should be the table you are looking...

Check this site.[/url] Then buy the book. It will give you a good headstart.

You are going to have to obtain some experience before jumping into an dedicated DBA position. ...

SELECT 'ALTER LOGIN [' + name + '] WITH PASSWORD=N''password''

, CHECK_POLICY = ON

, CHECK_EXPIRATION = ON''

Change the first line to this.

The files under the BINN directory in the SQL Server program files directory. It is the SQL "OS" files, that SQL Server function with.

pshaship (8/21/2010)

---

Thanks,

My only concern in keep SQL binaries on D drive( local). Previously we...

ALTER LOGIN [login_name] WITH PASSWORD = 'password'

GO

You could probably loop through the sys.logins table if you wanted too as a quick fix.

Actually thinking about it use an excel spreadsheet. ...

Searching this site you will probably find a few.

MSSQLTips.com has tons of them down to translating the INIT data columns into what they actually mean.

It is common for people to do this, but the binaries are not...

Glad I could help.

I was tyring to remember where I came across this procedure...I know the issue I had was in SQL 2000 one of the procedures for I think...

If your query to modify an original stored procedure errored out then the process did not complete, therefore it did not modify anything.

What error did you receive?

I've done this with stored procedures so I don't know if it will work with a table, but expect it would.

Once you create the object you mark it as a...

Wonderful resources that is constently growing:

Technet Script Center

You might need to check to ensure you have patched your SSMS toolset:

http://stackoverflow.com/questions/52103/can-i-use-sql-server-management-studio-2005-for-2008-db

osql -E -S CMSBLACKBERRY\BLACKBERRY -i\ c:\bbup.sql

Your syntax looks to be off.

I believe it should look like this (unless above is typo)

osql -E -S CMSBLACKBERRY\BLACKBERRY -i c:\bbup.sql

Yes, I have this book on my...