If I may ask you about the design, why did you decide to keep varchar values instead of datetime in your table? I am almost certain conversion from datetime to...

Does it happen for all rows? Maybe there is a value that cannot be converted.

Regards

Piotr

What do you consider as high? If sql servers memory is not confined, the server will tend to take as much as it can. High CPU may be related to...

Probably you can use identity column on the ASSETINDEX. The MAX() + 1 approach is tricky and can kill performance.

Regards

Piotr

Hi,

Did you try to run the backup manually?

Also, I think there is more detailed information about the error. You have to click the '+' on the row showing the...

You have to explicitly convert the source value to the destination data type in this case, like this:

select convert(varchar(5), '123123123123')

Regards

Piotr

May I ask, where are date1, date2, date3 values taken from?

Regards

Piotr

Hi,

Would this work?

insert SPA03LS.ref_tbls..T_TEST

SELECT * FROM cash..T_TEST

Regards

Piotr

Hi,

Look at the INSERT..SELECT syntax in Books On Line. You don't have to read all rows in a loop and have a bunch of variables to keep constant values...

I think that you have to familiarize with parameters of BCP. You have to run it from command line, so first run cmd.exe and then type bcp. It will display...

Hi,

Unfortunately there is no such option in SSMS2005. There are third party tools that enable this. I know that SSMS Toolpack [/url] has such feature, although I never used it.

Regards

Piotr

Hi,

Try to create FORMAT file (using bcp) or use BULK INSERT and provide proper FIELDTERMINATOR parameter.

Regards

Piotr

Hi,

I guess this is due to the fact, that SQL Server does not access the file as you, but rather as the account it is running under. If it is...

I guess it depends on the type of processing the application is doing. What technology the application is written in? By the look of this design one might think the...

Try this:

select * from person.contact where LastName like '[A-N]%'

Regards

Piotr