I hate this

I'm migrating a fu... dts to SSIS. That's fine. I've got a derived column task for stuff as cdbl(DTSSource("Col014") /100).

But how the source plain file have a lot of columns suddenly I find this:

Function Main()

Fecha=Right(DTSSource("Col014"),2) & "-" & Mid(DTSSource("Col014"),5,2) & "-" & left(DTSSource("Col014"),4)
If IsDate(Fecha) then
DTSDestination("FechaOp") =Fecha
Else
DTSDestination("FechaOp")=null
End IF
Main = DTSTransformStat_OK
End Function

So that 'Derived Column' is useless at all for to encompass this rule unless to anyone be able to tell me how to implement that conditional snippet inside...

I'll be to use a Script Component Task only for that dammed column when the rest ones already defined.

!!!!

Do y'know hare and tortoise tale? So here is the same but in reverse order. jezz|||

There is a conditional operator in the SSIS expression language. It will do what you need to do.

Here's the BOL topic on it: http://msdn2.microsoft.com/en-us/library/ms141680(SQL.90).aspx

-Jamie

|||Thanks Jamie. hurries doesn't provide us good advices..|||

OK.

I've taken as example this and then I've converted into this line:

'Fecha = Right(DTSSource("Col014"), 2) & "-" & Mid(DTSSource("Col014"), 5, 2) & "-" & Left (DTSSource("Col014"), 4)
'If IsDate(Fecha) Then
' = Fecha
'Else
'DTSDestination("FechaOp") = null
'End If

Isdate(Right([Column 13],2) & "/" & Mid([Column13],5,2) & "/" & Left([Column13],4)) ? [Column13] : Nothing

But fails:

Error at CargaModelo187 [Derived Column [10345]]: Attempt to find the input column named "Column13" failed with error code 0xC0010009. The input column specified was not found in the input column collection.

Error at CargaModelo187 [Derived Column [10345]]: Attempt to parse the expression "Isdate(Right([Column 13],2) & "/" & Mid([Column13],5,2) & "/" & Left([Column13],4)) ? [Column13] : Nothing" failed and returned error code 0xC00470A2. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

Error at CargaModelo187 [Derived Column [10345]]: Cannot parse the expression "Isdate(Right([Column 13],2) & "/" & Mid([Column13],5,2) & "/" & Left([Column13],4)) ? [Column13] : Nothing". The expression was not valid, or there is an out-of-memory error.

Error at CargaModelo187 [Derived Column [10345]]: The expression "Isdate(Right([Column 13],2) & "/" & M

id([Column13],5,2) & "/" & Left([Column13],4)) ? [Column13] : Nothing" on "input column "Column 13" (11693)" is not valid.

Error at CargaModelo187 [Derived Column [10345]]: Failed to set property "Expression" on "input column "Column 13" (11693)".

Let me know which is the next step or what guidelines must I follow on this issue.

|||

In your expression you refer to "Column13" but the SSIS error message shows that the column in the data flow is in fact named "Column 13"

Donald

|||

A couple other things:

The expression language does not have an IsDate() function. What exactly are you testing for with that? Itstill might be possible, depending what you are looking for...

There is also Left() function -- you should use Substring() for that.

Instead of "Nothing", you need to use the NULL() functions, which are strictly typed.

|||

Mark Durley wrote:

There is also Left() function -- you should use Substring() for that.

Another alternative to the lack of a LEFT() function is RIGHT(REVERSE())

-Jamie

|||Thanks a lot to all of you|||

Well, this follow failing:

Right([Column 13],2) & "/" & SubString([Column 13],5,2) & "/" & SubString([Column 13],1,4) ? [Column 13] : Nothing

Column 13 on the first row own this value:

20050214

TITLE: Microsoft Visual Studio

Error at CargaModelo187 [Derived Column [10345]]: Attempt to find the input column named "Nothing" failed with error code 0xC0010009. The input column specified was not found in the input column collection.

