Can I ask why you want to get the admin password?  Normally, the reason for a password it to keep the wrong people from accessing the data.

Steve

Another thought would be to break the job into more than one job.  The stored proceedure that can run more than a minute could be put into it's own job...

For those of you who want to use the extended properties and think that there is no extended properties for the table in general, there is a way to enter...

Thank you.

I have added the user guest to the roles of db_denydatareader & db_denydatawriter for all appropriate databases.

Steve 

I am trying to remove guest from some of my database (including model) but get an error message.

I've tried "sp_revokedbaccess 'guest'" from query analyzer and Delete User from Enterprise...

One thing that might be helpful is to script out the database users and roles and Sql Server logins.  Then you can save it to a script file, edit it...

If amounts 2 & 3 are truly calculations based upon other calculations, could they be expressed in terms of the original amount field?

SELECT     Amount as Amount1, Amount / 10 AS...

From BOL:

If the CREATE TABLE statement is executed by a login associated with a user ID that has only create table permissions, owner must specify the user ID associated with...

Have you tried granting create table permissions to the user?  You can grant permission to create a table within a database with the statement

GRANT CREATE TABLE TO User

This also works...

I believe that there is no "normal, usual language" for connecting to databases.  Almost all web develpment should have the capability to handle it.  Do you have an environment that...

I concur with Robert that switching to bulk-logged recovery instead simple recovery may be better, but I would do a Full Backup for step 5.  If you don't, switching back...

From my understanding, the Bulk-logged model works just like a full recovery model until a bulk operation occurs, then it functions like a simple recovery model.  The only advantage I...

You didn't say if the 22 databases on different servers would exist as 22 databases on one server or would they be merged into one database on the one server. ...

The first option was exactly what I needed.  Thanks!

Steve

I'm new to replication.

I'm trying to set up a snapshot replication that will run once a day for our web page.  I am trying to set up a push subscription...