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...

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...