issue with dbcc inputbuffer

lets say a process is locking another process because an update was not commited.
dbcc inputbuffer will not show you the offending code if the process has moved on to other code after the uncommited update.

Dirty reads in SQL Server

it's important to understand that sql server reads the new uncommited value - not the original value like in Oracle.

sysobjects

sysobjects does not contain info about temp tables

 

object_name function

object_name has a problem - it takes an int as an argument and some objects in sql server are larger (how's that?)

I do a join instead

regarder:

select  request_session_id,

resource_database_id,

resource_associated_entity_id,

--object_name(resource_associated_entity_id),

o.name,

request_mode,

request_status

from sys.dm_tran_locks l left join sys.objects o

on l.resource_associated_entity_id = o.object_id

Retrieving Resources

I uploaded a xsl file to a c# project - how to reference ended up being easy:

project.Properties.Resources.fileNameNoSuffix

This also worked:

public static string GetStringFromResources(string resourceName)
{
ResourceManager rm = new ResourceManager("project.Properties.Resources",
Assembly.GetExecutingAssembly());
return rm.GetString(resourceName);

This didnt
public static Stream GetStreamFromResources(string resourceName)
{
return Assembly.GetExecutingAssembly().GetManifestResourceStream(resourceName);

and Assembly.GetExecutingAssembly().GetManifestResourceNames ()
did not show the included file

 

designing:Interface Vs Abstract Class

Microsoft weighs in

CuteFTP on SSIS

I think I will have to make peace with the fact that I wont get CUTEFTP to run on sql server
(it runs fine in development)
I changed the rights on dcom , I created a new proxy with my credentials, all to no avail.
Anyway, the agent service is to my account .

this is where I need a knowledgeable networking dude.