Try this article

Frank Buchan and David Reed both make the point about weaknesses in business analysis contributing to poor code quality.

Quality is something that needs to be something applied to throughout a...

The INT method does not require any padding.

The user wants to query for a range of dates then

CREATE PROC dbo.MyQuery

@StartYear INT ,

@StartMonth INT ,

@EndYear INT ,

@EndMonth INT

AS

DECLARE @StartPeriod INT ,@EndPeriod...

You could use an INT (4 bytes) and record February as 200602

You could use SMALLINT (2 bytes) and record February as 602. Of course your would face the a...

I saw something like this years ago in an Australian television program.

I believe that these windmills are called Darrius windmills.

The BBC played part of George Bush's state of the...

Try RESTORE DATATASE [Your-database-name]

set dtsPackage = DTSGlobalVariables.Parent

Set sourceConnection = dtsPackage.Connections("Text File (Source)")

sourceConnection.DataSource = DTSGlobalVariables("PollingBaseDirectory").Value

The preceding 3 lines are in a DTS I use to upload a text file as specified in...

The release notes for SP4 say that it cannot be rolled back therefore take a full backup of everything before your attempt and install.

That said, I have not had any...

I don't know about that but I would jump to hotfix 2040 because SP4 (2039) has a bug that stops the SQL seeing all the memory in your server if...

You want to take a look at the SQLXMLBULKLOAD process. There are lots of threads on the site but I had a similar problem to you and got

The ZIP is on a local drive.

I will try and use StdOut but I am not optimistic.

Brian,

You forgot to mention the snippets!

type in ssf and press TAB and you get SELECT * FROM.

You can add your own as well so I have set up

derr to bring...

I should like to get my full MCDBA but it is expensive and ultimately I don't think it is reasonable to expect a company to pay for it all, however,...

If it is doing it during DEBUG I would suggest printing the LEN and the CODE() for the character that is being passed in.

Clearly DEBUG is translating the space in...

The only way that I can think of is to use an OPENROWSET and predefined connection but that isn't a way I would choose to do it.

Are you using Windows...