We recently implemented a new SQL Server 7.0.
I am developing an interface using VB6. Prior to the new server implementation, we had a test server. On the test server, I created stored procedures and was able to execute them from my VB interface (I used a data environment for a connection). I was the dbo of this database and therefore “dbo” was listed as “Owner” of the stored procedures created.
We are using NT Authentication
On the new server, the Network administrator created an NT group called PM_DBO and assigned me to that group. Now when I create a stored proc, the “Owner” is Domain\MyNTusername. I can execute the stored proc within the SQL Enterprise manager, but when I attempt to create a command oject/execute the stored proc from VB, I get an access or syntax error.
My guess is that there should not be an NT group created for PM_DBO and that my login alone should be given rights as DBO of the database. If this is so, if the dbo needs to change in the future, can my login be dropped and another person added as dbo?