Sjeef (2/8/2011)

---

why would you go into reading line per line and insert that into the dataview.?

put the result of your sqlstatement into a dataset

dim myds as dataset = new dataset("sqlstmt","sqlconenction")

then...

No, the constraint will not let you delete the Country because it...

Ram this seemed a little too straight forward...simple CONVERT commands seem to work fine for me...what am i missing on your question?

With tblA(CustomerKey,CustomerID)

As

(

SELECT N'000098878787',N'284005' UNION ALL

SELECT N'000089898989',N'284005' UNION ALL

SELECT...

so your script is using a hardcoded path, and sometimes the path does not exist, right?

i'd build the path to the files based on the existence of data i can...

doh i didn't even think about if there were any math functions in the bodies; good catch; i'm not sure on the commented comments...

i think i got it...try my updated post, which assumes that same function. does that get you where you wanted to be?

the second part to test for EXISTs is not so easy;

looking at our code base, we have a couple of different styles for people using EXISTS:

IF exists(select specificColumnName

---

IF exists(

select *...

I agree with Gus, it's not all that easy; At first,i couldn't think of how to do it in a single query and thought i might using a cursor for...

my first instinct would be to confirm that the objects that appear in this list need to be scripted to move their clustered index to the default partition(or dropped), and...

could it be that the step is running in the master database instead of the db the proc is in? what if the command was changed to have the full...

the error "string or binary data would be truncated". is specific to char/varchar fields...it doesn't have anything to do with integer fields.

since the command you are using doesn't even touch...

This should help you Find all the traces on the server, and builds the commands to stop/drop the trace as well...

avoid using the command to drop teh default trace(is_default =...

I think we'd want to see the actual execution plan to be sure, you might benefit from posting that.

i think the issue is going to be related to this:

AND (endDate...

wouldn't this occur if the indexes were being rebuilt with the option SORT_IN_TEMPDB?

paging your data requires some sort of key...whether it's the PK/identity of the table, or by using row number.

assuming you have a "Next" button on your application to get the...