Thanks Yelena, the problem was indeed that the default dbid in sysxlogins was incorrect.What I don't understand is that the developer said he restored the test db from a backup and as far as I understand that shouldn't change sysxlogins, or?Max
2004-06-21
The SPIDS are on the database serverWe have an app server which calls a stored procedure on the database server which uses the UDF.After restarting the server all the SPIDS using the UDF go away, but over time build up again.Is there some code we need to add to the UDF to close the connection […]
2004-06-07
The SQL Server listener service does two key things.1) When a client asks for a list of SQL Servers on a given subnet, it broadcasts udp/1434 to that subnet. Any SQL Servers on the subnet which haven't been configured to hide themselves will respond back. 2) When you attempt to connect to a named instance, […]
2004-05-11
Hello, I've got a stored procedure written that will send a query to a Finger server and return information about a person. Currently, I get the person's name like this:Smith Joe R. I would like to reformat this within the sp to read:Joe R. Smith or even break the name down into three separate fields. […]
2004-04-15
Others gave you the reason why this occurs, but the way to avoid this situation would be to key off another field within the table and check against sometype of timestamp datetime field and a customer id type to see if a particular customer has within a relativly short timespan (e.g. within a few seconds […]
2004-04-13
what is the value of print @servererrorwhen Server: Msg 17, Level 16, State 1, Line 1 happend?
2004-04-02
Sounds interesting...no doubt it will come with a performance penalty
2004-03-30
It is NOT EM who does that it just happens indirectly.Those ports are used by NBT or netbios over tcp/ip it is all because of the NAME resolution mechanism. To minimize that you may try to create either an alias of your server name with the client network utility pointing to the right ip address or […]
2004-03-19
This also is likely to happen when you have complex calculations to do. I have seen mainframe listing using log() and ln() stuff just to work around this impreciseness. Fortunately we now have decimal. How lucky we are
2004-02-27
The table is named "Rate" with 3 fields: 1) From_City varchar(50) 2) To_City varchar(50) 3) Cost intIt's a simple table, but is giving me a very big headache... If you need more info, just let me know.
2004-02-17
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
By Steve Jones
The survey is out now and you can share your experiences for a chance...
By Rob Sewell
"We can really be dangerous if we want, without being too afraid of it."
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers