![]() Here is the Microsoft post about this behavior: Turns out the tables were now created under his domain username. ![]() ![]() I had this problem happen to me when I reduced a user' security level, and one of the procedure he was executing was dropping and recreating tables without a schema, so the rest of the procedure was crashing because it couldn't access the object again. (it was fixed in SQL Server 2012 I think). In SQL Server 2008, when logged in under a Windows account, if you don't have SYSADMIN security level, when you create an object without explicitly specifying the schema, it may/will create it under the. When I execute the following SQL statement: execute dbo.testtable_pricesmaller 50 I find it very strange when I receive the following error: Could not find the stored procedure 'dbo.testtable_pricesmaller'. (It is listed in the following tree structure of the Object Explorer) Databases ![]() Select * from testtable where price = are able to view the Stored Procedures on the Object Explorer of the Microsoft SQL Server Management Studio. I created a stored procedure testtable_pricesmaller as follows use testbase Which I used the Microsoft SQL Server 2008 Management Studio. I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |