Viewing 15 posts - 3,391 through 3,405 (of 7,496 total)
-did you execute the sproc via SSMS or via another app ?
What were the connection isolation level settings?
October 19, 2009 at 12:26 pm
Strange indeed if that user is the actual db owner!
Did you doublecheck the default schema ?
I would try the primitive way and script the full database (with all users and...
October 19, 2009 at 12:02 pm
maybe this ref will shed a good light on the issue.......
October 18, 2009 at 12:46 pm
Oh yes... Distributed transactions ...
If the app is killed (client side), msdtc can get stuck and sqlserver will need a non-standard way to get rid of the pending lock(s).
the...
October 18, 2009 at 6:56 am
bitbucket showed you the way to extract parts from a date/datetime datatyped column.
In all other cases I advise to your convert to put date/datetime datatyped columns is a certain way.
Convert...
October 18, 2009 at 2:05 am
Apparently there is a little bug in this create statement !!
It works if you first specify the start date and then the expire date !
CREATE CERTIFICATE DavesCertificate
WITH SUBJECT =...
October 14, 2009 at 8:06 am
BOL sql2005 topic "sys.server_principals" states:
modify_date datetime Time at which the principal definition was last modified.
With all my sql2005(sp3) instances, it contains the actual modification date of the...
October 12, 2009 at 2:24 am
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !
And the user may have that schema name as default schema,...
October 12, 2009 at 1:04 am
Thank you for the feedback.
That kind of mishaps happen to all of us every once in a while 😉
October 12, 2009 at 1:02 am
Once again, thank you Dale.
Your advise and refs contained the solution to fix the issue that occured on some of our x64 systems.
October 12, 2009 at 12:58 am
Some nasty little virus kept me in bed the last days of last week. :sick:
If you read my script, you'll see a section of the where clause where I added...
October 12, 2009 at 12:26 am
Just to add to Lynns reply :
Start with reading these eluminating articles:
- http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/
- http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
- http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/
- http://www.sqlservercentral.com/articles/Advanced+Querying/fourrulesfornulls/1915/
You have to understand NULL means "unkonwn" !
You are inserting an empty string so we...
October 7, 2009 at 12:09 pm
Is wham_bam a windows group by any chance !
You need a windows user account to be job owner.
October 7, 2009 at 11:54 am
It's a petty you didn't post the full sproc.
- Are you reusing cursor names ??
- what happens in sproc EMR.HPSITE.CAREGIVER_SaveLocation ?
Is it also using a cursor ?
...
October 7, 2009 at 11:49 am
Viewing 15 posts - 3,391 through 3,405 (of 7,496 total)