Error at CargaModelo187 [Derived Column [10345]]: Attempt to parse the expression "Right([Column 13],2) & "/" & SubString([Column 13],5,2) & "/" & SubString([Column 13],1,4) ? [Column 13] : Nothing" failed and returned error code 0xC00470A2. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

Error at CargaModelo187 [Derived Column [10345]]: Cannot parse the expression "Right([Column 13],2) & "/" & SubString([Column 13],5,2) & "/" & SubString([Column 13],1,4) ? [Column 13] : Nothing". The expression was not valid, or there is an out-of-memory error.

Error at CargaModelo187 [Derived Column [10345]]: The expression "Right([Column 13],2) & "/" & SubString([Column 13],5,2) & "/" & SubString([Column 13],1,4) ? [Column 13] : Nothing" on "input column "Column 13" (12091)" is not valid.

Error at CargaModelo187 [Derived Column [10345]]: Failed to set property "Expression" on "input column "Column 13" (12091)".

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK

|||

I was wrong although this new line-version fails too...

[Derived Column 1] == Right([Column 13],2) & "/" & SubString([Column 13],5,2) & "/" & SubString([Column 13],1,4)

Thanks in advance,

|||

It's already solved.

Instead of & you must use + and drop '[Derived Column 1] =='

RIGHT([Column 13],2) + "/" + SUBSTRING([Column 13],5,2) + "/" + SUBSTRING([Column 13],1,4)

IsDate function is not necessary because of I saw concretly in that file that all of them have the same structure yyyymmdd

|||In any case what function is intented do the same that ISDATE?|||

There is no function that can do IsDate. As Mark suggested there may be possibilities using other functions - checking that a string has certain characters and that substrings, can be cast to valid integers - but that expression would likely be rather complex.

Script component does all this really nicely, of course.

Donald

I hate the maintenance CleanUp task :=)

I have a backup database task that runs at 4 am.

I added a maintenance CleanUp task pointing to the right folder
I checked the include first-level subfolder box, and delete files based on the age of the file at task run time

I specified "delete files older than " 1 day

But the cleanup task is not working, I have to manually go a delete the files myself.

Am I missing something? should I run the maintenance task first?
and then the backup task?

make sure that your system is upgraded to SP2 and also you have installed SSIS.

Refer these links for more info

http://support.microsoft.com/default.aspx/kb/933508

http://blogs.msdn.com/sqlrem/

Madhu

|||Also you make sure to apply SP2 for the client tools as they also willbe updated with bug fixes.|||

I'm having this problem, too. I have a Maintenance Cleanup Task to remove old maintenance plan text reports that seems to "refuse" to delete the old files. The system I'm trying this on has had the GDR 3054 update applied to all components, including the clients. I've even recreated the entire maintenance plan new, and it still doesn't work. The interesting thing is that my Cleanup Task that removes old backup files is working correctly!

|||

This has been confirmed as a bug

See http://support.microsoft.com/kb/936305

Maybe by SQL Server 2008 SP2 the Maintenace Plans may have got back to being usable and reliable

Regards

Nadreck

|||

This is not a solution or an answer to what Armando is asking.

What he says (and what Nadreck and I am experiencing) is the complete refusal of the maintenance cleanup task to delete the files...at *any* time.

Your links, as well as the other replies to this topic refer to a bug where existing maintenance tasks, created before SP2 being applied, are mis-timed after SP2 is applied. In my situation, the maintenance plan was created after SP2 was applied.

By not being able to automate the cleanup of the older backup files, it makes the entire backup task (as a scheduled process) nearly worthless.

Jeff

|||

Ok, after doing a lot of searching around the net I found out a workaround (sort of).

To get the maintenance plan to actually delete files in the first level subfolders, change the extension for it to delete (in the maintenance cleanup task dialoge) to *.*

I know this isn't ideal if you store files other than your backups in some of these folders (or rename old backups a different extension to always keep them around), but it did work for me. You just need to be careful what is put in those folders.

Jeff

I hate the maintenance CleanUp task :=)

I have a backup database task that runs at 4 am.

I added a maintenance CleanUp task pointing to the right folder
I checked the include first-level subfolder box, and delete files based on the age of the file at task run time

