That is (Company Removed) added to my SPAM filter and blocked internet sites!

SQL2000 also makes use of the INFORMATION_SCHEMA views. You can see the definitive list within the MASTER database.

Some of the system tables have changed in SQL2005 so I would...

bcp is one way. I use BCP to export the results from stored procedures.

You can use SQL Query Analyser .See The best kept secret about SQL Query Analyser....

It depends what you mean by huge

I had a requirement to produce a search that had certain compulsory search terms and a number of optional ones.

What I did was have...

I take it that these were not Windows Account users?

A login has an SID number which is unique to the box. SID 1 is the SA account.

If you recreated...

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