Granted that is a standard -- but having worked with SQL Server, Oracle, Sybase, Access/JET you learn quickly that about the only thing consistent is...
The dynamic SQL worked.Not that I didn't have other issues -- but they don't concern this in general. Have a good day all.
Would it be: EXEC ('USE mydatabase; DROP USER UserID; CREATE USER UserID FOR LOGIN UserID;') This is done on the same server as the production DB...
It is a once a month thing, but the vendor provided app needs a userid that is a db_owner and I'm sure not giving out SA. I'm trying to get a monthly...
I have an SP that backups production databases and restores it as an EOM for reporting purposes. To get it to work and be accessible I do a...
The company (department) always owns the data. (With the exception of personal information.)This is really essential to keep in mind with the amount...
Separate names with a comma.
