Page considered Suspect in SQL Server 2017

Resolving could not open a connection to SQL Server errors

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.

Error Logging Gone Wild

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!

XML Bulk Load - getting the XSD

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 […]

RE: "I renamed the file and it does not work"

You better be careful, your client might find your post here... Of course, if your client knew about this site they may actually have been able to restore a database properly...

RE: Using GetDate() in a User Defined Function

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 […]