Hi Malathi,

The SQL you are running would be of benefit to the rest of us.

The obvious things first though - are you sure that a database of that name exists...

As KK said, I'd change it to insert into a temporary table, and then check that table for the condition that would trigger the alerts you're after.

You could also write...

Hi,

TempDB is, as the name suggests, for temporary data - temporary tables you may have created in T-SQL, temporary tables that SQL itself decides it needs and such exciting things.

Certainly...

Hi,

I've also worked in several development environments where 2000 and 2005 have had to sit alongside each other, with no problems.

Hi,

Could you post the code that you are trying to run and the error that you are getting? This will help us see your problem.

Thanks.

Hi,

Write a function that takes the parameters needed and returns the value that you require and you can use that function within the Select.

My thanks to everyone who replied. I've managed to get what I wanted - a rewrite!

It is going to be the SP that I wrote and a slight change to...

Thanks for the reply to you both.

It needs to be a view because deep within the bowels of a VB system it is geared towards opening a table, and specify...

Bulk Insert in it's most basic form:

Create a temporary table that reflects the structure of the data you are inserting.

Place the text file you are importing onto a drive that...

Hi Ashok,

Is the C: drive that you have placed the file onto the same C: drive that SQL Server is using? If your SQL Server is running from another server...

Hi Shiva,

If you want to import an XML file purely via T-SQL, have a look at these examples:

http://msdn.microsoft.com/en-us/library/ms191184.aspx

http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx

which explains how to import the XML data from a file into a...

Hi Ian,

I have to agree with GermanDBA regarding the speed of the import.

Some time back I had to import large XML files into a 2005 DB with T-SQL, and although...