I specified "delete files older than " 1 day

But the cleanup task is not working, I have to manually go a delete the files myself.

Am I missing something? should I run the maintenance task first?
and then the backup task?

make sure that your system is upgraded to SP2 and also you have installed SSIS.

Refer these links for more info

http://support.microsoft.com/default.aspx/kb/933508

http://blogs.msdn.com/sqlrem/

Madhu

|||Also you make sure to apply SP2 for the client tools as they also willbe updated with bug fixes.|||

I'm having this problem, too. I have a Maintenance Cleanup Task to remove old maintenance plan text reports that seems to "refuse" to delete the old files. The system I'm trying this on has had the GDR 3054 update applied to all components, including the clients. I've even recreated the entire maintenance plan new, and it still doesn't work. The interesting thing is that my Cleanup Task that removes old backup files is working correctly!

|||

This has been confirmed as a bug

See http://support.microsoft.com/kb/936305

Maybe by SQL Server 2008 SP2 the Maintenace Plans may have got back to being usable and reliable

Regards

Nadreck

|||

This is not a solution or an answer to what Armando is asking.

What he says (and what Nadreck and I am experiencing) is the complete refusal of the maintenance cleanup task to delete the files...at *any* time.

Your links, as well as the other replies to this topic refer to a bug where existing maintenance tasks, created before SP2 being applied, are mis-timed after SP2 is applied. In my situation, the maintenance plan was created after SP2 was applied.

By not being able to automate the cleanup of the older backup files, it makes the entire backup task (as a scheduled process) nearly worthless.

Jeff

|||

Ok, after doing a lot of searching around the net I found out a workaround (sort of).

To get the maintenance plan to actually delete files in the first level subfolders, change the extension for it to delete (in the maintenance cleanup task dialoge) to *.*

I know this isn't ideal if you store files other than your backups in some of these folders (or rename old backups a different extension to always keep them around), but it did work for me. You just need to be careful what is put in those folders.

Jeff

sql

I HATE Management Studio, how about you?

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).

For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.

Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.

Microsoft get a clue. Trying listening once in a while.Hi JJ,

It would help if you actually list things you dislike instead of just
ranting it doesn't do very much for your credibility, you simply come across
as probably one of those anti-MS whatever they do people - aka the linux
fanbregade.

I agree there are aspects of Management Studio that I dislike but those are
being addressed by Microsoft and believe those guys do listen to what WE as
the people who use the tools and product need.

So, lets try again - please list aspects of MAnagement Studio you dislike.

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials

"jj" <jj@.no_spam.netwrote in message news:e8tt3n$fnl$1@.lists.fhcrc.org...

Quote:

Originally Posted by

>I really dislike the Management Studio in SQL Server 2005. Having tabs is
>nice but everything else about it really sucks. What don't you like about
>it? Maybe someone at M$ will read this and actually make some changes --
>for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one before.
I can hardly stand to use Visio any more. Word has so many damned annoying
features that I spend most of time trying to figure out how to turn them
off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the time.
One of the biggest problems M$ has is arrogance. They 'know better' than
the whole user community.
>
Microsoft get a clue. Trying listening once in a while.
>
>
>

|||jj (jj@.no_spam.net) writes:

Quote:

Originally Posted by

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.
>
Microsoft get a clue. Trying listening once in a while.

Management Studio is definitely not the part of SQL 2005 that I am most
impressed by. There are some nice improvements from Query Analyzer, but
there are too many features that have been dropped from the old tools.

If you go http://connect.microsoft.com/feedba...aspx?SiteID=68
you can submit suggestions for improvements. Such suggestions would
have to be a little more nuanced than "get a clue" to be meaningful. :-)
I would also encourage you to search among the existing bugs. There
are already plenty of entries for Mgmt Studio filed. And fact is,
MS have been listening. It looks that some of the issues will be
mended by SP2 already.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I like Management Studio. I've replaced the old Query Analyzer and
Enterprise Manager with this one. I used it for both SQL 2005 and SQL
2000; they are fine. Except one thing though; if I edit a table, the
default column has to be filled in; otherwise it will be filled with
NULL, eventhough the table is defined as NOT NULL DEFAULT something;

