Andy, are you saying that indexes are updated during this process? I guess what I am asking is if I have a clusted index is the index moving data around...

Thanks a lot. This didn't work at first becase I had a few columns that didn't have a "," so it was returning -1 as part of the substring expressions...

I had 1 composite index setup on one of my tables which ran fine with one view that utilized the index, however the view that didn't utilize the index is...

I don't see any locks occurring. No, I don't recall this happening to any other views at the moment. Also, I do believe I didn't mention that this is...

Don't bother I just figured it out. Thanks for the help.

I must be missing something, because I do not see a Global Variables are within SQL Tasks. Where is it.

This is what I did. I opened and SQL Task...

That's what I thought. Thanks anyway.

I appreciate the help, but 1) I can't seem to get it to work, i'm still somewhat novice with some of the tools and 2) Am I doing the optimal...

I don't believe you can utilize bcp in a stored procedure. This is specifically to be utilized in batch files or at the command prompt. If I am completely...

Thanks guys. I guess I'll go with door #1.

🙂

quote:

---

Truncate is immediate and non-recoverable as is not logged. Even as part of a...

Do you think it could have been my Firewall (McAffee)? I just installed it about a month ago and I have more problems with my pc since doing so. I...

I agree that this would solve my problem, but down the road it will take more time and resources to do all that. I know there is a way...

where is the snap in located?

quote:

---

Use Meta data Services mmc snap-in and delete the objects from metadata repository as u wish

Greg, how would you handle this matter if it goes over 8000. My problem is that I am building tables dynamically for production to a website. Our customers can...

Very nice Greg. I tried the first one and it worked great.

I truly appreciate your help.

Scott

quote:

---

Never had that problem, but might try...