In SSIS when you build the package you can specify the code page. Open the connection manager for the flat file. You should see a code page...

I would also look at the COALESCE() function. This allows more than one arguement to be evaluated and is also the ansi standard. But isnull also works!

Well.. there seems to several issues you need to addreess.

First your line of code where you say "WHILE 0 =0" is an infinite loop logic. How would zero never...

Unfortunately I don't have the answer for you question. But I wanted to offer other possible solutions. First option is to output the wmi to something other than...

You need to specify more information about what you need, the schema of the table, the setup of the environment if you want specific help. The answer will vary...

Truncate will not work if he has FKs/constraints. However have you tried setting the reseed to 1? Per BOL:

the first row inserted after you run DBCC CHECKIDENT uses...

This database is movable in 2005. Is it not in 2K8? I know its movable because the person before me at this job moved it and when I...

There are two ways to replay a trace. One where it it waits to mimic the real run time and one where it does not. So for example...

The issue is not with the .net code. SQL itself does not allow you to use a variable as part of an in clause. So you really have...

I would think another option might be the use of SSIS. Create two connection managers (one sql and one oracle). Then you can bring in the data sets...

I don't know the answer, but I will ask a silly question. Why are you using a jdbc driver? If you are using crystal and connecting to a...

Without knowing more about your application, data, etc its almost impossible to determine which design is best. I would tend to put an attribute like color on the Food...

Normal. The DBCC command is causing the rollback/forward messages.

You are missing standard syntax.. try

insert into @tlb1

select col1

from @tbl2

You are missing the @ on the from table to for the insert. So you need...

The issue I believe is the fact that you are returning the password in the stored procedure using the RETURN statement. This is trying to convert it to INT...