I created the lun and sized it too small. I can migrated the lun to a bigger lun. Just trying to find the best practice on maint plans...

Thanks.. I was looking at linked servers as well. What I just did was create a bat file with several sqlcmd statements and that did the trick.

thanks 🙂

Thanks for the replies, it got me looking at other things. I think their were several issues.

1. I had to recreate the job from scratch in...

Where do I modify the column type and size metadata? In the exernal or output columns of the flat file source or on the oledb destination? thanks a lot!

thanks for the help.

For now, the drop contraint is working. There were 2 other sp's that needed the drop contraint modification.

thanks

I passed that coding info on to our developers....

Is FullText Search enabled by default on each database?

So, you're saying just disable it on the db's and leave the cluster resource alone?

Is there a way to do it for...

Thanks for the good comments.

I tried deleting the tables in the gui but some have dependencies and gave foreign key contraint errors and did not delete. I may be...

Thanks. However.

It doesn't run due the tables already existing. Is there a problem with the import overwriting existing tables? I guess I could do a backup/restore as well,...

I appreciate the feedback.

thanks

I don't see any full text catalogs listed for any db's. Is it safe then to disable that service using the area coniguration manager?

thanks

I'm playing middle man here. I sent him your response and got this back. any ideas?

thanks

The Derived Column Transformation Editor doesn't seem to allow for different column...

Sorry, I don't know. I'm a system dba and don't know much about this view as it was created by on of our developers. We had noticed it...

Thanks y'all.

Awesome!

I just verified that the indexes(clustered) exist. I don't know what an execution plan is? I'm new to being a dba.

Also, If I run a select query...

What if I use an Execute As statement in the Trigger? Will that work? Or does the account logging in to the database need sysadmin rights in order...