Have you ever gotten connectivity errors from SQL Server? Jugal Shah explains the common causes for these errors, and advises on the steps you can take to resolve them.
Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you!
Hi all, I am trying to get this damned SQL XML Bulk Load to work and I have found that I can pass the ADO command to load it into the database.The 2 parameters I need are:1.) The XSD2.) The XML file to importThe problem I have is that the XSD file I have is […]
Here's a quote from BOL: "Built-in nondeterministic functions are not allowed in the body of user-defined functions." Getdate() is, of course, non-deterministic, as it "may return different values when called with the same input parameters" (input parameters being effectively NULL in this case). I haven't tried this, but you might be able to get round […]