regards,
Radzi.

jj wrote:

Quote:

Originally Posted by

I really dislike the Management Studio in SQL Server 2005. Having tabs
is nice but everything else about it really sucks. What don't you like
about it? Maybe someone at M$ will read this and actually make some
changes -- for the better (sigh, I wish but I won't hold my breath).
>
For all the $$$$$ Microsoft spends you think they could do better. It
seems every 'new and improved' version has a worse UI than the one
before. I can hardly stand to use Visio any more. Word has so many
damned annoying features that I spend most of time trying to figure out
how to turn them off rather than getting real work down.
>
Living in the shadow of the evil empire I run into M$ dweebs all the
time. One of the biggest problems M$ has is arrogance. They 'know
better' than the whole user community.
>
Microsoft get a clue. Trying listening once in a while.

I has problem to run EXEC in MSDE 8.00.760

I used the MSDE 8.00.760. I try to run EXEC from the command line, but it is
not recognized as a command ... I can run the osql in the command line. Does
someone knows what is the problem?
Thanks in advance.
hi,
LittlePlane wrote:
> I used the MSDE 8.00.760. I try to run EXEC from the command line,
> but it is not recognized as a command ... I can run the osql in the
> command line. Does someone knows what is the problem?
>
AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
recognized by the underlying OS but only from applications that can send it
to a SQL Server instance...
is it a particular application?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi, thanks, I am new with SQL. I know how to do it now.
"Andrea Montanari" wrote:

> hi,
> LittlePlane wrote:
> AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
> recognized by the underlying OS but only from applications that can send it
> to a SQL Server instance...
> is it a particular application?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

I had set my Windows service's Startup Type as Automatic but it is not starting up Automaticall

Hello,

I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.

I checked the Event Viewer and it has the following message related to the Windows Service :

Service cannot be started. The service process could not connect to the service controller.

What Does This mean am I missing something.

|||I think the C# forums might be more useful for answering this particular question unless you have a SQL Server Question related to this?|||

Thanks John Gordon,

I had posted it again to the C# Section. By Mistake I had posted it in this section.

Thanks and Regards

Sunil Dutt

i had a problem in inserting data in a table with foriegn key

i hav following 2 tables n i am able to insert data into the second table having a foriegn key

create table Customer_Details(
Customer_ID integer primary key,
Customer_First_Name varchar(75),
Customer_Last_Name varchar(75),
Address varchar(100))

create table Account_Details(
Account_No integer primary key,
Customer_ID integer foreign key references
Customer_Details(Customer_ID),
Debit float,Credit float,Balance float )hi
can u please put ur insert and also when a column is PK it cant be null. when u do not put any think then that means it also can be a null value but pk can't be null at all.

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?sql

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happend with my database?

Hello,

How are you acessing the DB?

Do you have 2 Destinations pointing to the same DB file?

Is that error in the SSIS?

Regards,

I got error when installing MSDE

I got a message when I type in :
setup SAPWD=abc SECURITYCODE=SQL
and setup the MSDE, there is an error said
"Unable to determine system default collatution."
What can I do?
Bill,
I think you cannot use abc, password, or anything that easy as pwd.
"Bill" wrote:

> I got a message when I type in :
> setup SAPWD=abc SECURITYCODE=SQL
> and setup the MSDE, there is an error said
> "Unable to determine system default collatution."
> What can I do?
>
|||Bill,
check MSDN knowledge base article 823466... may be able to help... also
check knowledge base articles for "Unable to determine system default
collation", there were several articles...
hope this helps!
wardeaux
"Bill" <vbpro@.hgcbroadband.com> wrote in message
news:017a01c48b9b$b6d04230$a401280a@.phx.gbl...
> I got a message when I type in :
> setup SAPWD=abc SECURITYCODE=SQL
> and setup the MSDE, there is an error said
> "Unable to determine system default collatution."
> What can I do?
sql

I got Distribution Agent failure

I got Distribution Agent failure
however everything working correctly, it's allways red x on distribution
agent.
I have transactional replecation between two virtual computer, i replecate
all tabels from my database, everything work correct however i got red X on
replication monitor, on distributer agene. Also i did'nt find any errors in
history of distributor agent.
When i change some rows on publisher and after this run agent i see the
changes?
Any ideas ?
Message posted via http://www.droptable.com
Please try running sp_MSload_replication_status.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul.
After running this procedure i got : The command(s) completed successfully.
and the return value is 0.
it doesn't print anything else.
Message posted via http://www.droptable.com
|||But does the red circle disappear when you refresh the replication agents?
Rgds,
Paul Ibison
|||O yeeeeeeeeeee. u r great.
However what happen wheb i was run this procedure, please explain.
Thanks. .
Message posted via http://www.droptable.com
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
table. You might notice that a reboot also solves the issue - when you
restart the sql server service the msdb is recreated from the model database
so it has the same effect.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Sorry - meant the tempdb gets recreated, not the msdb...
paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eVqGZyCaFHA.3712@.TK2MSFTNGP09.phx.gbl...
> The replication monitor gets its info from
> tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
> table. You might notice that a reboot also solves the issue - when you
> restart the sql server service the msdb is recreated from the model
> database so it has the same effect.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

I got an error when I restored database

Hi Guys,
I got an error when I restored database. I tryed to restore a database that
is 8G. I got an error that is "An internal consistency error occured. Contact
technical support for assistance. RESTORE DATABASE is terminating
abnormally", then the database was marked Loading and in suspect mode. I try
to use command restore database policy with recovery, then got
errorimmediately:
File 'changept' was only partially restored by a database or file restore.
The entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I did restore this database two weeks ago in other database server and was
successful, but it is failed in this new server now. I don't know what reason
is. I need the help. Thank in advance.
Hi
"Iter" wrote:

> Hi Guys,
> I got an error when I restored database. I tryed to restore a database that
> is 8G. I got an error that is "An internal consistency error occured. Contact
> technical support for assistance. RESTORE DATABASE is terminating
> abnormally", then the database was marked Loading and in suspect mode. I try
> to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what reason
> is. I need the help. Thank in advance.
Have you copied the backup onto this server? The backup itself may be
corrupted try doing a RESTORE HEADERONLY command from query analyser. It is
not clear how you are restoring this file, try using query analyser to
restore the database if you are using EM then you can post the command you
are using. As this is a new server, the database does not need to exist
before you restore it. Are you putting the files in a different location?
Check that you have permissions and enough space to do this.
If the database exists on a different server you may want to either detach
the database and copy the MDF/LDF files and re-attach them (to both servers!)
or backup from one server to the other using a UNC path for the backup file,
so that you don't have to copy the backup file.
HTH
John
|||>I try to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what reason
> is. I need the help. Thank in advance.
Can we assume that this is the actual same backup file you are talking about
having restored before? This looks like there may be multiple backups in this
file and it is trying to restore a log file backup before restoring the full
backup.

I got an error when I restored database

Hi Guys,
I got an error when I restored database. I tryed to restore a database that
is 8G. I got an error that is "An internal consistency error occured. Contac
t
technical support for assistance. RESTORE DATABASE is terminating
abnormally", then the database was marked Loading and in suspect mode. I tr
y
to use command restore database policy with recovery, then got
errorimmediately:
File 'changept' was only partially restored by a database or file restore.
The entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I did restore this database two weeks ago in other database server and was
successful, but it is failed in this new server now. I don't know what reaso
n
is. I need the help. Thank in advance.Hi
"Iter" wrote:

> Hi Guys,
> I got an error when I restored database. I tryed to restore a database tha
t
> is 8G. I got an error that is "An internal consistency error occured. Cont
act
> technical support for assistance. RESTORE DATABASE is terminating
> abnormally", then the database was marked Loading and in suspect mode. I
try
> to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what rea
son
> is. I need the help. Thank in advance.
Have you copied the backup onto this server? The backup itself may be
corrupted try doing a RESTORE HEADERONLY command from query analyser. It is
not clear how you are restoring this file, try using query analyser to
restore the database if you are using EM then you can post the command you
are using. As this is a new server, the database does not need to exist
before you restore it. Are you putting the files in a different location?
Check that you have permissions and enough space to do this.
If the database exists on a different server you may want to either detach
the database and copy the MDF/LDF files and re-attach them (to both servers!
)
or backup from one server to the other using a UNC path for the backup file,
so that you don't have to copy the backup file.
HTH
John|||>I try to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what rea
son
> is. I need the help. Thank in advance.
Can we assume that this is the actual same backup file you are talking about
having restored before? This looks like there may be multiple backups in thi
s
file and it is trying to restore a log file backup before restoring the full
backup.

I got an error of login "sa" with Error 18456 Level 14

I got an error of login "sa" with Error 18456 Level 14 .
Server A is the MSSQL Server where the database sit and
the other Server B is just with MSSQL Server tool which
act as a Terminal Service and have the Accounting
applications.The Accounting application unable to perform
its database transfer to another application on the
Terminal Service. We use Window 2003 Server. The
application programs are fine. The ODBC, MSSQL and
application "sa" password are identical. Any idea? ThanksHow many times are you going to post this? See the replies in all the other
groups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc101c46fbb$b7341db0$a601280a@.phx.gbl...
> I got an error of login "sa" with Error 18456 Level 14 .
> Server A is the MSSQL Server where the database sit and
> the other Server B is just with MSSQL Server tool which
> act as a Terminal Service and have the Accounting
> applications.The Accounting application unable to perform
> its database transfer to another application on the
> Terminal Service. We use Window 2003 Server. The
> application programs are fine. The ODBC, MSSQL and
> application "sa" password are identical. Any idea? Thanks

i got an err msg

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

-

so what i should do?

to mach for a biginer,

where is this file

thanks

i did add this to the web config file

<configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>

but its wouldnt halps

|||

also tried to add

configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
>
to
\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG
machine.config
but it wouldn't help.

well i hope you don't think i not to mach of a beginner for you guys

|||Hi,

I am not quite sure where you actually get the error message, you just posted the error message and we don′t know in which context this relates to SQL Server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

sql

I got 2 question, if tempdb is full, how to fix it? 2. if I have f

I got 2 questions, if tempdb is full, how to fix it? 2. if I have full backup
yesterday and no transaction log today and I delete data by accident, is
there any way to recover it?
Thanks.1)
http://www.aspfaq.com/show.asp?id=2446
2)
http://www.lumigent.com/ --explorer log for sql
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com...
>I got 2 questions, if tempdb is full, how to fix it? 2. if I have full
>backup
> yesterday and no transaction log today and I delete data by accident, is
> there any way to recover it?
> Thanks.
>

