Can you post you bcp command line?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Unless you want to run from Midnight start of day 10 ago thru today current then look at CONVERT options to return date part only. For instance if you are...

Hints usually are not needed in the cost based method of querying data in SQL. You basic syntax I really could work without the where as I have no idea...

Personally using a cursor in VB app on the server is bad for performance especially if you have a lot of clients. However if you can post what you have...

I believe it is simply

ALTER TABLE tblName ALTER COLUMN colName NULL

on the table with the foreign key reference. Or are you wanting to enable allow nulls for the duration then...

Not without writing the entire process dynamically in a string and executing so it all runs in the same user context.

"Don't roll your eyes at me. I will tape them...

Not always unexpected as Security patches have a shorter test cycle than SPs. If you can reporduce this effect on another machine then definently report to Microsoft. They may not...

Ok let's try this again, SQL will try to keep cached as much as possible so that access to data resources can be as efficient as possible. Utilization of upto...

Why not just set you PK field to non-autogenerated and since PK's are unique the value comming in from Oracles PK should be fine. Or you may consider doing an...

Try something like this:

UPDATE tblPC SET location_name = 'fillintheblank' WHERE asset_tag IN ('List','Of','Asset','Tags','Here')

as long as all the locations will be the same. But you can use for common groups as...

Sorry the function deveopers in SQL did not leave a way for this to be done in SQL with dateadd. The only was is to build the SQL string dynamically...

When you say you are using a direct proxy connection can you elaborate on this? I ned to make sure my understanding is what you are talking about. Maybe I...

Nice ad simple, I have always been a proponent for XML and using to reduce access needs to the server.

"Don't roll your eyes at me. I will tape them in...

Change to this in the Get Indexes Field section

-- Get Indexes Field

(SELECT 1 FROM sysobjects c_obj, syscolumns col, sysindexes i

WHERE c_obj.uid = user_id()

AND c_obj.id = col.id

AND col.id = i.id

AND c_obj.xtype...

Missed that one too. I see your difference now and agree that I may be missing something else as well in regards to itemcode since you point that out.

"Don't roll...