Viewing 3 posts - 1 through 3 (of 3 total)
When you exec your SP use [WITH RECOMPILE] option - it forces a new plan to compiled. Old plans remains in cache and if some indexes etc changes or...
January 28, 2009 at 4:41 am
#933694
I used to have nearly similar problem. My friend coded some VBS and it worked:
While your spreadsheet is under update, it has a "deny flag" raised, VBS study if flag...
January 21, 2009 at 2:32 am
#930175
Create schema for your teset user:
CREATE SCHEMA [TESTUSER] AUTHORIZATION [TESTUSER]
and then your table in that schema:
CREATE TABLE testuser.test(name varchar(3))
June 30, 2008 at 5:57 am
#836038