I got 2 question, if tempdb is full, how to fix it? 2. if I have f

I got 2 questions, if tempdb is full, how to fix it? 2. if I have full backu
p
yesterday and no transaction log today and I delete data by accident, is
there any way to recover it?
Thanks.1)
http://www.aspfaq.com/show.asp?id=2446
2)
http://www.lumigent.com/ --explorer log for sql
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com...
>I got 2 questions, if tempdb is full, how to fix it? 2. if I have full
>backup
> yesterday and no transaction log today and I delete data by accident, is
> there any way to recover it?
> Thanks.
>

I give up on this one...

I have tried and tried to get this to work and I'm doing something dumb.
I'm going to include sample data and my format file. Can someone help
me figure out my dumb mistake on a bulk insert using a format file?
Don't worry about data types, I'll handle that later. Thanks a lot!!!

CSV File:

ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
kComparedTo
1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
2,name2,Family Practice General
Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
3,name3,General Practice,GP,PCP,address3,Deerfield
Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
4,name4,Reproductive
Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4

Format File:
8.0
31
1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS

Here's a script for the table!

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Provider_Results]
GO

CREATE TABLE [dbo].[Provider_Results] (
[Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[NetworkComparedTo] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[forceMatchUserId] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[paymentPlatforms] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[matchStatusColor] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Thanks again. I am dying on this one. With everything included
hopefully someone (smarter than me) can figure it out.

Thanks,

Andrew

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Might look at the solution Erland gave me...
see subject "Bulk Insert Problems"

HTH

CBL

"Andrew Slentz" <ajslentz@.yahoo.com> wrote in message
news:40cf845e$0$25534$c397aba@.news.newsgroups.ws.. .
> I have tried and tried to get this to work and I'm doing something dumb.
> I'm going to include sample data and my format file. Can someone help
> me figure out my dumb mistake on a bulk insert using a format file?
> Don't worry about data types, I'll handle that later. Thanks a lot!!!
> CSV File:
> ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
> ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
> act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
> forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
> kComparedTo
> 1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
> Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
> Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
> 2,name2,Family Practice General
> Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
> 7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
> 3,name3,General Practice,GP,PCP,address3,Deerfield
> Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
> Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
> 4,name4,Reproductive
> Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
> 00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4
>
> Format File:
> 8.0
> 31
> 1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
> 2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
> 3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
> 4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
> 5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
> 6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
> 7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
> 8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
> 9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
> 10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
> 11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
> 12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
> 13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
> 14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
> 15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
> 16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
> 17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
> 18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
> 19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
> 20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
> 21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
> 22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
> 23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
> 24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
> 25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
> 26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
> 27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
> 28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
> 29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
> 30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
> 31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS
> Here's a script for the table!
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
> N'IsUserTable') = 1)
> drop table [dbo].[Provider_Results]
> GO
> CREATE TABLE [dbo].[Provider_Results] (
> [Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [NetworkComparedTo] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
> ,
> [forceMatchUserId] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [paymentPlatforms] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [matchStatusColor] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
> ) ON [PRIMARY]
> GO
> Thanks again. I am dying on this one. With everything included
> hopefully someone (smarter than me) can figure it out.
> Thanks,
> Andrew
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Might look at the solution Erland gave me...
see subject "Bulk Insert Problems"

HTH

CBL

"Andrew Slentz" <ajslentz@.yahoo.com> wrote in message
news:40cf845e$0$25534$c397aba@.news.newsgroups.ws.. .
> I have tried and tried to get this to work and I'm doing something dumb.
> I'm going to include sample data and my format file. Can someone help
> me figure out my dumb mistake on a bulk insert using a format file?
> Don't worry about data types, I'll handle that later. Thanks a lot!!!
> CSV File:
> ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
> ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
> act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
> forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
> kComparedTo
> 1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
> Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
> Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
> 2,name2,Family Practice General
> Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
> 7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
> 3,name3,General Practice,GP,PCP,address3,Deerfield
> Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
> Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
> 4,name4,Reproductive
> Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
> 00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4
>
> Format File:
> 8.0
> 31
> 1 SQLCHAR 0 1 "\r\n" 0 quote Latin1_General_CI_AS
> 2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
> 3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
> 4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
> 5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
> 6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
> 7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
> 8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
> 9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
> 10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
> 11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
> 12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
> 13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
> 14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
> 15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
> 16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
> 17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
> 18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
> 19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
> 20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
> 21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
> 22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
> 23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
> 24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
> 25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
> 26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
> 27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
> 28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
> 29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
> 30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
> 31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS
> Here's a script for the table!
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
> N'IsUserTable') = 1)
> drop table [dbo].[Provider_Results]
> GO
> CREATE TABLE [dbo].[Provider_Results] (
> [Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [NetworkComparedTo] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
> NULL ,
> [forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
> ,
> [forceMatchUserId] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [paymentPlatforms] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [matchStatusColor] [varchar] (3000) COLLATE
> SQL_Latin1_General_CP1_CI_AS NULL ,
> [recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
> ) ON [PRIMARY]
> GO
> Thanks again. I am dying on this one. With everything included
> hopefully someone (smarter than me) can figure it out.
> Thanks,
> Andrew
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!